Getting the id of the last record inserted into a MySQL database

Question

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'];

`print_r($row);` will show you. Also `error_reporting(E_ALL); ini_set('display_errors', '1');` would have led you there. — AbraCadaver, Mar 30 '17 at 18:24

score 2 · Accepted Answer · answered Mar 30 '17 at 18:24

2

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'];

answered Mar 30 '17 at 18:24

ScaisEdge

131,976
10
91
107

score 2 · Answer 2 · answered Mar 30 '17 at 18:29

2

Use MAX(id) as id in select query

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

answered Mar 30 '17 at 18:29

Rafiqul Islam

1,636
1
12
25

Shafiqul Islam · Answer 3 · 2017-03-30T18:37:42.023

1

you can use this built in function for get last insert id

$last_id = mysqli_insert_id($conn);

if you want to get max record id from your db and if id this your primary key then you can use this code

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

and if you want to get specific max record then use this code. if id your filed then you can use this code . you use alias for get record

$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'];

edited Mar 30 '17 at 18:37

answered Mar 30 '17 at 18:26

Shafiqul Islam

5,570
2
34
43

This won't work. OP wants to fetch records not insert – Rotimi Mar 30 '17 at 18:27
ok i am adding this too – Shafiqul Islam Mar 30 '17 at 18:28

score 0 · Answer 4 · answered Mar 30 '17 at 19:03

0

Try with this :

$sql = "SELECT * FRON tbl_uploads ORDER BY id DESC LIMIT 1";

It will output your id.

answered Mar 30 '17 at 19:03

DamiToma

921
3
9
27

Getting the id of the last record inserted into a MySQL database

4 Answers4