Student Reviews
( 5 Of 5 )
1 review
Video of Working with Yii2 Database Access Objects (DAO) yii2 tutorials in Yii2 course by The Codeholic channel, video No. 19 free certified online
The following video covers working with database with DAO.
- Connecting to any RDBMS (Mysql is used as an example)
- Execute SQL queries using DAO
- Bind parameters to SQL queries
- INSERT, UPDATE, DELETE
- Insert multiple records
- User one column as an assignment value during insert or update
- Using upsert method to create or update existing record in database
- Properly quoting tables and column names using backtick
- Using table prefix.
Source files:
https://github.com/thecodeholic/yii2-course/tree/working-with-database-dao
Read more about DAO:
https://www.yiiframework.com/doc/guide/2.0/en/db-dao
Connection class API Docs:
https://www.yiiframework.com/doc/api/2.0/yii-db-connection
Command class API Docs:
https://www.yiiframework.com/doc/api/2.0/yii-db-command
----------------------------------------------------------------------------------
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
Controllers: https://youtu.be/cdVN62BxDZA
Views & Rendering content: https://youtu.be/gZ81sPL4MmM
Layouts: https://youtu.be/69zKqHrU5-Y
Widgets: https://youtu.be/ebkwCRx5zoE
Check my Github:
https://github.com/thecodeholic
Follow me on social media:
https://www.facebook.com/thecodeholic
https://twitter.com/thecodeholic