Eloquent where(): 6 "Tricks" You May Not Know

Рет қаралды 9,448

Ай бұрын

Over the years, I've seen a lot of less-known usages of where() in Eloquent and Query Builder, let me show you a few of them.
Links mentioned in the video:
- Docs: Basic Where Clauses: laravel.com/docs/11.x/queries...
- Docs: Additional Where Clauses: laravel.com/docs/11.x/queries...
- Docs: Advanced Where Clauses: laravel.com/docs/11.x/queries...
- My course "Laravel Eloquent: Expert Level" laraveldaily.com/course/larav...
- - - - -
Support the channel by checking out my products:
- My Laravel courses: laraveldaily.com/courses
- Filament examples: filamentexamples.com
- Livewire Kit Components: livewirekit.com
- - - - -
Other places to follow:
- My weekly Laravel newsletter: us11.campaign-archive.com/hom...
- My personal Twitter: / povilaskorop

Пікірлер: 14

@fanievdm1 Ай бұрын

Thanks for the tips. One tends to do the 'old stuff' instead of enhancing your code. The tips are very helpful.

@chlouis-girardot Ай бұрын

Such valuable information/reminders, thank you (again) Sir! 🙏

@LoganathanNatarajanlogudotcom 27 күн бұрын

Thanks for the detailed explanation..

@asfiaaiman3699 29 күн бұрын

Thanks for these useful tips

@maxzak5310 Ай бұрын

i like whereAll , whereAny ... very handy

@muhammadumarsotvoldiev8768 Ай бұрын

Thank you very much!

@SebastianMares Ай бұрын

One thing I cannot stress enough is orWhere with scopes or relations. Always use a callback for your orWhere statements. $author->posts()->where('foo', 'bar') will give you all posts belonging to the author where foo is 'bar', but $author->posts()->where('foo', 'bar')->orWhere('abc', 'xyz') will no longer have abc = 'xyz' scoped to the $author. Same goes with scopes. $builder->where('created_at', '', 500); will probalby also not yield what you were expecting.

@SXsoft99 Ай бұрын

what i always tell people "read the docs". I get it if you come from other frameworks it's a pain

@NitishKumarPatra Ай бұрын

I didn't get the info about created_at won't work if there is a index on it, and would work then index is created with date ?? Could you please make a video on it ? Such conditions are commonly used throughout projects, but i guess many are unaware, including me.

@LaravelDaily Ай бұрын

I mean you need to create an index on DATE(created_at) and not created_at, not sure it needs a video

@fredchess Ай бұрын

Please what do you use to make quick printing like this?

@LaravelDaily Ай бұрын

Tinkerwell

@BBB888BBB Ай бұрын

would you please explain why the word(data) is put in page.jsx when using inertia ? example : to loop : projects.data.map(project).... i saw this and i don't know why . ( in working laravel with react inertia) i saw that .

@LaravelDaily Ай бұрын

From what I remember, it's how Laravel API resources return the data by default. Read the docs of Eloquent API resources.