preloader
學習 Laravel 5.5 Eloquent relation whereHas and whereRaw usage

Version: Laravel 5.5 Model: Post, Comment Post’s columns: id, title, content, created_at, updated_at Comment’s columns: id, post_id, content, c_date, c_time, u_date, u_time Relation: A post has many comments and a comment belongs to a post. The following shows how to get posts, which had been comments in recent 24 hours. use CarbonCarbon; // use package Post::whereHas('comments', function ($query) { $query->whereRaw('(u_date = ? AND u_time >= ?) OR (u_date =? AND

read more

About

Howard Lee is a Staff Software Engineer based in Taipei, specializing in frontend architecture, CI/CD, and production-quality engineering for enterprise web applications. With 13+ years of software development experience, Howard has worked across B2B SaaS, IoT energy-management platforms, online travel marketplaces, and Android applications. His work focuses on modernizing large frontend systems, improving delivery quality, and building reliable product workflows with automated testing, observability, and practical cloud/platform integration. Core Expertise Frontend architecture: Angular 5 to 19 modernization, TypeScript, JavaScript, React, Next.

Know More

Tag

Social