PHP MySQLi and MySQLi_STMT: Which insert_id to use?
- by Carvell Fenton
Hello all,
Both the MySQLi and MySQLi_STMT classes have an $insert_id property.
If I am connected to my database using a MySQLi object (say $db), and then I perform an INSERT with a MySQLi_STMT object (say $stmt), to get the id of the last INSERT, should I use:
$last_id = $db->insert_id;
or
$last_id = $stmt->insert_id;
Or would they be the same, in which case it doesn't matter?
I thought this might be a quick answer for someone, and save me the time of writing the test code to check it.
Thanks in advance as always.