PHP mysqli_insert_id() Function without INSERT

Question

PHP mysqli_insert_id() Function

This code print last ID in w3school.com:

<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

mysqli_query($con,"INSERT INTO Persons (FirstName,LastName,Age) 
VALUES ('Glenn','Quagmire',33)");

// Print auto-generated id
echo "New record has id: " . mysqli_insert_id($con); 

mysqli_close($con);
?>

But I do not want insert anything...I just I want to have last Id,

I try build my own function like this:

function getlast()
    {
        $con = connectDB();
        $sql = "SELECT id FROM Articls";
        $result = $con->query($sql);
        $latestID = $result->insert_id;
        disconnectDB($con);
        return $latestID;

    }

but seems it's wrong

take a look here: http://stackoverflow.com/questions/15821532/get-current-auto-increment-value-for-any-table — ITroubs, Jan 16 '15 at 18:59

Jay Blanchard · Accepted Answer · 2015-01-16T19:11:06.447

3

Just select the MAX id -

 $sql = "SELECT MAX(id) FROM Articls";

MySQL MAX

edited Jan 16 '15 at 19:11

answered Jan 16 '15 at 18:59

Jay Blanchard

34,243
16
77
119

PHP mysqli_insert_id() Function without INSERT

1 Answers1