I have the following code. The mysqli_insert_id() (in this case "$last_row"), which is supposed to return the last row of the table, is always returning 0. Why is it so?
<?php
include 'connect-db.php';
$last_row = mysqli_insert_id($connection);
if ($content != '') {
$sql = "INSERT INTO myCity VALUES (NULL, 'Stuttgart', 'DEU', 'Stuttgart', 617000)";
if (!mysqli_query($connection, $sql)) {
die('Error: ' . mysqli_error($connection));
}
echo $last_row;
mysqli_close($connection);
}
mysqli_insert_id
does not return the ID of the last row of the table. From the docs, it:
...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
orUPDATE
statement or if the modified table does not have a column with theAUTO_INCREMENT
attribute, this function will return zero.
(My emphasis)
That is, if you were to run it immediately after an insert that auto-generated an ID, on the same connection you did the insert with, it would return the ID generated for that insert.
This is illustrated by the example in the docs linked above:
$query = "INSERT INTO myCity VALUES (NULL, 'Stuttgart', 'DEU', 'Stuttgart', 617000)";
$mysqli->query($query);
printf ("New Record has id %d.\n", $mysqli->insert_id);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With