Query Builder in Laravel (Hindi)
289Query Builder in Laravel
00:00:00 Introduction to Query Builder
00:02:40 Database Configuration
00:03:21 Retrieving All Rows from Table - table Method and get Method (Theory)
00:04:53 Creating Project
00:05:09 Download and Install XAMPP
00:05:56 Run Apache and MySQL
00:06:25 Opening phpMyAdmin
00:06:34 Create Database and Table
00:09:56 Mentioning Database Details in env file
00:10:44 Setting up Project
00:13:36 Retrieving All Rows from Table
00:18:12 Retrieving Single Row/Column from Table
00:19:19 first Method
00:21:03 where clause
00:22:22 value Method
00:23:10 find Method
00:24:14 pluck Method
00:26:28 chunk Method
00:30:55 Aggregates - count
00:32:08 max and min
00:32:57 Determining If Record exists
00:35:48 select Method
00:37:47 distinct Method
00:38:34 where Method
00:42:02 orWhere Method
00:43:38 whereBetween Method
00:44:47 orWhereBetween Method
00:47:03 whereDate Method
00:48:21 whereMonth Method
00:49:35 whereDay Method
00:50:30 whereyear Method
00:51:05 orderBy Method
00:52:46 latest and oldest Method
00:54:12 inRandomOrder Method
00:55:46 groupBy and having Method
00:57:10 Disabling mysql strict mode
00:58:00 take and skip Method
00:59:20 limit and offset Method
01:00:57 insert Method - Insert Data into Table
01:05:28 insertOrIgnore Method
01:07:24 insertGetId Method
01:08:58 update Method - Update Data into Table
01:12:47 updateOrInsert Method
01:18:50 delete Method - Delete Data from Table
01:19:46 truncate Method - Delete All Data from Table
Laravel Playlist:
https://www.youtube.com/playlist?list=PLbGui_ZYuhijEqjCa63l0GkWh5EsG5iTR
Core PHP Tutorials: https://www.youtube.com/playlist?list=PLbGui_ZYuhigFdLdbSI2EM2MrJB7I0j-B
Advance PHP Tutorials:
https://www.youtube.com/playlist?list=PLbGui_ZYuhiiaWMoOK7LXB0GeLsYCiyz5
PHP OSMS Project:
https://www.youtube.com/playlist?list=PLbGui_ZYuhijEPI__8WaEjZzXhkh85hH7
HTML Tutorials : https://www.youtube.com/playlist?list=PLbGui_ZYuhihSr4HroBBQt_quHL42JLif
CSS Tutorials: https://www.youtube.com/playlist?list=PLbGui_ZYuhiisW-k9eEON2vxGABv-PafB
SQL Tutorials: https://www.youtube.com/playlist?list=PLbGui_ZYuhigbr-fJ_9HlOqwg0S24Z73-
Check Out Our Other Playlists:
https://www.youtube.com/user/GeekyShow1/playlists
Learn more about subject:
http://www.geekyshows.com/
________________________________________________
If you found this video valuable, give it a like.
If you know someone who needs to see it, share it.
If you have questions ask below in comment section.
Add it to a playlist if you want to watch it later.
________________________________________________
T A L K W I T H M E !
Business Email: contact@geekyshows.com
Twitter: https://twitter.com/Geekyshow1
Website: http://www.geekyshows.com/
_______________________________________________
Make sure you LIKE, SUBSCRIBE, COMMENT, and REQUEST A VIDEO! :)
_______________________________________________