How to get last id inserted. mysql_insert_id() not working

Question

I am working in opencart version 2x. I am trying to get the last id of row inserted.This code working for 1.5x version but returning nothing in 2x

My code:

$this->db->query("INSERT INTO `" . DB_PREFIX . "endicia_label_info`  SET order_id  = '$orderID',postage_balance = '$postage_balance',file_name='$fileName',dte_created_date_time = NOW(),tracking_no='$tracking_no',final_postage = '$final_postage',mail_type='$Mailtype',mail_class='$ClassMail',label_size='$labelimgsize',label_pieces='$labelpieces',labelname='$labelname',Status='$Status'");
$label_id = mysql_insert_id();
return $label_id;

Answer 1

Try with this method $this->db->getLastId();

Answer 2

You need to use this in OpenCart for getting last insert id:

$this->db->getLastId()

From OpenCart User Guide:

Method Reference / DB::getLastId(): Returns the ID generated for an AUTO_INCREMENT column by the previous query.