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 vote138 views1 answer
Codeigniter get user ip
PHP
2 votes124 views2 answers
Php factorial
PHP
2 votes141 views2 answers
Form submit self php isset
PHP
4 votes256 views2 answers
Php select option selected from database
PHP
0 vote140 views1 answer
PHP DateTime Format date time according to a time zone
PHP
2 votes167 views2 answers
Laravel 8 websockets
PHP Laravel
0 vote143 views2 answers
Wp max revisions
PHP
0 vote143 views1 answer
Cashier mollie
PHP
0 vote139 views1 answer
Wp wc php use comma separated thousands
PHP
9 votes170 views3 answers
Laravel with select
PHP