? ??????? ??? ??? ?? ??? ??? ?? ? ???????. ??????? ??? ??? ?????. ? ????? Yii ?????? ?? ??? ?????. ?? ?????? ??? ????? ?? ???? ???? ? ?? ??? ?????.

Yii ?????? MVC ?? ??? ??? PHP ????????. ?? ?? ??? ?? ??? ???? ?? ??? ?? ?? ? ??? ?? ??(QueryBuilder)???. ?? ??? ???? ?? ?? ?? ??? ???? ?? ??? ???? ??????? ?? ??? ? ????.

?? SQL ?? ?? ?? ??? ?? ?? ?? ??? ???? SQL ?? ?????. ??? PHP ??? ???? ??? ?? ??? ????, ?? ??? ??? ??? ?? SQL ??? ???? ??? ???.

??? Yii ??????? ?? ??? ???? ? ?? ???? ?????.

1. select()

select() ???? ??? ?? ???? ? ?????. ?? ?? ???? ?? ?? *? ????? ??? ? ????. ?? ??? ????.

$query = Yii::$app->db->createCommand()->select('*')->from('users');

?? ?? ???? ?? ?? ? ??? select() ???? ?? ??? ??? ? ???, ??? ???? ?? ? ??? ??? ? ????. ?? ?? ??? ????.

$query = Yii::$app->db->createCommand()->select(['id', 'username'])->from('users');

2. from()

from() ???? ???? ?? ??? ???? ?????. ??? ??? ????.

$query = Yii::$app->db->createCommand()->select('*')->from('users');

3. where()

where() ???? ???? ?? ??? ?????. ?? ??? ????.

$query = Yii::$app->db->createCommand()->select('*')->from('users')->where(['status' => 1]);

??? status? ? ???? 1? ? ????.

?-? ?? ???? ? ??? ??? ???? ?? ?? ?? ?? ??? ??? ?? ????. ???? "AND" ?????. ?? ??? ????.

$query = Yii::$app->db->createCommand()->select('*')->from('users')->where(['status' => 1, 'age' => 18]);

??? ?? ?? SQL ?? ?????.

SELECT * FROM `users` WHERE `status`=:status AND `age`=:age

"OR" ??? ???? ?? ?? ??? ?? ??? ? ????.

$query = Yii::$app->db->createCommand()->select('*')->from('users')->where(['or', ['status' => 1], ['age' => 18]]);

??? ?? ?? SQL ?? ?????.

SELECT * FROM `users` WHERE (`status`=:status OR `age`=:age)

4. limit() ? offset()

limit() ???? ?? ??? ???? ?? ? ?? ???? ? ????, offset() ???? ?? ??? ???? ???? ? ?????. ?? ??? ????.

$query = Yii::$app->db->createCommand()->select('*')->from('users')->where(['status' => 1])->limit(10)->offset(5);

??? ?? ?? SQL ?? ?????.

SELECT * FROM `users` WHERE `status`=:status LIMIT 10 OFFSET 5

5. orderBy()

orderBy() ???? ???? ??? ?????. ?? ??? ????.

$query = Yii::$app->db->createCommand()->select('*')->from('users')->where(['status' => 1])->orderBy('age');

??? ?? ?? SQL ?? ?????.

SELECT * FROM `users` WHERE `status`=:status ORDER BY `age`

6. groupBy() ? have()

groupBy() ???? ??? ????? ? ????, had() ???? ??? ????. ??? ??? ???? ? ?????. ?? ??? ????.

$query = Yii::$app->db->createCommand()->select('count(*) as cnt, status')->from('users')->groupBy('status')->having(['>', 'cnt', 10]);

??? ?? ?? SQL ?? ?????.

SELECT count(*) as cnt, status FROM `users` GROUP BY `status` HAVING cnt > 10

?? ??? ???? ?? ?? ?? ??? ???? ?? ??? ???? ??????? ?? ??? ? ????. Yii ?????? ???? ? ??????? ??? ? ?? ??? ??? ???? ?????? ??? ????? ?? ???? ???? ? ????.

? ??? Yii ?????? ?? ??: ?????? ?? ???? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!