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 vote213 views2 answers
Laravel FileManager Display Blank pop up page
PHP Laravel
16 votes192 views4 answers
Wordpress debug mode enabled
PHP
6 votes217 views1 answer
Laravel eloquent whereDateBetween
PHP Laravel
20 votes193 views4 answers
Change php version in ubuntu
PHP
0 vote174 views1 answer
Wp php redirect my account page url to custom url
PHP
1 vote236 views1 answer
Get specific columns using with() function in laravel eloquent
PHP Laravel
0 vote171 views2 answers
Laravel dirty words check
PHP
4 votes174 views4 answers
Php search multidimensional array for multiple values
PHP
0 vote212 views2 answers
Convert string to array laravel
PHP
7 votes259 views4 answers
Many to many relationship laravel
PHP Laravel