Answers for "how to get last id in database"

PHP
0

mysql get the last id php

// Insert query 
$query = "insert into users(username,fname,lname) values('sonarika','Sonarika','Bhadoria')"; 

mysqli_query($con,$query); 

// Get last insert id 
$lastid = mysqli_insert_id($con);
Posted by: Guest on May-16-2020
1

how to get last id in database

$db = db_connect();
  $query = $db->query("SELECT * FROM users ORDER BY id DESC LIMIT 1");
  $result = $query->getRow();
Posted by: Guest on November-13-2020

Code answers related to "how to get last id in database"

Browse Popular Code Answers by Language