Werbung
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:
int maxdb_warning_count
( resource $link
)
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
PHP Code
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14
$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();
PHP Code
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14
$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 erzeugt eine ä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