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 vote171 views1 answer
Laravel rule unique where
PHP
0 vote156 views1 answer
How to increment a number after concatinating it with a date function in php
PHP
1 vote198 views1 answer
Problem 1 - phpspec/prophecy is locked to version 1.13.0 and an update of this package was not requested. - phpspec/prophecy 1.13.0 requires php ^7.2 || ~8.0, <8.1 -> your php version (8.1.2) does not satisfy that requirement.
PHP
0 vote198 views1 answer
Laravel form in 24 hours format
PHP Laravel
4 votes188 views2 answers
Check request header laravel
PHP Laravel
0 vote184 views2 answers
Yii2 get params from url
PHP
0 vote186 views1 answer
Laravel check if primary key exists
PHP Laravel
0 vote291 views1 answer
Drupal 9 remove field from view
PHP Drupal
0 vote169 views1 answer
Codeigniter get user ip
PHP
1 vote157 views1 answer
How make exception laravel if operation does not work
PHP