PHP 中的 mysqli sqlstate函数

mysqli sqlstate - 语法

mysqli_sqlstate(connection);

此函数返回最后一个错误的SQLSTATE错误代码。

mysqli sqlstate - 返回值

错误代码由五个字符组成。 “ 00000”表示没有错误。

无涯教程网

mysqli sqlstate - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","password","db");
   
   if (mysqli_connect_errno($connection_mysql)){
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }
   
   $sql="CREATE TABLE Persons (Firstname VARCHAR(30),Lastname VARCHAR(30),Age INT)";
   
   if (!mysqli_query($connection_mysql,$sql)){
      echo "SQLSTATE error: ". mysqli_sqlstate($connection_mysql);
   }
   
   mysqli_close($connection_mysql);
?>