How to get a column that has autoincrement?

Question

PHP

After inserting a row into the table, you need to get the id, how to do it?

$questionmarks = array_fill(0, sizeof($properties), '?');
$stmt = self::$db->prepare('INSERT INTO `' . static::getTableName() . '` (' . implode(',', array_keys($properties)) . ') VALUES (' . implode(',', $questionmarks) . ')');
$stmt->execute(array_values($properties));

Here is the code

Answer 1

https://www.php.net/manual/ru/pdo.lastinsertid.php
https://www.php.net/manual/ru/mysqli.insert-id.php
https://dev.mysql.com/ doc/refman/8.0/en/informatio...