Return primary key for the inserted row (PHP adn SQLite)?

Asked Jan 24 '16 at 14:10

Active Jan 24 '16 at 19:32

Viewed 26 times

Get the specific primary key, just after inserting row into SQLite, using PHP.

I use PDO prepare-execute, and am not sure how to achieve this in simplest way.

Should I do a query just after inserting, something like:

SELECT ID 
FROM TableX 
WHERE Data = $data

Thanks

edited Jan 24 '16 at 19:32

marc_s

asked Jan 24 '16 at 14:10

mrmut

2

Have you tried http://php.net/manual/en/pdo.lastinsertid.php? – u_mulder Jan 24 '16 at 14:11
Thats it, thanks. I thought I have to pass another querry to database. - Will you answer, so I can click your answer? – mrmut Jan 24 '16 at 14:19

0 Answers0