Return new id with DB::insert() in Laravel 4

Question

In Laravel 4, when you perform a DB::insert(), how can you get the ID of the row that has just been inserted? Similar what we have with the function ->insertGetId(). Reason for using DB::insert() is that its a complex PostgreSQL query that cannot be built using Fluent.

Example Query:

$newId = DB::insert('insert into users (id, name) values (?, ?)', array(1, 'Dayle'));
echo $newId; // returns 1

Answer 1

There is a insertGetId method.

$id = DB::table('users')->insertGetId(
    array('id' => 1, 'name' => 'Dayle Rees')
);

Answer 2

If you get in complex structure, better to use Eloquent.

Best thing that you need review docs :

http://laravel.com/docs/eloquent

Answer 3

If you take a look at Illuminate\Database\ConnectionInterface you can see how these functions are written. Unfortunately DB::insert() returns a boolean from PDOStatement::execute() and there is no DB::insertGetId() at the moment. If this would be useful then you should request it on GitHub.

In the mean time, you should be able to use DB::getPdo()->lastInsertId()

Answer 4

After saving the data into the DB you just call $insertedId = $user->id; where $user->save() is called before the step.

more info here

Answer 5

There is a insertGetId() method, as follows:

$dataset = array('column_id' => 1, 'name' => 'Dayle');
$column_id = DB::table('users')->insertGetId($dataset,'column_id');