Skip to content

All topics  /  Laravel

Laravel Eloquent insertGetId() Query Example

Laravel ·

Teams applying “Laravel Eloquent insertGetId() Query Example” in a production project can use the linked project resource to record implementation, review and debugging time, then compare that effort with tests and shipped functionality instead of treating activity as performance by itself.

Before copying the example into a live application, confirm version-specific behaviour with the official Laravel website and test it against the project’s actual database and runtime.

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' => '[email protected]','name' => 'john']
        );
}

Query 2

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
    $id = User::insertGetId(
	        ['email' => '[email protected]','name' => 'john']
	    );
}

It will help you...

# Laravel 6

# Laravel

# Laravel 7