obsidian/MyObsidianVault/Knowledgebase/WebDev/2 CodeIgniter/_Course Notes/03.) Query Builder - insert, update , delete and select.md

https://www.youtube.com/watch?v=QaNGT-hj0so&list=PLT9miexWCpPW6Z_OXNv2d78cqCrZaPrVG&index=8

! !

Add route to Controller+method in Config/Routes.php:

!

Example for using where clause ( second parameter in update method ): !

Delete:

! Select all: !

!

Select with where clause

!

For single row result, we directly load into Array ( instead of Array of Array) !