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

23 votes230 views6 answers
Laravel validation messages
PHP Laravel
0 vote190 views1 answer
Php static dropdown list example
PHP
3 votes217 views1 answer
Laravel carbon get year number
PHP Laravel
0 vote279 views1 answer
Laravel Filesystem chmod(): Operation not permitted
PHP Laravel
3 votes198 views2 answers
Refresh seeder laravel
PHP
2 votes196 views1 answer
Read global laravel request()
PHP
3 votes200 views3 answers
Php read csv to array
PHP
9 votes188 views3 answers
Relative path
PHP
2 votes240 views4 answers
Laravel htaccess
PHP
0 vote143 views1 answer
Add-basic-controller-imports
PHP