Laravel Eloquent insertGetId() Query Example

Laravel 6 , Laravel , Laravel 7

Nicesnippets

147

27-07-2020


Hi Dev,

In this blog, I will show you how to use insertGetId() query in laravel application. We will learn laravel eloquent insertGetId() query.

The use of insertGetId query in laravel used to insert record and get insert record id. If the table has an auto-incrementing id, use the insertGetId method to insert a record and then retrieve the ID:

When using PostgreSQL the insertGetId method expects the auto-incrementing column to be named id. If you would like to retrieve the ID from a different "sequence", you may pass the column name as the second parameter to the insertGetId method.

Query 1

/**

* The attributes that are mass assignable.

*

* @var array

*/

public function index()

{

$id = DB::table('users')->insertGetId(

['email' => 'john@example.com','name' => 'john']

);

}

Query 2

/**

* The attributes that are mass assignable.

*

* @var array

*/

public function index()

{

$id = User::insertGetId(

['email' => 'john@example.com','name' => 'john']

);

}

It will help you...


Recommended Posts