javascript - 未定义最后插入的 ID

Question

我需要获取最后插入的id

   $stmt = $db->query("SELECT LAST_INSERT_ID();");
   $row = $stmt->fetch();
   echo $row['id'];

js

    success: function(data) {
        console.log(data);
}

结果:未定义!

Answer 1

您必须分配正确的别名

$stmt = $db->query("SELECT LAST_INSERT_ID() as id;");
$row = $stmt->fetch();
echo $row['id'];

否则 echo $row['id'] 为空