获取插入MySQL数据库的最后一条记录的id [重复]

Question

This question already has an answer here:

• How do I get the last inserted ID of a MySQL table in PHP? 22 answers

I'm trying to get the id of the last record inserted into a MySQL database using MAX(id). I can't figure out why my query is not returning any results. Is there something wrong with my PHP?Tthe query works if I try it inside phpmyadmin.

include("db_conx.php"); //Connect to db mysqli
$sql = "SELECT MAX(id) FROM tbl_uploads";  
$result = $db_conx->query($sql);
$row = $result->fetch_assoc();
echo 'last_id: '.$row['id'];

</div>

Answer 1

use an alias for get the value

  $sql = "SELECT MAX(id) as max_id FROM tbl_uploads";  
  $result = $db_conx->query($sql);
  $row = $result->fetch_assoc();
  echo 'last_id: '.$row['max_id'];