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

2 votes147 views1 answer
Laravel artisan create criteria
PHP
0 vote191 views2 answers
Timestamp in model laravel
PHP Laravel
11 votes165 views4 answers
Php remove space before and after string
PHP
0 vote185 views1 answer
Php document append script to head
PHP
0 vote187 views1 answer
Php get ip by domain
PHP
11 votes211 views6 answers
Woocommerce php get product attributes
PHP
0 vote199 views1 answer
Laravel blade php variable concatenate javascript variable
PHP Laravel
1 vote415 views1 answer
Twig symfony get route
PHP
0 vote208 views2 answers
Php date format iso
PHP
0 vote188 views1 answer
Laravel adding new items to config run time
PHP Laravel