How to Get last Insert Id in php without insert any data?

Question

I need the last inserted record in PHP without insert any data I need the id before insert any data .

select max(id) + 1 from your table, that will be the id you want. — Niranjan N Raju, Sep 15 '15 at 09:50
possible duplicate of [How do I get the last inserted ID of a MySQL table in PHP?](http://stackoverflow.com/questions/1685860/how-do-i-get-the-last-inserted-id-of-a-mysql-table-in-php) — Gunaseelan, Sep 15 '15 at 09:58
@Hoque MD Zahidul i dont know why you need this but you most likly will run into race conditions with this. — Raymond Nijland, Sep 15 '15 at 10:20

score 5 · Accepted Answer · answered Sep 15 '15 at 09:51

5

I hope this is what you're looking for

SELECT id FROM table ORDER BY id DESC LIMIT 1

Hope this helps you out

answered Sep 15 '15 at 09:51

Amit Horakeri

score 1 · Answer 2 · answered Sep 15 '15 at 10:12

1

Simply use

SELECT MAX(id) FROM your_table_name

Or using PDO

PDO::lastInsertId

answered Sep 15 '15 at 10:12

Ankur Tiwari

2 Answers2