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

-1 vote94 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote121 views1 answer
Drupal 9 entity.repository load entity by UUID
PHP
0 vote118 views1 answer
Php select disable submit no value
PHP
0 vote124 views2 answers
Create file in laravel
PHP
0 vote115 views1 answer
Button back php
PHP
1 vote175 views1 answer
Symlink in php
PHP
4 votes173 views3 answers
How to create an associative array in php
PHP
1 vote126 views1 answer
Close mysql connection in php
PHP
1 vote133 views2 answers
Wordpress get option value
PHP Wordpress
1 vote134 views1 answer
Webuzo set upload limit
PHP