Querying data using Query Builder | yii2 tutorials

In this video we will see how query data using query builder so that our select can be run on multiple relational databases.
We are going also to see how to deal with the problem when framework improperly quotes column names with back ticks which causes SQL syntax error.

The methods explained in the video.
- select()
- from()
- where(), andWhere(), orWhere()
- all(), one(), count(), column(), scalar(), exists()
- limit()
- offset()
- orderBy()
- groupBy()
- having()

Source Code:

Documentation:

-------------------------------------------------------------------------
Check my other videos about yii2 framework
-------------------------------------------------------------------------

Check my Github:

Follow me on social media:

[juststudying]

Thanks Great Course.
We need advanced one please

[zeresibiira]

thanks for the explaination, it is so helpfull, i am a big fun of your videos, more vedios like this please

[NicoILeone]

Excellent! Very well explained, and very well made the comparison with an active record model. Cheers!

[nyke]

Thanks for the outstanding explanation! I‘m a big fan of your videos!

[NoContextAi]

As always great content and great explanation <3 keep it up :)

[qrjziok]

hi i have a question concerning widget could you do a video where you can explain how can we use vujs or react js to implement our own widget or trying to make our widget more prettier and thank you

[naresh]

You used groupBy() and new sql version does not support it .So how do you write query without using groupBy()?
Example:
$model =