PDO::lastInsertId

[doddsey_65]

im trying to get the last inserted id from the database so when the user makes a post i can reload the page and center it on their post via the url hash(http://website/posts#221)

 

however everytime i try this i get a result of 0. here is my code:

 

$link->query("INSERT INTO ".TBL_PREFIX."posts
                (p_fid, p_tid, p_poster, p_name,
                p_content, p_time_posted)
                VALUES
                ('$forum_id', '$topic_id', '$user_name',
                '$subject', '$message', '".$config['time_now']."')
                ") or die(print_link_error());
echo $link->lastInsertId();

 

its just a simple insert query(which works as expected) but the lastInsertId function returns 0. where am i going wrong?

[cgsmith105]

Hey doddsey_65!

 

Going to have to see what lastInserID() does! 

 

If you are using mysql you can use the mysql_insert_id() function.  That will give you the ID of the most recent query performed.

[doddsey_65]

im using PDO not mysql

[cgsmith105]

PHP Site about the PDO::lastInsertID

Note:

 

This method may not return a meaningful or consistent result across different PDO drivers, because the underlying database may not even support the notion of auto-increment fields or sequences.

 

Try doing a prepare() and then pulling the lastInsertID before committing.

 

[doddsey_65]

Thanks for the info. This worked fine:

 

$insert = $link->prepare("INSERT INTO ".TBL_PREFIX."posts
                (p_fid, p_tid, p_poster, p_name,
                p_content, p_time_posted)
                VALUES
                ('$forum_id', '$topic_id', '$user_name',
                '$subject', '$message', '".$config['time_now']."')
                ") or die(print_link_error());
        
        $insert->execute();
        
        $lid = $link->lastInsertId();