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 vote140 views1 answer
Php fpm config file location
PHP
3 votes148 views1 answer
Php set session timeout
PHP
4 votes149 views4 answers
Wp enqueue styles
PHP Wordpress
0 vote132 views1 answer
Case inside laravel query
PHP
0 vote169 views2 answers
Laravel sanctum instalation
PHP Laravel
1 vote134 views2 answers
Get file name from url in php
PHP
4 votes168 views2 answers
Laravel migration update table column type
PHP Laravel
0 vote199 views1 answer
Confirm password in codeigniter
PHP
0 vote144 views3 answers
Ubuntu update php 7.4 to 8
PHP
0 vote151 views1 answer
In Connection.php line 664:SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema
PHP