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

8 votes239 views6 answers
Php trim
PHP
1 vote194 views2 answers
Upload a pdf file laravel
PHP
0 vote200 views1 answer
Wordpress get archive title
PHP Wordpress
0 vote272 views1 answer
Wp wc php if not is single product page
PHP Wordpress
1 vote174 views2 answers
Laravel compare date timestamp
PHP
0 vote229 views1 answer
Laravel migration unknown column type double requested
PHP
0 vote265 views1 answer
Ubuntu 7.2 deleted php
PHP
7 votes237 views4 answers
Insertgetid laravel 8
PHP Laravel
0 vote179 views1 answer
Parse error: syntax error, unexpected token "=", expecting ";" in C:\xampp\htdocs
PHP
4 votes188 views2 answers
Laravel sum group by
PHP