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

49 votes243 views6 answers
Laravel migration add column to existing table
PHP
0 vote273 views1 answer
Laravel npm run deve error mix
PHP
22 votes275 views6 answers
Laravel 6 auth
PHP
2 votes302 views4 answers
Laravel hash password check
PHP Laravel
2 votes333 views3 answers
Add data to the collection laravel
PHP Laravel
-1 vote292 views2 answers
Php mysql if not exists insert
PHP
6 votes262 views6 answers
Notice: Array to string conversion php
PHP
0 vote260 views2 answers
How to insert last id from crud grocery codeigniter
PHP
0 vote306 views1 answer
Laravel maintenance mode custom class
PHP Laravel
4 votes279 views2 answers
Php strict mode
PHP