{"id":5014,"date":"2021-08-09T08:44:45","date_gmt":"2021-08-09T08:44:45","guid":{"rendered":"https:\/\/www.bearloga.space\/?page_id=5014"},"modified":"2021-08-09T08:44:46","modified_gmt":"2021-08-09T08:44:46","slug":"yii-query-builder","status":"publish","type":"page","link":"https:\/\/www.bearloga.space\/uk\/yii-query-builder\/","title":{"rendered":"Yii \u2014 Query Builder"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441\u044b SQL \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u044b\u043c \u0441\u043f\u043e\u0441\u043e\u0431\u043e\u043c.&nbsp;\u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u043f\u0438\u0441\u0430\u0442\u044c \u0431\u043e\u043b\u0435\u0435 \u0447\u0438\u0442\u0430\u0435\u043c\u044b\u0439 \u043a\u043e\u0434, \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0439 \u0441 SQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0427\u0442\u043e\u0431\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043f\u043e\u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u044c \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, \u0432\u044b \u0434\u043e\u043b\u0436\u043d\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0448\u0430\u0433\u0438:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0421\u043e\u0437\u0434\u0430\u0439\u0442\u0435 \u043e\u0431\u044a\u0435\u043a\u0442 yii \\ db \\ Query.<\/li><li>\u0412\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u0435 \u043c\u0435\u0442\u043e\u0434 \u0437\u0430\u043f\u0440\u043e\u0441\u0430.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\u0427\u0442\u043e\u0431\u044b \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u043e\u0431\u044a\u0435\u043a\u0442&nbsp;<strong>yii \\ db \\ Query<\/strong>&nbsp;, \u0432\u044b \u0434\u043e\u043b\u0436\u043d\u044b \u0432\u044b\u0437\u044b\u0432\u0430\u0442\u044c \u0440\u0430\u0437\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u043f\u043e\u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0434\u043b\u044f \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u0440\u0430\u0437\u043d\u044b\u0445 \u0447\u0430\u0441\u0442\u0435\u0439 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u0430.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0428\u0430\u0433 1.<\/strong>&nbsp;\u0427\u0442\u043e\u0431\u044b \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u044c \u0442\u0438\u043f\u0438\u0447\u043d\u043e\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u043f\u043e\u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u0435 \u043c\u0435\u0442\u043e\u0434&nbsp;<strong>actionTestDb<\/strong>&nbsp;\u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">public function actionTestDb() {\n   \/\/generates \"SELECT id, name, email FROM user WHERE name = 'User10';\"\n   $user = (new \\yii\\db\\Query())\n      -&gt;select(['id', 'name', 'email'])\n      -&gt;from('user')\n      -&gt;where(['name' =&gt; 'User10'])\n      -&gt;one();\n   var_dump($user);\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0428\u0430\u0433 2<\/strong>&nbsp;\u2014 \u041f\u0435\u0440\u0435\u0439\u0434\u0438\u0442\u0435 \u043f\u043e&nbsp;<strong>\u0430\u0434\u0440\u0435\u0441\u0443 http: \/\/ localhost: 8080 \/ index.php? R = site \/ test-db<\/strong>&nbsp;, \u0432\u044b \u0443\u0432\u0438\u0434\u0438\u0442\u0435 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0432\u044b\u0432\u043e\u0434.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/coderlessons.com\/wp-content\/uploads\/2019\/07\/query_builder.png\" alt=\"Query Builder\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u0413\u0434\u0435 () \u0444\u0443\u043d\u043a\u0446\u0438\u044f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0424\u0443\u043d\u043a\u0446\u0438\u044f&nbsp;<strong>where ()<\/strong>&nbsp;\u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u0442 \u0444\u0440\u0430\u0433\u043c\u0435\u043d\u0442 WHERE \u0437\u0430\u043f\u0440\u043e\u0441\u0430.&nbsp;\u0427\u0442\u043e\u0431\u044b \u0443\u043a\u0430\u0437\u0430\u0442\u044c \u0443\u0441\u043b\u043e\u0432\u0438\u0435&nbsp;<strong>WHERE<\/strong>&nbsp;, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0442\u0440\u0438 \u0444\u043e\u0440\u043c\u0430\u0442\u0430.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>\u0444\u043e\u0440\u043c\u0430\u0442 \u0441\u0442\u0440\u043e\u043a\u0438<\/strong>&nbsp;\u2014 \u2018name = User10\u2019<\/li><li><strong>\u0444\u043e\u0440\u043c\u0430\u0442 \u0445\u044d\u0448\u0430<\/strong>&nbsp;\u2014 [\u2018name\u2019 =&gt; \u2018User10\u2032, \u2019email =&gt; user10@gmail.com\u2019]<\/li><li><strong>\u0444\u043e\u0440\u043c\u0430\u0442 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430<\/strong>&nbsp;\u2014 [\u2018like\u2019, \u2018name\u2019, \u2018User\u2019]<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0444\u043e\u0440\u043c\u0430\u0442 \u0441\u0442\u0440\u043e\u043a\u0438<\/strong>&nbsp;\u2014 \u2018name = User10\u2019<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0444\u043e\u0440\u043c\u0430\u0442 \u0445\u044d\u0448\u0430<\/strong>&nbsp;\u2014 [\u2018name\u2019 =&gt; \u2018User10\u2032, \u2019email =&gt; user10@gmail.com\u2019]<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0444\u043e\u0440\u043c\u0430\u0442 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430<\/strong>&nbsp;\u2014 [\u2018like\u2019, \u2018name\u2019, \u2018User\u2019]<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u041f\u0440\u0438\u043c\u0435\u0440 \u0444\u043e\u0440\u043c\u0430\u0442\u0430 String<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">public function actionTestDb() {\n   $user = (new \\yii\\db\\Query())\n      -&gt;select(['id', 'name', 'email'])\n      -&gt;from('user')\n      -&gt;where('name = :name', [':name' =&gt; 'User11'])\n      -&gt;one();\n   var_dump($user);\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u041d\u0438\u0436\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u0432\u043e\u0434.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/coderlessons.com\/wp-content\/uploads\/2019\/07\/string_format_example_output.png\" alt=\"\u0412\u044b\u0432\u043e\u0434 \u043f\u0440\u0438\u043c\u0435\u0440\u0430 \u0444\u043e\u0440\u043c\u0430\u0442\u0430 \u0441\u0442\u0440\u043e\u043a\u0438\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u041f\u0440\u0438\u043c\u0435\u0440 \u0444\u043e\u0440\u043c\u0430\u0442\u0430 Hash<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">public function actionTestDb() {\n   $user = (new \\yii\\db\\Query())\n      -&gt;select(['id', 'name', 'email'])\n      -&gt;from('user')\n      -&gt;where([\n         'name' =&gt; 'User5',\n         'email' =&gt; 'user5@gmail.com'\n      ])\n      -&gt;one();\n   var_dump($user);\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u041d\u0438\u0436\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u0432\u043e\u0434.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/coderlessons.com\/wp-content\/uploads\/2019\/07\/hash_format_example_output.png\" alt=\"\u0412\u044b\u0432\u043e\u0434 \u043f\u0440\u0438\u043c\u0435\u0440\u0430 \u0445\u044d\u0448-\u0444\u043e\u0440\u043c\u0430\u0442\u0430\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u0424\u043e\u0440\u043c\u0430\u0442 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u043b\u044c\u043d\u044b\u0435 \u0443\u0441\u043b\u043e\u0432\u0438\u044f \u0432 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u043c \u0444\u043e\u0440\u043c\u0430\u0442\u0435 \u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">[operator, operand1, operand2]\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u2014<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>\u0438<\/strong>&nbsp;\u2014 [\u2018and\u2019, \u2018id = 1\u2019, \u2018id = 2\u2019] \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 id = 1 AND id = 2 \u0438\u043b\u0438: \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 and<\/li><li><strong>\u041c\u0435\u0436\u0434\u0443<\/strong>&nbsp;\u2014 [\u2018\u041c\u0435\u0436\u0434\u0443\u2019, \u2018ID\u2019, 1, 15] \u0431\u0443\u0434\u0435\u0442 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u043c\u0435\u0436\u0434\u0443 1 \u0438 15<\/li><li><strong>\u043d\u0435 \u043c\u0435\u0436\u0434\u0443<\/strong>&nbsp;\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 \u043c\u0435\u0436\u0434\u0443, \u043d\u043e \u0432\u043c\u0435\u0441\u0442\u043e \u044d\u0442\u043e\u0433\u043e \u0437\u0430\u043c\u0435\u043d\u044f\u0435\u0442\u0441\u044f \u043d\u0430 \u041d\u0415 \u043c\u0435\u0436\u0434\u0443<\/li><li><strong>in<\/strong>&nbsp;\u2014 [\u2018in\u2019, \u2018id\u2019, [5,10,15]] \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 id IN (5,10,15)<\/li><li><strong>not in<\/strong>&nbsp;\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 in, \u043d\u043e IN \u0437\u0430\u043c\u0435\u043d\u044f\u0435\u0442\u0441\u044f \u043d\u0430 NOT IN<\/li><li><strong>like<\/strong>&nbsp;\u2014 [\u2018like\u2019, \u2018name\u2019, \u2018user\u2019] \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0438\u043c\u044f LIKE \u2018% user%\u2019<\/li><li><strong>\u0438\u043b\u0438 like<\/strong>&nbsp;\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 like, \u043d\u043e OR \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0435\u0434\u0438\u043a\u0430\u0442\u043e\u0432 LIKE<\/li><li><strong>\u043d\u0435 \u043d\u0440\u0430\u0432\u0438\u0442\u0441\u044f<\/strong>&nbsp;\u2014 \u043f\u043e\u0445\u043e\u0436\u0435 \u043d\u0430 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 like, \u043d\u043e LIKE \u0437\u0430\u043c\u0435\u043d\u044f\u0435\u0442\u0441\u044f \u043d\u0430 NOT LIKE<\/li><li><strong>\u0438\u043b\u0438 \u043d\u0435 \u043a\u0430\u043a<\/strong>&nbsp;\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 not like, \u043d\u043e OR \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u043f\u0440\u0435\u0434\u0438\u043a\u0430\u0442\u043e\u0432 NOT LIKE<\/li><li><strong>\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442<\/strong>&nbsp;\u2014 \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043e\u0434\u0438\u043d \u043e\u043f\u0435\u0440\u0430\u043d\u0434, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0434\u043e\u043b\u0436\u0435\u043d \u0431\u044b\u0442\u044c \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u043e\u043c \u043a\u043b\u0430\u0441\u0441\u0430 yii \\ db \\ Query<\/li><li><strong>\u043d\u0435 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442<\/strong>&nbsp;\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0449\u0435\u0433\u043e, \u043d\u043e \u0441\u043e\u0437\u0434\u0430\u0435\u0442 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435 \u041d\u0415 \u0421\u0423\u0429\u0415\u0421\u0422\u0412\u0423\u0415\u0422 (\u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441)<\/li><li><strong>&lt;, &lt;=,&gt;,&gt; =<\/strong>&nbsp;\u0438\u043b\u0438 \u043b\u044e\u0431\u043e\u0439 \u0434\u0440\u0443\u0433\u043e\u0439 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 \u0411\u0414: [\u2018&lt;\u2018, \u2018id\u2019, 10] \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 id &lt;10<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0438<\/strong>&nbsp;\u2014 [\u2018and\u2019, \u2018id = 1\u2019, \u2018id = 2\u2019] \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 id = 1 AND id = 2 \u0438\u043b\u0438: \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 and<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u041c\u0435\u0436\u0434\u0443<\/strong>&nbsp;\u2014 [\u2018\u041c\u0435\u0436\u0434\u0443\u2019, \u2018ID\u2019, 1, 15] \u0431\u0443\u0434\u0435\u0442 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u043a\u0430\u0442\u043e\u0440 \u043c\u0435\u0436\u0434\u0443 1 \u0438 15<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u043d\u0435 \u043c\u0435\u0436\u0434\u0443<\/strong>&nbsp;\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 \u043c\u0435\u0436\u0434\u0443, \u043d\u043e \u0432\u043c\u0435\u0441\u0442\u043e \u044d\u0442\u043e\u0433\u043e \u0437\u0430\u043c\u0435\u043d\u044f\u0435\u0442\u0441\u044f \u043d\u0430 \u041d\u0415 \u043c\u0435\u0436\u0434\u0443<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>in<\/strong>&nbsp;\u2014 [\u2018in\u2019, \u2018id\u2019, [5,10,15]] \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 id IN (5,10,15)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>not in<\/strong>\u00a0\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 in, \u043d\u043e IN \u0437\u0430\u043c\u0435\u043d\u044f\u0435\u0442\u0441\u044f \u043d\u0430 NOT IN<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>like<\/strong>&nbsp;\u2014 [\u2018like\u2019, \u2018name\u2019, \u2018user\u2019] \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0438\u043c\u044f LIKE \u2018% user%\u2019<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0438\u043b\u0438 like<\/strong>&nbsp;\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 like, \u043d\u043e OR \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u0435\u0434\u0438\u043a\u0430\u0442\u043e\u0432 LIKE<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u043d\u0435 \u043d\u0440\u0430\u0432\u0438\u0442\u0441\u044f<\/strong>&nbsp;\u2014 \u043f\u043e\u0445\u043e\u0436\u0435 \u043d\u0430 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 like, \u043d\u043e LIKE \u0437\u0430\u043c\u0435\u043d\u044f\u0435\u0442\u0441\u044f \u043d\u0430 NOT LIKE<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0438\u043b\u0438 \u043d\u0435 \u043a\u0430\u043a<\/strong>&nbsp;\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 not like, \u043d\u043e OR \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u043f\u0440\u0435\u0434\u0438\u043a\u0430\u0442\u043e\u0432 NOT LIKE<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442<\/strong>&nbsp;\u2014 \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043e\u0434\u0438\u043d \u043e\u043f\u0435\u0440\u0430\u043d\u0434, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0434\u043e\u043b\u0436\u0435\u043d \u0431\u044b\u0442\u044c \u044d\u043a\u0437\u0435\u043c\u043f\u043b\u044f\u0440\u043e\u043c \u043a\u043b\u0430\u0441\u0441\u0430 yii \\ db \\ Query<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u043d\u0435 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u0435\u0442<\/strong>&nbsp;\u2014 \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0443 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0449\u0435\u0433\u043e, \u043d\u043e \u0441\u043e\u0437\u0434\u0430\u0435\u0442 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435 \u041d\u0415 \u0421\u0423\u0429\u0415\u0421\u0422\u0412\u0423\u0415\u0422 (\u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>&lt;, &lt;=,&gt;,&gt; =<\/strong>&nbsp;\u0438\u043b\u0438 \u043b\u044e\u0431\u043e\u0439 \u0434\u0440\u0443\u0433\u043e\u0439 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 \u0411\u0414: [\u2018&lt;\u2018, \u2018id\u2019, 10] \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 id &lt;10<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u041f\u0440\u0438\u043c\u0435\u0440 \u0444\u043e\u0440\u043c\u0430\u0442\u0430 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430<\/h3>\n\n\n\n<pre class=\"wp-block-preformatted\">public function actionTestDb() {\n   $users = (new \\yii\\db\\Query())\n      -&gt;select(['id', 'name', 'email'])\n      -&gt;from('user')\n      -&gt;where(['between', 'id', 5, 7])\n      -&gt;all();\n   var_dump($users);\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u041d\u0438\u0436\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u0432\u043e\u0434.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/coderlessons.com\/wp-content\/uploads\/2019\/07\/operator_format_example_output.png\" alt=\"\u041f\u0440\u0438\u043c\u0435\u0440 \u0444\u043e\u0440\u043c\u0430\u0442\u0430 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u0424\u0443\u043d\u043a\u0446\u0438\u044f OrderBy ()<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0424\u0443\u043d\u043a\u0446\u0438\u044f&nbsp;<strong>orderBy ()<\/strong>&nbsp;\u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u0442 \u0444\u0440\u0430\u0433\u043c\u0435\u043d\u0442 ORDER BY.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u041f\u0440\u0438\u043c\u0435\u0440<\/strong>&nbsp;\u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">public function actionTestDb() {\n   $users = (new \\yii\\db\\Query())\n      -&gt;select(['id', 'name', 'email'])\n      -&gt;from('user')\n      -&gt;orderBy('name DESC')\n      -&gt;all();\n   var_dump($users);\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u041d\u0438\u0436\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u0432\u043e\u0434.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/coderlessons.com\/wp-content\/uploads\/2019\/07\/orderby_function_example_output.png\" alt=\"\u041f\u0440\u0438\u043c\u0435\u0440 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 OrderBy \u0412\u044b\u0432\u043e\u0434\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u0424\u0443\u043d\u043a\u0446\u0438\u044f groupBy ()<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0424\u0443\u043d\u043a\u0446\u0438\u044f&nbsp;<strong>groupBy ()<\/strong>&nbsp;\u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u0442 \u0444\u0440\u0430\u0433\u043c\u0435\u043d\u0442 GROUP BY, \u0430 \u043c\u0435\u0442\u043e\u0434&nbsp;<strong>have ()<\/strong>&nbsp;\u0443\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442 \u0444\u0440\u0430\u0433\u043c\u0435\u043d\u0442 HAVING.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u041f\u0440\u0438\u043c\u0435\u0440<\/strong>&nbsp;\u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">public function actionTestDb() {\n   $users = (new \\yii\\db\\Query())\n      -&gt;select(['id', 'name', 'email'])\n      -&gt;from('user')\n      -&gt;groupBy('name')\n      -&gt;having('id &lt; 5')\n      -&gt;all();\n   var_dump($users);\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u041d\u0438\u0436\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u0432\u043e\u0434.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/coderlessons.com\/wp-content\/uploads\/2019\/07\/groupby_function_example_output.png\" alt=\"\u0412\u044b\u0445\u043e\u0434\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 groupBy\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u041c\u0435\u0442\u043e\u0434\u044b&nbsp;<strong>limit ()<\/strong>&nbsp;\u0438&nbsp;<strong>offset ()<\/strong>&nbsp;\u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u044e\u0442 \u0444\u0440\u0430\u0433\u043c\u0435\u043d\u0442\u044b&nbsp;<strong>LIMIT<\/strong>&nbsp;\u0438&nbsp;<strong>OFFSET<\/strong>&nbsp;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u041f\u0440\u0438\u043c\u0435\u0440<\/strong>&nbsp;\u2014<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">public function actionTestDb() {\n   $users = (new \\yii\\db\\Query())\n      -&gt;select(['id', 'name', 'email'])\n      -&gt;from('user')\n      -&gt;limit(5)\n      -&gt;offset(5)\n      -&gt;all();\n   var_dump($users);\n}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0412\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0443\u0432\u0438\u0434\u0435\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0432\u044b\u0432\u043e\u0434 \u2014<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/coderlessons.com\/wp-content\/uploads\/2019\/07\/limit_offset_fragments.png\" alt=\"\u041e\u0433\u0440\u0430\u043d\u0438\u0447\u0438\u0442\u044c \u0441\u043c\u0435\u0449\u0435\u043d\u0438\u0435 \u0444\u0440\u0430\u0433\u043c\u0435\u043d\u0442\u043e\u0432\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u041a\u043b\u0430\u0441\u0441&nbsp;<strong>yii \\ db \\ Query<\/strong>&nbsp;\u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u043d\u0430\u0431\u043e\u0440 \u043c\u0435\u0442\u043e\u0434\u043e\u0432 \u0434\u043b\u044f \u0440\u0430\u0437\u043b\u0438\u0447\u043d\u044b\u0445 \u0446\u0435\u043b\u0435\u0439 \u2014<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>all ()<\/strong>&nbsp;\u2014 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043c\u0430\u0441\u0441\u0438\u0432 \u0441\u0442\u0440\u043e\u043a \u043f\u0430\u0440 \u0438\u043c\u044f-\u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>one ()<\/strong>&nbsp;\u2014 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043f\u0435\u0440\u0432\u044b\u0439 \u0440\u044f\u0434.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>column ()<\/strong>&nbsp;\u2014 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u043e\u043b\u0431\u0435\u0446.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>scalar ()<\/strong>&nbsp;\u2014 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0441\u043a\u0430\u043b\u044f\u0440\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0438\u0437 \u043f\u0435\u0440\u0432\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0438 \u0438 \u043f\u0435\u0440\u0432\u043e\u0433\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u0430 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0430.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>exist ()<\/strong>&nbsp;\u2014 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435, \u0443\u043a\u0430\u0437\u044b\u0432\u0430\u044e\u0449\u0435\u0435, \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 \u043b\u0438 \u0437\u0430\u043f\u0440\u043e\u0441 \u043a\u0430\u043a\u043e\u0439-\u043b\u0438\u0431\u043e \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>count ()<\/strong>&nbsp;\u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 COUNT<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u0434\u0440\u0443\u0433\u0438\u0435 \u043c\u0435\u0442\u043e\u0434\u044b \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0430\u0433\u0440\u0435\u0433\u0430\u0446\u0438\u0438<\/strong>&nbsp;\u2014 \u0432\u043a\u043b\u044e\u0447\u0430\u0435\u0442 \u0441\u0443\u043c\u043c\u0443 ($ q), \u0441\u0440\u0435\u0434\u043d\u0435\u0435 ($ q), max ($ q), min ($ q).&nbsp;\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 $ q \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043b\u0438\u0431\u043e \u0438\u043c\u0435\u043d\u0435\u043c \u0441\u0442\u043e\u043b\u0431\u0446\u0430, \u043b\u0438\u0431\u043e \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435\u043c \u0411\u0414.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441\u044b SQL \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u044b\u043c \u0441\u043f\u043e\u0441\u043e\u0431\u043e\u043c.&nbsp;\u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u043f\u0438\u0441\u0430\u0442\u044c \u0431\u043e\u043b\u0435\u0435 \u0447\u0438\u0442\u0430\u0435\u043c\u044b\u0439 \u043a\u043e\u0434, \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0439 \u0441 SQL. \u0427\u0442\u043e\u0431\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043f\u043e\u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u044c [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[156],"tags":[],"class_list":["post-5014","page","type-page","status-publish","hentry","category-yii"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages\/5014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/comments?post=5014"}],"version-history":[{"count":1,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages\/5014\/revisions"}],"predecessor-version":[{"id":5015,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/pages\/5014\/revisions\/5015"}],"wp:attachment":[{"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/media?parent=5014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/categories?post=5014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bearloga.space\/uk\/wp-json\/wp\/v2\/tags?post=5014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}