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

Written by Ian Carnaghan · 17 sec read >

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);
//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.

Last Updated On March 25, 2018
Written by 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. Profile

Leave a Reply

Notify of