Tag "eloquent" tricks

laravel globale search

Easy way to create many filters aggregated in Eloquent with query string

Save yourself from all the boilerplate of tracking/observing and reacting to model attribute changes.

This query searches the data from the Table and also with its relation table columns dynamically.

Get products count which are under sub categories of a parent category

Using laravel eloquent, you have an amazing feature called `Accessors`, which allows you to define a non-existing column, here's an example to get user full_name that does not exist in the users table

If you have DB column which you want to be set only once and never updated again, you can set that restriction on Eloquent Model, with a mutator

What if you’re working with non-Laravel database and your timestamp columns are named differently? Maybe, you have create_time and update_time. Luckily, you can specify them in the model, too

You can filter by NULL in Eloquent, but if you're filtering the collection further - filter by empty string, there's no "null" in that field anymore.