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 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()