©
本文档使用
php.cn手册 发布
(PHP 5)
mysqli::$warning_count -- mysqli_warning_count — Returns the number of warnings from the last query for the given link
面向对象风格
过程化风格
$link
)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" );
if ( mysqli_connect_errno ()) {
printf ( "Connect failed: %s\n" , mysqli_connect_error ());
exit();
}
$mysqli -> query ( "CREATE TABLE myCity LIKE City" );
$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 ();
}
}
$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();
}
mysqli_query ( $link , "CREATE TABLE myCity LIKE City" );
$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 );
}
}
mysqli_close ( $link );
?>
以上例程会输出:
Warning (1264): Data truncated for column 'Name' at row 1