Inserted objects ID

[lefox]

Is there a way to get the ID of last inserted object?

[brian]

In the DB.php class file, there is the following function you can use on the PDO object.

public function lastId(){
return $this->_lastId;
}

[mudmin]

I added that function because that issue always baffled me, and then I never actually used it in writing userspice.

Let's say you want to add a new user named Bob to your database whenever someone visited your homepage (which wouldn't be advised).

Code:

<?php

Code:

$fields=array('username'=>"bob");

Code:

$db->insert('users',$fields);

Code:

$lastId = $db->lastId();

Code:

echo $lastId;

Code:

?>

Loading this page would echo out the latest "Bob" user id.