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

48 votes268 views6 answers
Laravel joins
PHP Laravel
3 votes150 views6 answers
Php preg_match
PHP
0 vote152 views1 answer
Php 8 jit does not work
PHP
1 vote153 views1 answer
Have_rows count acf php
PHP
1 vote149 views3 answers
Queue jobs in laravel
PHP
5 votes147 views6 answers
Php remove duplicates from multidimensional array
PHP
0 vote167 views1 answer
Ci base url dynamic
PHP
1 vote166 views2 answers
How add field to table by another migration in laravel
PHP Laravel
0 vote178 views1 answer
How to get webhook response in laravel
PHP Laravel
16 votes149 views3 answers
How to convert string word to lowercase in php
PHP