Grab last ID of Insert query

Question

I need to get the story_id from the last insert. Ive tried using mysql_insert_id() but it doesn't seem to work with my statement. Here is the code:

$stmt = $this->db->prepare("INSERT INTO active_stories (story_id, current_chapter, creator, cover_title, cover_img_name, create_date, last_update_date, story_tags, locked) VALUES (NULL, ?, ?, ?, ?, ?, ?, ?, ?)");
        $stmt->bind_param("issssssi",$zero, $creatorName,$storyTitle, $fileName, $createDate, $createDate, $themeTags, $zero);
        $stmt->execute();
        printf("Last inserted record has id %d\n", mysql_insert_id());
        $stmt->close();

Same question asked here. http://stackoverflow.com/questions/5057954/get-last-insert-id-after-a-prepared-insert-with-pdo — ExtremelyPoorMan, Jun 12 '12 at 15:48
thanks, I tried to search for this but didn't know it was called PDO — mkral, Jun 12 '12 at 15:50

ariefbayu · Accepted Answer · 2012-06-12T16:11:33.390

5

If you are using PDO, here's how to get that:

PDO::lastInsertId()

If using mysqli, try this one:

mysqli::$insert_id

edited Jun 12 '12 at 16:11

answered Jun 12 '12 at 15:46

ariefbayu

21,849
12
71
92

when I do `$storyID = $db->lastInsertId('story_id');` I get the following error: `Call to a member function lastInsertId() on a non-object` – mkral Jun 12 '12 at 16:00
use `$this->db->lastInsertId('story_id');` – ariefbayu Jun 12 '12 at 16:02
hmm, I guess I'm using mysqli not PDO. – mkral Jun 12 '12 at 16:08
if that's the case, than you want to see this: http://www.php.net/manual/en/mysqli.insert-id.php – ariefbayu Jun 12 '12 at 16:10
2

I figured it out, its `$stmt->insert_id;` for mysqli. you pointed me in the right direction so thanks! – mkral Jun 12 '12 at 16:11
sorry if this is off-topic but is PDO recommended over mysqli? – mkral Jun 12 '12 at 16:13
yes, if sometime in the future you want to support another database. – ariefbayu Jun 12 '12 at 16:14

Grab last ID of Insert query

1 Answers1