PHP Dokumentation: Function maxdb-warning-count
12. Januar 2010 von werner
maxdb_warning_count
maxdb->warning_count
(PECL maxdb >= 1.0)
maxdb_warning_count — maxdb->warning_count — Returns the number of warnings from the last query for the given link
Beschreibung
Procedural style:
Object oriented style (property):
maxdb
int $warning_count;
maxdb_warning_count() returns the number of warnings from the last query in the connection represented by the link parameter.
Rückgabewerte
Number of warnings or zero if there are no warnings.
Beispiele
Beispiel #1 Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s\n", maxdb_connect_error());
exit();
}$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");/* a remarkable city in Wales */
$query = "INSERT INTO temp.mycity (zip, name) VALUES('11111',
'Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch')";$maxdb->query($query);printf ("Number of warning: %d\n", $maxdb->warning_count);/* close connection */
$maxdb->close();
?>Beispiel #2 Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s\n", maxdb_connect_error());
exit();
}maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");/* a remarkable long city name in Wales */
$query = "INSERT INTO temp.mycity (zip, name) VALUES('11111',
'Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch')";maxdb_query($link, $query);printf ("Number of warning: %d\n", maxdb_warning_count($link));/* close connection */
maxdb_close($link);
?>Das oben gezeigte Beispiel erzeugteine ähnliche Ausgabe wie:
Warning: maxdb_query(): -8004 POS(62) Constant must be compatible with column type and length <...>Number of warning: 0
Siehe auch
- maxdb_errno() – Returns the error code for the most recent function call
- maxdb_error() – Returns a string description of the last error
- maxdb_sqlstate() – Returns the SQLSTATE error from previous MaxDB operation
Loading ...