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 vote143 views1 answer
Wpml language switcher shortcode
PHP
1 vote132 views1 answer
Laravel createmany example
PHP
0 vote153 views1 answer
Drupal 8 custom form image field
PHP
2 votes137 views1 answer
Laravel force login by id
PHP
0 vote163 views1 answer
Next year php string
PHP
0 vote126 views1 answer
Laravel simplexmlelement not found
PHP
1 vote157 views2 answers
Add laravel sail build as alias
PHP Laravel
0 vote138 views2 answers
How to get display name in wordpress
PHP
0 vote163 views1 answer
Make controller laravel history open link
PHP Laravel
1 vote126 views1 answer
Program logic for second largest number in an array in php
PHP