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_FETCH_LENGTHS(3) 						 1						   MYSQLI_FETCH_LENGTHS(3)

mysqli_result::$lengths - Returns the lengths of the columns of the current row in the result set

       Object oriented style

SYNOPSIS

       array$mysqli_result->lengths ()

DESCRIPTION

       Procedural style
       array mysqli_fetch_lengths (mysqli_result  $result)

	The mysqli_fetch_lengths(3) function returns an array containing the lengths of every column of the current row within the result set.

PARAMETERS

	      o $
		result	 -Procedural   style   only:   A   result   set   identifier   returned   by  mysqli_query(3),	mysqli_store_result(3)	or
		mysqli_use_result(3).

RETURN VALUES

	An array of integers representing the size of each column (not including any terminating null characters).  FALSE if an error occurred.

       mysqli_fetch_lengths(3) is valid only for  the  current	row  of  the  result  set.  It	returns  FALSE	if  you  call  it  before  calling
       mysqli_fetch_row/array/object or after retrieving all rows in the result.

EXAMPLES

       Example #1

	      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();
	      }

	      $query = "SELECT * from Country ORDER BY Code LIMIT 1";

	      if ($result = $mysqli->query($query)) {

		  $row = $result->fetch_row();

		  /* display column lengths */
		  foreach ($result->lengths as $i => $val) {
		      printf("Field %2d has Length %2d
", $i+1, $val);
		  }
		  $result->close();
	      }

	      /* close connection */
	      $mysqli->close();
	      ?>

       Example #2

	      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();
	      }

	      $query = "SELECT * from Country ORDER BY Code LIMIT 1";

	      if ($result = mysqli_query($link, $query)) {

		  $row = mysqli_fetch_row($result);

		  /* display column lengths */
		  foreach (mysqli_fetch_lengths($result) as $i => $val) {
		      printf("Field %2d has Length %2d
", $i+1, $val);
		  }
		  mysqli_free_result($result);
	      }

	      /* close connection */
	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      Field  1 has Length  3
	      Field  2 has Length  5
	      Field  3 has Length 13
	      Field  4 has Length  9
	      Field  5 has Length  6
	      Field  6 has Length  1
	      Field  7 has Length  6
	      Field  8 has Length  4
	      Field  9 has Length  6
	      Field 10 has Length  6
	      Field 11 has Length  5
	      Field 12 has Length 44
	      Field 13 has Length  7
	      Field 14 has Length  3
	      Field 15 has Length  2

PHP Documentation Group 												   MYSQLI_FETCH_LENGTHS(3)