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

4 votes336 views3 answers
Laravel on delete set null
PHP
4 votes283 views2 answers
Php die
PHP
0 vote311 views1 answer
Bootstrap carousel foreach loop not working wordpressp php wp
PHP
0 vote302 views1 answer
How to pass value in app.blade
PHP
1 vote309 views1 answer
PHP Time Limit:
PHP
0 vote342 views1 answer
Route pattern cannot reference variable name more than once. laravel
PHP
0 vote420 views1 answer
Deactivate auto update wordpress plugins
PHP Wordpress
3 votes308 views1 answer
Php get uploaded file extension
PHP
0 vote310 views1 answer
Never return type - PHP 8.1
PHP
1 vote330 views2 answers
Mac php ini file path
PHP