Jump to content

Last insert id for procedural statement

Go to solution Solved by maxxd,

Recommended Posts

I am using the procedural method to insert data with a prepared statement.

Can someone please give me the correct format to obtain the last inserted id number under these conditions.

Just plugging simple form data into a table and want to echo a message stating "the record was successfully inserted as number $last_input"

Link to comment
Share on other sites

2 hours ago, maxxd said:

I used this

printf("New record has ID %d.\n", mysqli_insert_id($conn));

The good news is: it provided a result

The bad news: I have no idea why it works.

What does %d signify and where is it generated from?

2 hours ago, maxxd said:

I'll skip the obligatory advice to switch to PDO

Thank you so much!!!

Edited by phppup
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.