# maxdb_warning_count

# maxdb->warning_count

(PECL maxdb:1.0-7.6.00.38)

maxdb->warning_count — Returns the number of warnings from the last query for the given link

### Description

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.

### Return Values

Number of warnings or zero if there are no warnings.

### Examples

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

Example#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);
?>`

The above examples would produce the following output:

    Warning: maxdb_query(): -8004 POS(62) Constant must be compatible with column type and length <...>
    Number of warning: 0

### See Also

- maxdb_errno()
- maxdb_error()
- maxdb_sqlstate()