php man page for mysqli_warning_count

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)