mysqli::$warning_count

mysqli_warning_count

(PHP 5, PHP 7)

mysqli::$warning_count -- mysqli_warning_count — Returns the number of warnings from the last query for the given link

说明

面向对象风格

int $mysqli->warning_count;

过程化风格

mysqli_warning_count ( mysqli $link ) : int

Returns the number of warnings from the last query in the connection.

Note:

For retrieving warning messages you can use the SQL command SHOW WARNINGS [limit row_count].

参数

link

仅以过程化样式：由mysqli_connect() 或 mysqli_init() 返回的链接标识。

返回值

Number of warnings or zero if there are no warnings.

范例

Example #1 $mysqli->warning_count example

面向对象风格

<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$mysqli->query("CREATE TABLE myCity LIKE City");

/* a remarkable city in Wales */
$query = "INSERT INTO myCity (CountryCode, Name) VALUES('GBR',
        'Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch')";

$mysqli->query($query);

if ($mysqli->warning_count) {
    if ($result = $mysqli->query("SHOW WARNINGS")) {
        $row = $result->fetch_row();
        printf("%s (%d): %s\n", $row[0], $row[1], $row[2]);
        $result->close();
    }
}

/* close connection */
$mysqli->close();
?>

过程化风格

<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

mysqli_query($link, "CREATE TABLE myCity LIKE City");

/* a remarkable long city name in Wales */
$query = "INSERT INTO myCity (CountryCode, Name) VALUES('GBR',
        'Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch')";

mysqli_query($link, $query);

if (mysqli_warning_count($link)) {
    if ($result = mysqli_query($link, "SHOW WARNINGS")) {
        $row = mysqli_fetch_row($result);
        printf("%s (%d): %s\n", $row[0], $row[1], $row[2]);
        mysqli_free_result($result);
    }
}

/* close connection */
mysqli_close($link);
?>

以上例程会输出：

Warning (1264): Data truncated for column 'Name' at row 1

参见

相关文章
php ibm db2 函数 returns the auto generated id of the last insert query that successfully executed on this connectionphp maxdb 函数 transfers a result set from the last queryphp maxdb 函数 returns the number of warnings from the last query for the given linkphp sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executedphp svn 函数 returns a stream to access the contents of a file from a given version of the fsphp svn 函数 returns the length of a file from a given version of the fsphp sybase 函数 returns the last message from the serverphp mysql xdevapi rowresult get warnings from last operationphp mysqli stmt returns the total number of rows changed deleted or inserted by the last executed statementphp mysqli stmt returns a list of errors from the last statement executedphp mysqli stmt returns the number of field in the given statementphp mysqli stmt returns the number of parameter for the given statementphp mysqli returns the error code from last connect callphp mysqli returns a list of errors from the last command executedphp mysqli returns the number of columns for the most recent queryphp mysqli returns the number of warnings from the last query for the given linkphp mysqlnduhconnection returns the auto generated id used in the last queryphp mysqlnduhconnection returns the number of warnings from the last query for the given linkphp sdo das relational 函数 executes a given sql query against a relational database and returns the results as a normalised data graphphp soapclient returns the soap headers from the last request
关注编程学问公众号