How can I get the current ID number with INSERT INTO?

Question

Possible Duplicate:
php/MySQL insert row then get 'id'

How can I do get current ID number with INSERT INTO?

mysql_query("INSERT INTO mytable(id,a,b) VALUES(null,3,current ID) ");

mysql_query("
    INSERT INTO tablo(id,a,b)
    VALUES(null,3,this ID number)
            ^            ^
            |            |
            | <Copy ID>  |
            |____________|
");

what do you mean under current id? where is this insert into query run? Be more specific — rsz, Oct 03 '12 at 17:08
He means he wants to do an insert SQL and get the id back, he doesn't know what it is since he passes in null. Here's the answer http://stackoverflow.com/questions/897356/php-mysql-insert-row-then-get-id — Eric Leschinski, Oct 03 '12 at 17:09

score 4 · Accepted Answer · edited Oct 03 '12 at 17:55

4

Use mysqli_insert_id(), which returns the auto-generated id used in the last query.

Read "PHP mysql_insert_id() Function" or "mysql_insert_id".

Example:

<?php
$query= "INSERT INTO table_name VALUES ('a','b','c')";
$result = mysql_query($query);
echo "INSERT statement ID is" . mysql_insert_id();
?>

And do read the big red box in the PHP documentation on the mysql_insert_id page, starting with mysqli.

See the PHP Documentation For further reference.

edited Oct 03 '12 at 17:55

the Tin Man

158,662
42
215
303

answered Oct 03 '12 at 17:10

Mr. Alien

153,751
34
298
278

I'm trying but don't work, mysql_query("INSERT INTO tablo (id,a,b) VALUES(null,5,mysql_insert_id())"); I don't want MySQLi. I want to MySQL. – Ayhan DELİ Oct 03 '12 at 17:18
You really don't want to use `mysql_query` unless you absolutely have to. It's dangerous and much harder to use correctly. – tadman Oct 03 '12 at 17:21

Bruno Vieira · Answer 2 · 2012-10-03T18:03:58.560

1

Basically you can use the mysqli_insert_id function.

As stated in the PHP manual:

The mysqli_insert_id() function returns the ID generated by a query on a table with a column having the AUTO_INCREMENT attribute. If the last query wasn't an INSERT or UPDATE statement or if the modified table does not have a column with the AUTO_INCREMENT attribute, this function will return zero.

edited Oct 03 '12 at 18:03

answered Oct 03 '12 at 17:11

Bruno Vieira

3,884
1
23
35

score 0 · Answer 3 · edited May 23 '17 at 12:07

0

You can try to get the next value of the sequence used in the selected table. Please check if MySQL has any function to get this value. If you need to have this number while executing a SQL statement, then using a PHP function is impossible.

Check "Get Auto Increment value with MySQL query".

edited May 23 '17 at 12:07

Community

1
1

answered Oct 03 '12 at 17:13

Pawel

407
1
6
14

How can I get the current ID number with INSERT INTO?

3 Answers3