How to get the ID as the record is inserted?

Question

I am inserting record into database using the insert query as

INSERT INTO task_record(assigned_by,handle_by) VALUES('$assigned_by', '$handle_by')

adding this record assign a unique ID to the each record i want to get that ID as soon as the record is inserted. Is there any simple way to modify the query or i have to use one more query of select which is not a fine option

`SELECT LAST_INSERT_ID()` for direct sql, and lookup the api specific info. — DevZer0, Aug 05 '13 at 10:56
http://stackoverflow.com/questions/897356/php-mysql-insert-row-then-get-id — ale, Aug 05 '13 at 10:56
i have tried with this `echo $id = mysql_insert_id();` i have right this line after the data is inserted but its returning 0 — Abdul Qadeer, Aug 05 '13 at 11:00
Show us more of your PHP code, including the actual code used to make the query. (there are several possible answers to your question; we need to see more of your code in order to know which one is correct) — Spudley, Aug 05 '13 at 11:22

GautamD31 · Answer 1 · 2013-08-05T11:20:43.570

0

Try with $this->db->insert_id() like

echo "The Last Insert Id is ".$this->db->insert_id();

Or like

echo "The Last Insert Id is ".$this->insert_id();

Or even simply

echo "The Last Insert Id is ".mysql_insert_id();

But try to avoid using mysql_* functions due to they are deprecated.Instead use either mysqli_* functions or PDO statements.

EDIT:

$query = "SELECT LAST_INSERT_ID() task_id";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
    $id = $row['task_id'];
}
echo $id;

edited Aug 05 '13 at 11:20

answered Aug 05 '13 at 10:55

GautamD31

28,552
10
64
85

its returning 0 using the statment `echo "The Last Insert Id is ".mysql_insert_id(); ` – Abdul Qadeer Aug 05 '13 at 11:06
Are you getting result from first two..?? – GautamD31 Aug 05 '13 at 11:07
Last one also give the inserted id..You may done wrong in insert query.check once – GautamD31 Aug 05 '13 at 11:09
sorry to say but its not working and !st two are returning an error of undefined method which they are – Abdul Qadeer Aug 05 '13 at 11:10
record is being inserted but id is returning to be 0 – Abdul Qadeer Aug 05 '13 at 11:10
Do you have an auto increment field in your table..?? – GautamD31 Aug 05 '13 at 11:12
yes i have the feild of `task id` as auto incremented – Abdul Qadeer Aug 05 '13 at 11:14

score 0 · Answer 2 · answered Aug 05 '13 at 10:58

0

If your interfacing with mysql directly execute SELECT LAST_INSERT_ID() after the insert query.

with the now obsolote mysql extension you could execute mysql_insert_id();

with the mysql improved extension use mysqli_insert_id();

answered Aug 05 '13 at 10:58

DevZer0

13,433
7
27
51

which parameter is to be passed to the `mysqli_insert_id();` ? – Abdul Qadeer Aug 05 '13 at 11:03
its giving an error if its left Empty – Abdul Qadeer Aug 05 '13 at 11:05

How to get the ID as the record is inserted?

2 Answers2