Laravel Eloquent insert() Query Example

Laravel 6 , Laravel , Laravel 7

Nicesnippets

11535

18-07-2020


Hi Guys

In this example,I will learn you how to use insert query in laravel.you can easy and simply use insert query in laravel.

The query builder also provides an insert method for inserting records into the database table. The insert method accepts an array of column names and value.

Example 1:


/**

* The attributes that are mass assignable.

*

* @var array

*/

public function index()

{

User::insert(

['email' => 'keval@example.com', 'votes' => 0]

);

}

Example 2:

/**

* The attributes that are mass assignable.

*

* @var array

*/

public function index()

{

DB::table('users')->insert(

['email' => 'keval@example.com', 'votes' => 0]

);

}

Example 3:

/**

* The attributes that are mass assignable.

*

* @var array

*/

public function index()

{

DB::table('users')->insert([

['id' => 1, 'email' => 'keval@example.com'],

['id' => 2, 'email' => 'mehul@example.com'],

]);

}

It will help you...