mysqli_poll(3) [php man page]

MYSQLI_POLL(3)								 1							    MYSQLI_POLL(3)

mysqli::poll - Poll connections

       Object oriented style

SYNOPSIS

       publicstatic int mysqli::poll (array  &$read, array  &$error, array  &$reject, int  $sec, [int  $usec])

DESCRIPTION

       Procedural style
       int mysqli_poll (array  &$read, array  &$error, array  &$reject, int  $sec, [int  $usec])

	Poll connections. Available only with mysqlnd. The method can be used as static.

PARAMETERS

	      o $read
		- List of connections to check for outstanding results that can be read.

	      o $error
		- List of connections on which an error occured, for example, query failure or lost connection.

	      o $reject
		- List of connections rejected because no asynchronous query has been run on for which the function could poll results.

	      o $sec
		- Number of seconds to wait, must be non-negative.

	      o $usec
		- Number of microseconds to wait, must be non-negative.

RETURN VALUES

	Returns number of ready connections upon success, FALSE otherwise.

EXAMPLES

       Example #1

	      A mysqli_poll(3) example

	      <?php
	      $link1 = mysqli_connect();
	      $link1->query("SELECT 'test'", MYSQLI_ASYNC);
	      $all_links = array($link1);
	      $processed = 0;
	      do {
		  $links = $errors = $reject = array();
		  foreach ($all_links as $link) {
		      $links[] = $errors[] = $reject[] = $link;
		  }
		  if (!mysqli_poll($links, $errors, $reject, 1)) {
		      continue;
		  }
		  foreach ($links as $link) {
		      if ($result = $link->reap_async_query()) {
			  print_r($result->fetch_row());
			  if (is_object($result))
			      mysqli_free_result($result);
		      } else die(sprintf("MySQLi Error: %s", mysqli_error($link)));
		      $processed++;
		  }
	      } while ($processed < count($all_links));
	      ?>

	      The above example will output:

	      Array
	      (
		  [0] => test
	      )

SEE ALSO

       mysqli_query(3), mysqli_reap_async_query(3).

PHP Documentation Group 													    MYSQLI_POLL(3)

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)