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 vote192 views1 answer
How to get current location in laravel
PHP Laravel
0 vote205 views2 answers
Can we generate alphanumeric 6 digit primary key in phpmyadmin
PHP
0 vote218 views1 answer
Main.php
PHP
1 vote150 views1 answer
Filemtime($current_file_name);
PHP
1 vote162 views1 answer
Get elasticsearch data magento 2
PHP
47 votes312 views6 answers
Laravel create seeder
PHP Laravel
-1 vote155 views1 answer
Cpt url rewrite
PHP
2 votes186 views2 answers
Laravel collection push
PHP Laravel
7 votes158 views2 answers
Php memory_limit unlimited
PHP
1 vote194 views1 answer
Laravel date rule before 18 years ago
PHP Laravel