![Yii Framework 2 Basic Training | Manop Kongoon
Query Builder
$rows = (new yiidbQuery())
->select([id, username, email])
->from(user)
->where([firstname=>John])
->limit(4)
->all();
https://github.com/yiisoft/yii2/blob/master/docs/guide/db-
query-builder.md
33](https://image.slidesharecdn.com/yiiframework2basictraining-150524082942-lva1-app6891/85/Yii-framework-2-basic-training-33-320.jpg)
More Related Content
Viewers also liked (18)
Yii framework 2 basic training
- 1. Yii Framework 2 Basic Training | Manop Kongoon Yii Framework 2 Basic Training MANOP KONGOON
- 2. Yii Framework 2 Basic Training | Manop Kongoon 犖犖犖犖朽 1 犖犖犖犖 2
- 3. Yii Framework 2 Basic Training | Manop Kongoon 犖犖橿犖犖о検犖犖ム険犖犖犖項犖 (Course Overview) OOP Concept MVC Pattern Yii2 Convention Routing & Request M-V-C Access Control Small Workshop News Gallery 3
- 4. Yii Framework 2 Basic Training | Manop Kongoon 犖犖о験犖÷犖橿犖橿犖犖朽犢犖犖萎犖 (Recommend Skill) PHP and MySQL HTML and CSS Bootstrap 3 JavaScript MVC Concept OOP Concept 4
- 5. Yii Framework 2 Basic Training | Manop Kongoon 犖犖犖犖朽 2 犢犖犖犖劇犖犖犖÷厳犖犢犖ム鍵犖犖橿牽犖犖巌犖犖園犖 5
- 6. Yii Framework 2 Basic Training | Manop Kongoon 犢犖犖犖朽権犖÷犖犖犖劇犖犖犖÷厳犖 Web Server (WAMP - http://www.wampserver.com) Composer http://getcomposer.org GitHub Account http://github.com IDE (NetbeansIDE - http://netbeans.org) 6
- 7. Yii Framework 2 Basic Training | Manop Kongoon Web Server Web Server PHP MySQL 7
- 8. Yii Framework 2 Basic Training | Manop Kongoon Composer ∇犖園硯犖犖園犖犖橿牽 Library auto update ∇犖犢 Folder vendor 犖犖橿見犖犖園犢犖犢犖 Library ∇犢犖犖犖 Library 犢犖犢犖犖朽 packagist.org ∇肩犖橿検犖橿牽犖犢犖犖劇犖犖÷犖園 Github 犢犖ム鍵 Bitbucket Library 犖犖萎肩犖橿検犖橿牽犖犢犖犢犖犖橿犢犖犢犖犖園 Framework 犖犢犖橿犢 getcomposer.org 8
- 9. Yii Framework 2 Basic Training | Manop Kongoon GitHub Account ∇犖橿牽犖犖巌犖犖園犖犖犢犖橿 Composer Github.com 9
- 10. Yii Framework 2 Basic Training | Manop Kongoon NetBeansIDE ∇犖橿犖÷犢犖犖 NetbeansIDE? ∇犖犖! ∇検犖 Auto Complete ∇検犖 Auto Debug ∇検犖朽牽犖萎犖犖犖橿牽犖犖園 Format code netbeans.org 10
- 11. Yii Framework 2 Basic Training | Manop Kongoon 犖犖犖犖朽 3 犢犖犖巌犖÷犢犖犖犖園 Yii Framework 2 11
- 12. Yii Framework 2 Basic Training | Manop Kongoon 犖犖項犖犖園犖犖園 Yii2 ∇犖橿犖犖巌 Yii Framework 犢犖ム鍵 Yii Framework 2 犖犖犖劇賢 Yii2 12
- 13. Yii Framework 2 Basic Training | Manop Kongoon MVC Concept 13
- 14. Yii Framework 2 Basic Training | Manop Kongoon 犢犖犖犢犖犢犖ム権犖朽犖朽犢犖犖朽犖∇硯犖犢犖犖 PSR-4 http://www.php-fig.org/psr/psr-4 14
- 15. Yii Framework 2 Basic Training | Manop Kongoon Application Request 15
- 16. Yii Framework 2 Basic Training | Manop Kongoon 犖犖犖犖朽 4 犖犖橿牽犖犖巌犖犖園犖 Yii2 16
- 17. Yii Framework 2 Basic Training | Manop Kongoon 犖犖巌犖犖園犖犖犢犖о権 Composer Set path php.exe 犖犖朽 System variable composer global require fxp/composer-asset- plugin:1.0.0 composer create-project yiisoft/yii2-app-basic your- app-name 17
- 18. Yii Framework 2 Basic Training | Manop Kongoon 犖犖巌犖犖園犖犖犢犖о権 Archive File http://www.yiiframework.com/download/ ∇犖犖 Archive File ∇犖犖ム元犢犖∇犖犢犖橿犖 config/web 犖犢犖о CookieValidation 18
- 19. Yii Framework 2 Basic Training | Manop Kongoon 犢犖犖犖犖犖犢犖橿 Yii2 19
- 20. Yii Framework 2 Basic Training | Manop Kongoon 犖犖犖犖朽 5 犖犖犖犖÷犖犖朽権犖 Yii2 20
- 21. Yii Framework 2 Basic Training | Manop Kongoon Model namespace appmodels; ∇犖橿牽犖犖園犖犖犖劇犖犖犢犖犖犖園犖犢犖о権犖犖園硯犢犖犖犢 犢犖犢犖HelloWorld ∇肩犖劇犖犖犖 (extends) 犖÷験犖犖橿 Model 犖犖犖劇賢 ActiveRecord Property 犢犖犢犖犖犖園硯犢犖犖犖犖犖犖犢犖犖÷弦犖 21
- 22. Yii Framework 2 Basic Training | Manop Kongoon Model Model 犖÷元 2 犢犖犖 ∇犖犖犢犖÷犢犖犢犖犖橿牽犖橿犢犖犖犖橿犖犢犖犖÷弦犖 犖犢犖о犢犖犖犢犢犖犢犢犖犖犖橿牽犖犖犢犖橿 Form extends Model ∇犖犖犢犖犢犖犖橿牽犖橿犢犖犖犖橿犖犢犖犖÷弦犖 extends ActiveRecord 22
- 23. Yii Framework 2 Basic Training | Manop Kongoon View ∇犖劇犖 Folder 犢犖犢犖 View 犢犖犢犖犖犖犖犖ム犖犖犖犖園犖犖劇犖 Controller 犢犖犢犖 HelloWorldController 犖犖萎犖犢 Folder View 犖犖劇犖 hello-world ∇犖劇犖 action 犢犖 Controller 犖犖о牽犖犖犢犖橿 View 犖犖劇犖犢犖犖朽権犖о犖園 犖犖橿犖÷元 犖犖橿牽犖犢犖犖犖 hello-world.php 23
- 24. Yii Framework 2 Basic Training | Manop Kongoon View ∇犖犖萎犖犖犢犖犖犢犖о権 Helper (犖犖園硯犖犢犖о権) 犢犖ム鍵 Widget (犖犖園硯犢犖犖犖犖犖) 犖犢犖橿犢 犢犖犖犖橿牽犢犖犖犖犖犖ム犢犖犖÷弦犖 Html Helper GridView, ListView 犢犖ム鍵 DetailView 24
- 25. Yii Framework 2 Basic Training | Manop Kongoon Controller namespace appcontrollers; ∇犖橿牽犖犖園犖犖犖劇犖犖犢犖犖犖園犖犢犖о権犖犖園硯犢犖犖犢 犢犖ム犖о犖橿検犖犢犖о権 Controller 犢犖犢犖 HelloWorldController ∇肩犖劇犖犖犖 (extends) 犖÷験犖犖橿 Controller Method 犖犖朽犢犖犖朽権犖犖犖橿 Route 犖犖謹犖犖犢犖犖犢犖о権 action 犖犖橿検犖犢犖о権犖犖劇犖 犢犖犢犖 actionHelloWorld() 25
- 26. Yii Framework 2 Basic Training | Manop Kongoon Controller ∇犖園硯犖犖ム験犖犢犖犖犖橿牽犖犢犖犖犢犖橿犖園硯犢犖犖犖犖萎見犖о犖橿 Model 犖犖園 View ∇絹犖項犖∇犖犖о検 Logic 犖犖犖犢犖犖犢犖犖犖 26
- 27. Yii Framework 2 Basic Training | Manop Kongoon 犖犖犖犖朽 6 犖犖о険犖犖犖朽犖橿硯犢犖ム 27
- 28. Yii Framework 2 Basic Training | Manop Kongoon Hello World Controller ∇肩犖犢犖橿 HelloWorldController.php ∇肩犖犢犖橿 actionSay() ∇肩犖犢犖橿 view hello- world/say.php ∇犖橿牽犖犢犖犖犢犖橿犖犢 view ∇犖橿牽犖犖園犖犢犖橿犖犖 Get 犖犢犖橿 Controller 28
- 29. Yii Framework 2 Basic Training | Manop Kongoon 犖犖橿牽犖犖犢犖橿 MVC 犢犖犖犢犖÷犖犖項犖犖橿牽犖橿 29
- 30. Yii Framework 2 Basic Training | Manop Kongoon 犖犖橿牽犖犖犢犖橿 MVC 犢犖犖犖犖項犖犖橿牽犖橿 30
- 31. Yii Framework 2 Basic Training | Manop Kongoon 犖犖犖犖朽 7 犖犖橿牽犖犖橿犖橿犖犖園犖犖橿犖犢犖犖÷弦犖 31
- 32. Yii Framework 2 Basic Training | Manop Kongoon Create Command $posts = $db->createCommand(SELECT * FROM post) ->queryAll(); 32
- 33. Yii Framework 2 Basic Training | Manop Kongoon Query Builder $rows = (new yiidbQuery()) ->select([id, username, email]) ->from(user) ->where([firstname=>John]) ->limit(4) ->all(); https://github.com/yiisoft/yii2/blob/master/docs/guide/db- query-builder.md 33
- 34. Yii Framework 2 Basic Training | Manop Kongoon Active Record $posts = Post::find(); 34
- 35. Yii Framework 2 Basic Training | Manop Kongoon Gii Generator 35
- 36. Yii Framework 2 Basic Training | Manop Kongoon Model Generator 36
- 37. Yii Framework 2 Basic Training | Manop Kongoon Controller Generator 37
- 38. Yii Framework 2 Basic Training | Manop Kongoon CRUD Generator 38
- 39. Yii Framework 2 Basic Training | Manop Kongoon Module Generator 39
- 40. Yii Framework 2 Basic Training | Manop Kongoon Module Model Generator 40
- 41. Yii Framework 2 Basic Training | Manop Kongoon Module CRUD 41
- 42. Yii Framework 2 Basic Training | Manop Kongoon 犖犖橿牽犖犖犢犖橿犖犖萎犖 User ∇犖犢犖犖犖巌犖犖巌犖犖橿牽犢犖犢犖橿犖謹 ROLE_ADMIN = 10 ROLE_MANAGER = 5 ROLE_USER = 1 ∇犖犢犖犖犖橿牽犖橿 user 犢犖ム鍵 profile ∇犖犢 migrate 犢犖犖犖橿牽犖犖犢犖橿犖犖橿牽犖橿 user 犢犖ム鍵 profile 42
- 43. Yii Framework 2 Basic Training | Manop Kongoon WORKSHOP News and Gallery 43
- 44. Yii Framework 2 Basic Training | Manop Kongoon News and Gallery Create New Yii2 Project Create IDE Project Create and Connect Database Migration Model Generator CRUD Generator User System Backend Module 44