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 votes245 views6 answers
Remove index.php in codeigniter
PHP CodeIgniter
0 vote129 views1 answer
Woocommerce change sale text
PHP
0 vote139 views1 answer
How to put external file in laravel listener class
PHP
4 votes157 views4 answers
Php artisan drop table
PHP
0 vote168 views1 answer
Count column eloquent laravel
PHP Laravel
0 vote119 views2 answers
Get last two numbers from int php
PHP
0 vote122 views1 answer
Laravel adding new items to config run time
PHP
0 vote126 views1 answer
Indirect modification of overloaded property has no effect laravel
PHP
0 vote157 views1 answer
Setup cron on macos for laravel
PHP Laravel
0 vote144 views3 answers
Laravel s3 download file
PHP Laravel