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

14 votes310 views6 answers
Update query in laravel eloquent
PHP Laravel
1 vote295 views1 answer
Oci_execute(): ORA-01810: format code appears twice in
PHP
2 votes272 views1 answer
Php get username from iis
PHP
0 vote347 views1 answer
Use wordpress functions in external php file
PHP Wordpress
0 vote275 views1 answer
Class 'Spatie\YamlFrontMatter\YamlFrontMatter' not found
PHP
0 vote309 views1 answer
Lcomposer symfony/filesystem
PHP
0 vote285 views1 answer
Laravel force user logout
PHP
0 vote276 views1 answer
Edit items in Laravel collection
PHP
66 votes306 views6 answers
Php timestamp to date
PHP
11 votes305 views5 answers
Array_diff php
PHP