How to get the last Inserted Id using the Joomla! Platform

H

How Can We Help?

How to get the last Inserted Id using the Joomla! Platform

After you performed an Insert statement use the insertid method to get the auto-incremented value from the last Insert statement

$db = $this->getDbo();
$query  = $db->getQuery(true);
 $query->clear();
$query->insert('#__database_table1');
$query->set("id=".(int)$id);
$db->setQuery($query);
 $db->query();
 
//Now we get the last inserted id
$lastInsertId = $db->insertid();
 
echo $lastInsertId;

Note in the above code we used $db->insertid(); to obtain the last inserted id.

About the author

Ian Carnaghan

I am a software developer and online educator who likes to keep up with all the latest in technology. I also manage cloud infrastructure, continuous monitoring, DevOps processes, security, and continuous integration and deployment.

About Author

Ian Carnaghan

I am a software developer and online educator who likes to keep up with all the latest in technology. I also manage cloud infrastructure, continuous monitoring, DevOps processes, security, and continuous integration and deployment.

Follow Me