Laravel Eloquent insert() Query Example

Jul 18, 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' => '[email protected]', 'votes' => 0]
	);

    
}

Example 2:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    DB::table('users')->insert(
	    ['email' => '[email protected]', 'votes' => 0]
	);
}

Example 3:

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    DB::table('users')->insert([
	    ['id' => 1, 'email' => '[email protected]'],
	    ['id' => 2, 'email' => '[email protected]'],
	]);
}

It will help you...