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 votes225 views1 answer
Laravel set appends
PHP Laravel
0 vote195 views1 answer
How to disable a button in a blade file
PHP
0 vote223 views1 answer
Laravel collection higher order messages
PHP Laravel
0 vote208 views1 answer
Upload images php mysql
PHP
0 vote230 views1 answer
Laravel child relation get max value
PHP Laravel
0 vote215 views5 answers
Run schedule laravel
PHP Laravel
1 vote184 views2 answers
Get template part pass variable
PHP
0 vote181 views1 answer
Wordpress get default date format
PHP
0 vote200 views1 answer
Php dirpath multiple file extensions
PHP
1 vote198 views1 answer
How to delete all products woocommerce in phpmyadmin
PHP