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 votes206 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
-1 vote234 views1 answer
Php get file location
PHP
0 vote185 views1 answer
Php rsort retain keys
PHP
0 vote135 views1 answer
Favicon php
PHP
1 vote172 views1 answer
Increament single column laravel current value + 1
PHP
0 vote172 views1 answer
Yii2 clear schema cache
PHP
24 votes223 views6 answers
Laravel create model
PHP Laravel
0 vote180 views3 answers
Cpanel email to email send with php
PHP
39 votes194 views10 answers
Php array append
PHP
0 vote205 views1 answer
Publish Spatie Laravel Permission
PHP Laravel