codeigniter get last insert

PHP
$id = $this->db->insert_id();  $db = db_connect();
  $query = $db->query("SELECT * FROM users ORDER BY id DESC LIMIT 1");
  $result = $query->getRow();
Source

Also in PHP: