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 vote253 views1 answer
Composer create-project --prefer-dist laravel/laravel blog
PHP Laravel
0 vote258 views1 answer
Case inside laravel query
PHP Laravel
29 votes231 views4 answers
Php else
PHP
0 vote276 views1 answer
Group where conditions in laravel
PHP Laravel
4 votes225 views6 answers
Convert DateTime to String in PHP
PHP
1 vote253 views2 answers
Wordpress login programmatically
PHP Wordpress
2 votes228 views2 answers
Target class [AppHttpControllersRegisterController] does not exist. laravel 8
PHP
1 vote226 views2 answers
Db name laravel
PHP
1 vote233 views1 answer
SQLSTATE[HY000]: General error: 1005 Can't create table ``.`labels` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table `labels` add constraint
PHP
0 vote230 views1 answer
Php huruf besar di awal
PHP