Hear Howard DeYoung- Director of Information Technology for City of St. Cloud describe the experience of innovating cyberspots in his city with the HPBladeSystem solutions
A Tribute to India
For our Indian members, please let us know in the poll what city you live (or work)?
Mumbai (Bombay)
Delhi
Kolkata (Calcutta)
Chennai (Madras)
Bangalore
Hyderabad
Pune
Ahmedabad
Kanpur
Surat
Other (Please Tell Us in Post and Write in Poll, Thanks!)
Don't Live in... (32 Replies)
Tim Bass
Thu, 15 Nov 2007 23:55:07 +0000
*I predict we may experience less*debates*on the use of the term “event cloud”*related to*CEP in the future, now that both IBM and Google* have made announcements about “cloud computing” and “computing cloud”, IBM Turning Data Centers Into ‘Computing... (0 Replies)
MYSQLI_WARNING_COUNT(3) 1 MYSQLI_WARNING_COUNT(3)mysqli::$warning_count - Returns the number of warnings from the last query for the given link
Object oriented style
SYNOPSIS
int$mysqli->warning_count ()
DESCRIPTION
Procedural style
int 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
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)RETURN VALUES
Number of warnings or zero if there are no warnings.
EXAMPLES
Example #1
$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
", 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
", $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
", 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
", $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(3), mysqli_error(3), mysqli_sqlstate(3).
PHP Documentation Group MYSQLI_WARNING_COUNT(3)