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

0 vote253 views1 answer
Propel find index
PHP
1 vote231 views1 answer
Php if string is already in database
PHP
0 vote240 views2 answers
Login with email and phone laravel
PHP
0 vote249 views1 answer
Php range from one
PHP
3 votes261 views3 answers
Fillable property to allow mass assignment
PHP
0 vote328 views1 answer
Wordpresss loop through object
PHP Wordpress
0 vote241 views1 answer
Php mysql insert timestamp now
PHP
0 vote317 views1 answer
Wp wc php if not is single product page
PHP Wordpress
0 vote255 views1 answer
Php date month italian
PHP
0 vote244 views1 answer
Laravel get current action name
PHP