How to retrieve the ID of the last record inserted in the bank? [closed]

Question

Navigation

#1 by (5 votes)
#2 by (2 votes)
#3 by (2 votes)

-1

How do I retrieve the id of the last record made in a table in the database?

I'm using Laravel. Before using a framework I used LASTINSERT .

laravel

asked by anonymous 18.04.2014 / 19:09

3 answers

score 5 · Answer 1

5

If you use Eloquent, this is done automatically, regardless of the database system:

class Post extends Eloquent {

}

$post = Post::create(['title' => 'Laravel']);

echo $post->id;

09.05.2014 / 21:38

score 2 · Answer 2

2

DB::Query('SELECT LAST_INSERT_ID()');

18.04.2014 / 19:25

score 2 · Answer 3

2

If you are using PDO in Laravel the correct form is:

$id = DB::connection('mysql')->pdo->lastInsertId();

If the database is not MySQL, change this in the code above.

19.04.2014 / 01:40