Call to undefined function last_insert_id()

Question

I would like to return the ID "setsId" after I insert values in the the Sets table.

This is the error I receive: Call to undefined function last_insert_id().

Here is my code:

if($_POST[reps]=="")
{
echo "Record can not be added. All fields are mandatory";
echo '<br>';
}
else
{
    $con = mysqli_connect(); //removed for privacy

    if (mysqli_connect_errno())
    {
       echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    $sql="INSERT INTO Sets (exerciseId, bandId, reps, notes) 
    VALUES ('$_POST[exerciseId]',
        '$_POST[bandId]',
        '$_POST[reps]',
        '$_POST[notes]')";

    $sId=last_insert_id();

    if (!mysqli_query($con,$sql))
    {
        die('Error: ' . mysqli_error($con));
    }


    echo '<div id ="error">';
    echo 'SUCCESS!';
    echo '<br>';
    echo "1 record added";
    echo '<br>';
    echo '</div>';
    mysqli_close($con);
}
include ('ptfooter.html');
?>

Could someone please let me know how I am using the function last_insert_id() incorrectly so that it would cause an error?

You should first execute the query then call last_insert_id function — Tarun, Dec 01 '13 at 09:11

score 7 · Accepted Answer · answered Dec 01 '13 at 09:12

7

last_insert_id is the name of a MySQL function. The corresponding mysqli function is called mysqli_insert_id. Use that instead.

But you can't call that function if you haven't executed your insert query yet. Make sure that your insert is executed (and succeeded) before you call that function.

answered Dec 01 '13 at 09:12

Mat

202,337
40
393
406

"`last_insert_id`" doesn't exist, not even in mysql. :) – deceze Dec 01 '13 at 09:15
Not sure I understand your comment, @deceze, http://dev.mysql.com/doc/refman/5.5/en/information-functions.html#function_last-insert-id – Mat Dec 01 '13 at 09:18
I mean in the PHP mysql (all lowercase) API. :) – deceze Dec 01 '13 at 13:10

Call to undefined function last_insert_id()

1 Answers1