(PHP 5, PHP 7)
mysqli::$sqlstate -- mysqli_sqlstate — 锟斤拷锟斤拷锟斤拷一锟斤拷 SQL 锟斤拷锟斤拷锟斤拷 SQLSTATE 锟斤拷锟斤拷锟斤拷息
锟斤拷锟斤拷锟斤拷锟斤拷锟�
锟斤拷锟教伙拷锟斤拷锟�
锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷 SQLSTATE 锟斤拷锟斤拷锟斤拷锟斤拷址锟斤拷锟斤拷锟斤拷锟绞撅拷锟揭伙拷锟� SQL 锟斤拷锟斤拷锟侥达拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 5 锟斤拷锟街凤拷锟斤拷锟缴ｏ拷'00000' 锟斤拷示没锟叫凤拷锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 ANSI SQL 锟斤拷 ODBC 锟斤拷锟斤拷模锟� 锟斤拷细锟斤拷锟藉单锟斤拷渭锟斤拷锟�» http://dev.mysql.com/doc/mysql/en/error-handling.html锟斤拷
Note:
锟斤拷要注锟斤拷锟斤拷牵锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷械锟� MySQL 锟斤拷锟斤拷映锟戒到 SQLSTATE 锟剿ｏ拷 未映锟斤拷拇锟斤拷锟斤拷锟较⑹癸拷锟� HY000锟斤拷锟桔合达拷锟襟）憋拷示锟斤拷
锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷 SQLSTATE 锟斤拷锟斤拷锟斤拷锟斤拷址锟斤拷锟斤拷锟斤拷锟绞撅拷锟揭伙拷锟� SQL 锟斤拷锟斤拷锟侥达拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 5 锟斤拷锟街凤拷锟斤拷锟缴ｏ拷'00000' 锟斤拷示没锟叫凤拷锟斤拷锟斤拷锟斤拷
Example #1 $mysqli->sqlstate 锟斤拷锟斤拷
锟斤拷锟斤拷锟斤拷锟斤拷锟�
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* 锟斤拷锟斤拷锟斤拷锟� */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* City 锟斤拷锟窖撅拷锟斤拷锟节ｏ拷锟斤拷锟斤拷锟斤拷锟角伙拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷 */
if (!$mysqli->query("CREATE TABLE City (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.\n", $mysqli->sqlstate);
}
$mysqli->close();
?>
锟斤拷锟教伙拷锟斤拷锟�
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* 锟斤拷锟斤拷锟斤拷锟� */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* City 锟斤拷锟窖撅拷锟斤拷锟节ｏ拷锟斤拷锟斤拷锟斤拷锟角伙拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷 */
if (!mysqli_query($link, "CREATE TABLE City (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.\n", mysqli_sqlstate($link));
}
mysqli_close($link);
?>
锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�
Error - SQLSTATE 42S01.