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 vote224 views1 answer
Laravel passport generate key
PHP Laravel
0 vote170 views1 answer
Converting php to codeigniter
PHP
0 vote164 views1 answer
Optional chain operator php
PHP
0 vote197 views3 answers
Laravel load relationship
PHP Laravel
0 vote141 views1 answer
Php join array to parenthesis
PHP
0 vote202 views1 answer
Install or enable PHP's zip extension mac os
PHP
0 vote162 views1 answer
Compact example in php
PHP
28 votes228 views6 answers
Laravel make model with migration
PHP Laravel
0 vote186 views1 answer
Laravel 8 created at format
PHP
2 votes189 views2 answers
Php initialize array
PHP