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

3 votes381 views3 answers
How to get last id in database codeigniter 4
PHP CodeIgniter
28 votes271 views5 answers
Laravel whereRaw
PHP
0 vote272 views1 answer
How to increment a number after concatinating it with a date function in php
PHP
0 vote288 views1 answer
Wc php free shipping function
PHP
0 vote324 views1 answer
Php ?? vs ?:
PHP
0 vote318 views1 answer
Non-static method Barryvdh\DomPDF\PDF::loadView() should not be called statically
PHP
0 vote294 views2 answers
Laravel sortby varchar date
PHP Laravel
1 vote283 views1 answer
Enablequerylog laravel
PHP Laravel
0 vote264 views1 answer
Php new PDO timeout
PHP
1 vote325 views1 answer
Laravel get last get request
PHP Laravel