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 informix 函数 returns the number of columns in the queryphp maxdb 函数 returns the error code from last connect callphp maxdb 函数 returns the number of parameter for the given statementphp maxdb 函数 returns the number of warnings from the last query for the given linkphp mssql 函数 returns the last message from the serverphp oci8 函数 returns the next row from a query as an associative or numeric arrayphp sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executedphp tidy 函数 returns the number of tidy accessibility warnings encountered for specified documentphp yaz 函数 returns number of hits for last searchphp mysql xdevapi result 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 number of warnings from the last query for the given linkphp solrquery returns the maximum number of query terms that will be included in any generated query
关注编程学问公众号