Laravel Queries: Group AND-OR Conditions to Avoid Errors

Показать описание

If you have a complex DB query with multiple AND/OR conditions, there's one mistake you need to avoid. In this video, I will show you what the mistake is, what is the bad result of it, and how to fix it.

Support the channel by using one of these:

Laravel Daily

Рекомендации по теме

Комментарии

I dont know why, but I watch all of your videos. I think it is because these go straight to the point and are informative. Keep going...

JohnnyBigodes

Hi, I really like the way you explain the laravel concepts and implementation. Thank you so much! Could you include some videos like joining multiple tables in a database, what all are the possible errors, and so on? It would be of great help!

johangeorge

You can also use $query->dd(); instead of dd($query->toSql());

JaimeNetoBr

OMG Thank you so much!!! Literally had the exact same mistake!!!

cutiex

thank you so much i was searching this for so long ❤️

kamleshpaul

For me a interest scenario is when there are so many conditional queries. I don't like many "when" for each sentence, it is not scalable for medium or big applications.
Do you know a sentence that makes easy like validate the data and pass it to a simple method? I head about specification pattern but I don't know how to implement it.
Regards.

maximilianominetto

if in a form nothing is required but at least one have to select or user can select all then how should I manage the query ? Thanks in advance sir.

santanudas

You should probably make a video about getting coronavirus data via API. Since data is updated only 2 or 3 times a day, this will be a good use case for cache.

alexrusin

Thanks so much, it's beautiful tricky

ahmedhdeawy

You are targeting the real mistakes, everyone did unintentionally and then searching wheres the mistake. 👍

nabeelyousafpasha

Where can I find you code? Looks like a sortable table in Frontend. I am interested in this frontend table 👍

Cris-prwl

that's really nice video
but I mostly preferred this in this type of situation
and can we use CASE statements in Eloquent way if yes so Please make one video on it
thanks :)

devappsinvo

Can u p please give some example regarding laravel passport for api that would be really helpful

vasudevane.p

funny how query is searching date > 9 and date <= 65 and returns the opposite :)

raimonds.L

Laravel Queries: Group AND-OR Conditions to Avoid Errors

Laravel Queries: Group AND-OR Conditions to Avoid Errors

Laravel Eloquent Report: Group By Year with Raw Queries

Laravel Group Data: in Collections or in Eloquent Query?

Eloquent Practice: Group By Month and Company

Laravel GroupBy: 3 Practical Examples

Eloquent Practice: Group By Raw and HasMany

Laravel: Multiple Where Clause Query Using Eloquent

Laravel Eloquent Group By Example

Why I Sometimes Use query() Method?

Eloquent withCount with Conditions and Aliases

New in Laravel 8.12: Explain Eloquent Query

Supercharge Your Laravel Queries: Mastering Select, Group By, and Having Clauses #laravel #shorts

What SQL Queries Are 'Under' Eloquent?

Eloquent Example: Group Data with Multiple Calculations

Laravel: Eloquent 'Tricks' to Query Dates from DB

Eloquent: Query 3-Level Relations with hasManyThrough and withCount

How to use the Query Builder correctly in Laravel | Tutorial | Quick Win Wednesday #QWW

Learn Laravel 8 Beginners Tutorial #36 Query Builder in Laravel - Select Queries - AND OR Operators

5 tips for supercharged Laravel Eloquent queries

Eloquent Many-To-Many: Simple Query Example

How to use Group Concat in laravel Joining | Laravel Group By | Laravel 8 | Learning Points

How to Create Multiple Where Clause Query Using Laravel Eloquent?

8 Common Mistakes Made by Laravel Developers And How to Fix Them [w/ Examples]

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)