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

3 votes360 views6 answers
Remove square brackets from string php
PHP
0 vote363 views2 answers
Only Show Specific Countries In Caldera Forms Phone Field
PHP
0 vote367 views1 answer
Laravel phpdoc collection of model
PHP
0 vote349 views1 answer
Laravel Secured Password
PHP
26 votes343 views3 answers
SQLSTATE[42000]: Syntax error or access violation: 1071
PHP
0 vote371 views1 answer
Laravel send ajax
PHP
0 vote309 views1 answer
Chart trong laravel
PHP
3 votes388 views2 answers
How to change laravel port
PHP Laravel
0 vote333 views1 answer
$this- attribute laravel
PHP Laravel
1 vote374 views2 answers
Php exponential equation
PHP