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();

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);

Source: makitweb.com

Similar codes

12 votes248 views2 answers
Php how to delete file
PHP
9 votes260 views6 answers
Php cors
PHP
0 vote246 views1 answer
Laravel eloquent save method return value
PHP
1 vote267 views2 answers
How to delete image from aws using laravel 8
PHP
0 vote280 views1 answer
Laravel collection forget
PHP
0 vote275 views1 answer
Check if any field update laravel
PHP Laravel
0 vote251 views1 answer
Php new PDO timeout
PHP
0 vote362 views3 answers
Laravel 7 factory tinker
PHP Laravel
0 vote265 views1 answer
Fakher ul islam khan
PHP
0 vote253 views1 answer
Php display result from html
PHP