I can't display the last value of the id column, what's wrong?

Question

PHP

Help to display the last value of the id column here is the code but it does not work thanks in advance

$result = $db->lastInsertRowid('id');

  foreach($result as $row) {

    print $row['id'];
  
    # code...
  }

Answer 1

In the case of SQLite, the lastInsertId function immediately returns a number:

$query = "insert into tbl (name) values (?);";
$stmt = $pdo->prepare($query);
$stmt->execute(['jfjd']);

print 'lastInsertId: ' . $pdo->lastInsertId();

Share PHP code