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

2 votes264 views2 answers
Laravel eloquent randomise data from database
PHP Laravel
0 vote254 views1 answer
Laravel eloquent relationships count
PHP Laravel
22 votes232 views6 answers
Php array_merge
PHP
0 vote234 views1 answer
Codeigniter get user ip
PHP
0 vote203 views1 answer
Markdown mail html rendering laravel
PHP
1 vote201 views1 answer
Default php program
PHP
5 votes240 views3 answers
Globals in php
PHP
0 vote215 views1 answer
Php regex markdown link
PHP
1 vote229 views1 answer
How to change laravel 8 login credentials
PHP Laravel
6 votes432 views2 answers
Laravel check if request has value
PHP