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

1 vote325 views1 answer
How to add php 7.4 in homebrew
PHP
5 votes305 views1 answer
Laravel update data in database
PHP
1 vote363 views2 answers
How to delete image from aws using laravel 8
PHP Laravel
16 votes392 views5 answers
Get user auth in laravel
PHP
3 votes350 views5 answers
Get current locale laravel
PHP Laravel
51 votes453 views6 answers
Laravel run all seeders
PHP Laravel
2 votes386 views2 answers
Php remove non numeric
PHP
1 vote370 views1 answer
Get original name without mutant model laravel
PHP
0 vote326 views1 answer
Add line in string column export php
PHP
0 vote309 views1 answer
Laravel hiding attributes JSON
PHP