mysqli::$warning_count, mysqli_warning_count

• mysqli::$warning_count

  mysqli_warning_count

  Returns the number of warnings from the last query for the given link

Description

Object oriented styleint mysqli->warning_count ;

Procedural styleint mysqli_warning_count(mysqli 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].

Parameters

link

Procedural style only: A link identifier returned by mysqli_connect or mysqli_init

Return Values

Number of warnings or zero if there are no warnings.

Examples

Example 20.141. $mysqli->warning_count example

Object oriented style

<?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();
?>

Procedural style

<?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);
?>

The above examples will output:

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

See Also

mysqli_errno

mysqli_error

mysqli_sqlstate

Retornar