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

1 vote106 views3 answers
Laravel check if item is in collection
PHP
0 vote94 views1 answer
Cakephp get present name
PHP
-1 vote124 views1 answer
Tackel discount in javascript
PHP
2 votes95 views2 answers
Php remove array element reset keys
PHP
3 votes90 views3 answers
Php extract zip
PHP
0 vote96 views1 answer
Drupal 9 modify a views query
PHP
0 vote116 views1 answer
@lang laravel blade
PHP Laravel
0 vote113 views1 answer
Laravel mcq questions
PHP Laravel
4 votes319 views6 answers
Laravel jwt
PHP Laravel
0 vote117 views1 answer
Php mysql remove by timestamp older than a month
PHP