Lấy giá trị AUTO_INCREMENT của bảng trong MySQL

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'DatabaseName'
AND   TABLE_NAME   = 'TableName';

<?php
    $db = new mysqli("localhost", "user", "password", "YourDatabaseName");

    if ($db->connect_errno) die ($db->connect_error);

    $table=$db->prepare("SHOW TABLE STATUS FROM 'YourDatabaseName'");
    $table->execute();
    $sonuc = $table->get_result();

    while ($satir=$sonuc->fetch_assoc()){
        if ($satir["Name"]== "YourTableName"){
            $ai[$satir["Name"]]=$satir["Auto_increment"];
        }
    }

    $LastAutoIncrement=$ai["YourTableName"];

    echo $LastAutoIncrement;
?>

// Connect PDO
$db = new PDO(...);

// Lấy AUTO_INCREMENT tiếp theo
$stmt = $db->query("SHOW TABLE STATUS LIKE 'tableNam'");

$row = $stmt->fetch();

echo $auto_increment = $row[‘Auto_increment’];