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 vote295 views1 answer
Turn error log WP
PHP
1 vote348 views1 answer
Copy env example to .env in laravel
PHP Laravel
6 votes338 views6 answers
Install php 7.4
PHP
1 vote295 views2 answers
Run shell script from php file
PHP
0 vote303 views1 answer
Livewire component lost data
PHP
0 vote300 views1 answer
Codeigniter get parameter from url
PHP
11 votes303 views2 answers
Php string parse with separator explode
PHP
11 votes308 views6 answers
Convert object to array in php
PHP
0 vote298 views1 answer
Infyom skip file generation
PHP
1 vote371 views2 answers
Throttle laravel
PHP