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:
https://github.com/thecodeholic/yii2-course/tree/quering-data

Documentation:
https://www.yiiframework.com/doc/guide/2.0/en/db-query-builder

-------------------------------------------------------------------------
Check my other videos about yii2 framework
-------------------------------------------------------------------------
Yii2 Crash course: https://youtu.be/sRJ6GYiCwkI
Building a REST API using yii2: https://youtu.be/XyHHMvRt6Cw
Integrate Landing page into yii2: https://youtu.be/eJBQeRocRac

Getting started with yii2 framework: https://youtu.be/JD5Y-lQNrPs
Migrations: https://youtu.be/V8NFXrr1JNI
Working with DAO: https://youtu.be/zOqUePK-01k
Working with Active Record classes: https://youtu.be/Vid_G04kLp4

Check my Github:
https://github.com/thecodeholic

Follow me on social media:
https://www.facebook.com/thecodeholic
https://twitter.com/thecodeholic