In this video we will learn about Query Builder in Laravel
Query 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
In this article i will let you know to delete multiple rows through checkbox using ajax in laravel and before delete we will give a confirmation message.
As a Laravel development company, we use this framework to deliver robust & scalable customized Laravel web solutions & enterprise portals to global clients. 4200+ Projects | 16+ Yrs Exp | 97% Customer Retention
Hire Laravel developers & dedicated programmers in India for custom Laravel development services on an hourly / full-time basis. 16+ years exp & 4200+ projects | Strict NDA | Contact Us Today
IndianAppDevelopers, leading Laravel app development company in India, Hire Laravel app developers or programmers from India at cost effective price.
WebClues Infotech is a expert in building iOS, Android Apps, Web apps , Websites, Enterprise solutions. We have crafted many complex and innovative projects that meets our customer expectations.