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

0 vote111 views1 answer
Laravel vue browser cache auto clear
PHP Laravel
0 vote96 views1 answer
Pre_get_posts order by title
PHP
0 vote109 views1 answer
Laravel check if model relation exists
PHP Laravel
0 vote97 views1 answer
Case inside laravel query
PHP Laravel
1 vote115 views2 answers
Cart::subtotal in laravel
PHP Laravel
0 vote96 views1 answer
Featured image tab not displayed on post
PHP
0 vote158 views1 answer
Filtrer les articles WordPress mis en avant
PHP Wordpress
1 vote103 views2 answers
Mixed content: the page at was loaded over https, but requested an insecure xmlhttprequest endpoint
PHP
2 votes91 views1 answer
Laravel check if session variable exists
PHP
0 vote95 views1 answer
Laravel mcq questions
PHP