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 vote71 views1 answer
Array to strng sepreated by comma
PHP
1 vote121 views1 answer
Wordpress acf get checkbox options
PHP
2 votes108 views2 answers
File exist check in laravel blade
PHP
8 votes111 views6 answers
Php float value
PHP
0 vote122 views1 answer
Php force array keys trim
PHP
2 votes120 views1 answer
Install or enable PHP's xml extension
PHP
0 vote103 views1 answer
Laravel log permission denied mac
PHP
23 votes138 views5 answers
Ucwords in php
PHP
2 votes100 views2 answers
Sort a multidimensional array by date element in php
PHP
0 vote122 views1 answer
Uncaught ReferenceError: commonL10n is not defined
PHP