php mysql_insert_id(); not working [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed last month.

Improve this question

Hi guys I was hoping from some help here, please.

I have a INSERT query to a table, after this is done I am calling:

mysql_insert_id();

In order to send the last ID inserted into the table to the next page like this:

$insertGoTo = "confirm_booking.php?booking_ID=" .$_POST['booking_ID']. "";

Unfortunately it does not work, all I get is a zero.

The table I am inserting into has an auto increment number and values are inserted into it.

I have also tried SELECT MAX(id) FROM mytable. This dosn't work neither.

I know that this problem has been talked about already. I read all posts but nothing came useful.

Many thanks Francesco

Can you show the exact code you are using? Are you sure you are using the right database connection? — Pekka
– Pekka, Commented Dec 14, 2009 at 12:22
Thank you Pekka, the feedback from Jan worked perfectly. PS the database connetion was fine. — frapet
– frapet, Commented Dec 14, 2009 at 12:41

Jan Hančič · Accepted Answer · 2009-12-14 12:21:46Z

3

You have to use the value returned by MySql_Insert_Id () when you generate your link:

// your query
$newId = MySql_Insert_Id ();

$insertGoTo = "confirm_booking.php?booking_ID=" . $newId;

answered Dec 14, 2009 at 12:21

Jan Hančič

54k17 gold badges99 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

frapet Over a year ago

Thank you Jan for your feedback. It does now send the ID but it does not get it in the next page.

frapet Over a year ago

Found the problem. Thank you Jan you saved my day!

wuputah · Accepted Answer · 2010-09-06 20:16:38Z

3

Offhand, I can think of a few cases where MySQL wouldn't return the ID:

The table you're inserting into doesn't have an AUTO_INCREMENTed primary key.
You're inserting multiple rows at once.
You're calling mysql_insert_id() from a different connection than the INSERT query was executed.
The INSERT query didn't succeed (for instance, it encountered a deadlock). Make sure you are checking the return value from mysql_query(), then use mysql_errno() and mysql_error().

MySQL docs have a full list of conditions and details on how this function works.

Of course, it's also possible there is a bug in MySQL, which would depend on which version of MySQL you are using.

edited Sep 6, 2010 at 20:16

answered Sep 6, 2010 at 20:11

wuputah

11.4k1 gold badge45 silver badges61 bronze badges

Comments

Jeff Noel · Accepted Answer · 2012-11-26 18:59:39Z

3

It is possible that your table does not have any AUTO_INCREMENT field!

It could also happen because you have two or more mysql connections at the same time. In this case you should use a link identifier.

$link = mysql_connect( ... );
mysql_select_db('mydb', $link);
mysql_query('INSERT mytable SET abc="123"', $link);
$inserted_id = mysql_insert_id($link);

edited Nov 26, 2012 at 18:59

Jeff Noel

7,6274 gold badges43 silver badges67 bronze badges

answered Dec 14, 2009 at 12:38

merkushin

4819 silver badges17 bronze badges

Comments

Samuel · Accepted Answer · 2009-12-14 12:23:02Z

2

Some key points from the PHP Manual:

The ID generated for an AUTO_INCREMENT column by the previous query on success, 0 if the previous query does not generate an AUTO_INCREMENT value, or FALSE if no MySQL connection was established.

If not having an AUTO_INCREMENT field is not your problem, you might want to try storing the result of the mysql_query call and using that as an argument to the id function

$result = mysql_query("...");
$id = mysql_insert_id($result);

answered Dec 14, 2009 at 12:23

Samuel

17.3k6 gold badges65 silver badges77 bronze badges

1 Comment

frapet Over a year ago

The auto_increment is successful and connetion is established. All is fine.

Eric Mittler · Accepted Answer · 2010-06-18 21:35:08Z

1

mysql_insert_id may return 0 or false if your insert fails right? So if you have trouble with mysql_insert_id not retunring what you expect confirm that you don't have a unique constraint or some other problem with your sql that would cause the insert to fail. Using max is a terrible idea if you consider this.

answered Jun 18, 2010 at 21:35

Eric Mittler

111 bronze badge

Comments

WebsterDevelopine · Accepted Answer · 2013-10-07 03:36:45Z

1

Had an issue using a query like this:

INSERT INTO members (username,password,email) VALUES (...)

reason being that the id (which is my primary key and Auto Increment field) is not part of the query.

Changing it to:

INSERT INTO members (id,username,password,email) VALUES ('',...)

using a an empty value '' will have MySQL use the Auto Increment value but also allow you to use it in your query so you can return the insert id

answered Oct 7, 2013 at 3:36

WebsterDevelopine

1154 bronze badges

1 Comment

Thibault Witzig Over a year ago

Very useful tip that deserves more upvotes. It is quite common to omit the ID column rather than passing it an empty string when using an auto increment.

Paweł Tomkiel · Accepted Answer · 2015-04-27 20:53:18Z

0

Make sure to put mysql_insert_id()after the

mysql_query($sql, $con); //Execute the query

Above query responsible for execute your Insert INTO ... command. After you can get the last ID inserted

edited Apr 27, 2015 at 20:53

Paweł Tomkiel

1,9842 gold badges21 silver badges39 bronze badges

answered Apr 27, 2015 at 19:54

Denuwan.hh

661 silver badge3 bronze badges

1 Comment

Paweł Tomkiel Over a year ago

Question clearly states that mysql_insert_id is issued after mysql_query;

santosh devnath · Accepted Answer · 2015-07-14 13:59:19Z

0

I have also suffer from this problem. Finally I found that the problem occur in my connection to the database. You can use this following connection code to connect the database then you can easily use mysqli_insert_id().

$db_connect = mysqli_connect("localhost", "root", "", "social");

Then you can use mysqli_insert_id() as

$id = mysqli_insert_id($db_conx);

I hope this will help you. I you have any problem then leave your comment.

answered Jul 14, 2015 at 13:59

santosh devnath

1706 bronze badges

Comments

Boycott A.I. · Accepted Answer · 2015-09-09 17:01:25Z

0

The mysqli_insert_id function has been deprecated. This may be your problem.

Instead, try $mysqli->insert_id. See the documentation for more info.

answered Sep 9, 2015 at 17:01

Boycott A.I.

19.2k30 gold badges183 silver badges264 bronze badges

Collectives™ on Stack Overflow

php mysql_insert_id(); not working [closed]

9 Answers 9

2 Comments

Comments

Comments

1 Comment

Comments

1 Comment

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

9 Answers 9

2 Comments

Comments

Comments

1 Comment

Comments

1 Comment

1 Comment

Comments

Comments

Linked

Related