Last insert id for procedural statement

[phppup]

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"

[ginerjm]

Using PDO?

[phppup]

@ginerjm if you read my post, I think it (and the headline title) indicate PROCEDURAL method in fairly clear terms.

Edited December 6, 2022 by phppup
Typos

[ginerjm]

Procedural can be using mysqli or pdo.  Think about it.

[phppup]

Using MySQLi

[maxxd]

Try https://www.php.net/manual/en/mysqli.insert-id.php. I'll skip the obligatory advice to switch to PDO for the moment.

[phppup]

2 hours ago, maxxd said:

Try https://www.php.net/manual/en/mysqli.insert-id.php

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 December 6, 2022 by phppup
Typos

[phppup]

Now I got it.

Researched printf and made sense of it all.

[Barand]

18 hours ago, ginerjm said:

Procedural can be using mysqli or pdo.

There must be some pages missing from the PDO section of my copy of the manual.