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

9 votes294 views5 answers
Php sha256 example
PHP
1 vote302 views1 answer
For each multiple php
PHP
2 votes309 views2 answers
Validate password laravel
PHP Laravel
0 vote239 views1 answer
How to call controller in view laravel
PHP
-1 vote282 views1 answer
Laravel hide columns
PHP
10 votes329 views2 answers
Laravel success message
PHP
0 vote297 views1 answer
Trait 'laravel\sanctum\HasApiTokens' not found laravel 7
PHP
24 votes278 views6 answers
Laravel create model
PHP
2 votes298 views2 answers
Laravel list of models
PHP Laravel
2 votes288 views1 answer
Merubah judul menjadi slug codeigniter
PHP