10bet网址
MySQL PHP API
下载本手册

MySQL PHP API/.../ mysqli_stmt:: $ errno, mysqli_stmt_errno

3.9.9mysqli_stmt: errno美元mysqli_stmt_errno

PHP文档组版权所有。10bet官方网站

  • mysqli_stmt: errno美元

    mysqli_stmt_errno

    返回最近语句调用的错误代码

描述

面向对象的风格

intmysqli_stmt - > errno

程序上的风格

intmysqli_stmt_errnomysqli_stmt声明);

返回最近调用的语句函数的错误代码,该语句函数可能成功,也可能失败。

参数

声明

程序风格:Amysqli_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