PDF(美国高级主任)- 2.4 mb
PDF (A4)- 2.4 mb
mysqli_stmt: errno美元
mysqli_stmt_errno
返回最近语句调用的错误代码
描述
面向对象的风格
intmysqli_stmt - > errno;
程序上的风格
intmysqli_stmt_errno(mysqli_stmt声明);
返回最近调用的语句函数的错误代码,该语句函数可能成功,也可能失败。
参数
-
声明
-
程序风格:A
mysqli_stmt
返回的对象mysqli_stmt_init
.
返回值
错误码值。零表示没有发生错误。
例子
例3.77面向对象风格
<?php /*打开一个连接*/ $mysqli = new mysqli("localhost", "my_user", "my_password", "world");/*检查连接*/ if (mysqli_connect_errno()) {printf("Connect failed: %s\n", mysqli_connect_error());退出();} $mysqli->查询("CREATE TABLE myCountry LIKE Country");$mysqli->查询(“插入到我的国家SELECT *从国家”);$query = "SELECT Name, Code FROM myCountry ORDER BY Name";if ($stmt = $mysqli->prepare($query)) {/* drop table */ $mysqli->query(" drop table myCountry");/* execute query */ $stmt->execute();printf("错误:% d。\n", $stmt->errno); /* close statement */ $stmt->close(); } /* close connection */ $mysqli->close(); ?>
例3.78过程式风格
<?php /*打开一个连接*/ $link = mysqli_connect("localhost", "my_user", "my_password", "world");/*检查连接*/ if (mysqli_connect_errno()) {printf("Connect failed: %s\n", mysqli_connect_error());退出();} mysqli_query($link, "CREATE TABLE myCountry LIKE Country");mysqli_query($link, "INSERT INTO myCountry SELECT * FROM Country");$query = "SELECT Name, Code FROM myCountry ORDER BY Name";if ($stmt = mysqli_prepare($link, $query)) {/* drop table */ mysqli_query($link, " drop table myCountry");/ / mysqli_stmt_execute($stmt);printf("错误:% d。\n", mysqli_stmt_errno($stmt)); /* close statement */ mysqli_stmt_close($stmt); } /* close connection */ mysqli_close($link); ?>
上面的例子将输出:
错误:1146。
另请参阅
mysqli_stmt_error |
mysqli_stmt_sqlstate |