mysqli_stmt_bind_result(3) [php man page]

MYSQLI_STMT_BIND_RESULT(3)						 1						MYSQLI_STMT_BIND_RESULT(3)

mysqli_stmt::bind_result - Binds variables to a prepared statement for result storage

       Object oriented style

SYNOPSIS

       bool mysqli_stmt::bind_result (mixed  &$var1, [mixed  &$...])

DESCRIPTION

       Procedural style
       bool mysqli_stmt_bind_result (mysqli_stmt  $stmt, mixed	&$var1, [mixed	&$...])

	Binds columns in the result set to variables.

	When  mysqli_stmt_fetch(3) is called to fetch data, the MySQL client/server protocol places the data for the bound columns into the speci-
       fied variables $var1, ....

       Note

	       Note that all columns must be bound after mysqli_stmt_execute(3) and prior to calling  mysqli_stmt_fetch(3).  Depending	on  column
	      types bound variables can silently change to the corresponding PHP type.

	       A  column  can  be bound or rebound at any time, even after a result set has been partially retrieved. The new binding takes effect
	      the next time mysqli_stmt_fetch(3) is called.

PARAMETERS

	      o $
		stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).

	      o $var1
		- The variable to be bound.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Object oriented style

	      <?php
	      $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      /* prepare statement */
	      if ($stmt = $mysqli->prepare("SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")) {
		  $stmt->execute();

		  /* bind variables to prepared statement */
		  $stmt->bind_result($col1, $col2);

		  /* fetch values */
		  while ($stmt->fetch()) {
		      printf("%s %s
", $col1, $col2);
		  }

		  /* close statement */
		  $stmt->close();
	      }
	      /* close connection */
	      $mysqli->close();

	      ?>

       Example #2

	      Procedural style

	      <?php
	      $link = mysqli_connect("localhost", "my_user", "my_password", "world");

	      /* check connection */
	      if (!$link) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      /* prepare statement */
	      if ($stmt = mysqli_prepare($link, "SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")) {
		  mysqli_stmt_execute($stmt);

		  /* bind variables to prepared statement */
		  mysqli_stmt_bind_result($stmt, $col1, $col2);

		  /* fetch values */
		  while (mysqli_stmt_fetch($stmt)) {
		      printf("%s %s
", $col1, $col2);
		  }

		  /* close statement */
		  mysqli_stmt_close($stmt);
	      }

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

	      The above examples will output:

	      AFG Afghanistan
	      ALB Albania
	      DZA Algeria
	      ASM American Samoa
	      AND Andorra

SEE ALSO

       mysqli_stmt_get_result(3), mysqli_stmt_bind_param(3),  mysqli_stmt_execute(3),  mysqli_stmt_fetch(3),  mysqli_prepare(3),  mysqli_stmt_pre-
       pare(3), mysqli_stmt_init(3), mysqli_stmt_errno(3), mysqli_stmt_error(3).

PHP Documentation Group 												MYSQLI_STMT_BIND_RESULT(3)

Check Out this Related Man Page

MYSQLI_STMT_DATA_SEEK(3)						 1						  MYSQLI_STMT_DATA_SEEK(3)

mysqli_stmt::data_seek - Seeks to an arbitrary row in statement result set

       Object oriented style

SYNOPSIS

       void mysqli_stmt::data_seek (int  $offset)

DESCRIPTION

       Procedural style
       void mysqli_stmt_data_seek (mysqli_stmt	$stmt, int  $offset)

	Seeks to an arbitrary result pointer in the statement result set.

       mysqli_stmt_store_result(3) must be called prior to mysqli_stmt_data_seek(3).

PARAMETERS

	      o $
		stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).

	      o $offset
		- Must be between zero and the total number of rows minus one (0.. mysqli_stmt_num_rows(3) - 1).

RETURN VALUES

	No value is returned.

EXAMPLES

       Example #1

	      Object oriented style

	      <?php
	      /* Open a connection */
	      $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 Name, CountryCode FROM City ORDER BY Name";
	      if ($stmt = $mysqli->prepare($query)) {

		  /* execute query */
		  $stmt->execute();

		  /* bind result variables */
		  $stmt->bind_result($name, $code);

		  /* store result */
		  $stmt->store_result();

		  /* seek to row no. 400 */
		  $stmt->data_seek(399);

		  /* fetch values */
		  $stmt->fetch();

		  printf ("City: %s  Countrycode: %s
", $name, $code);

		  /* close statement */
		  $stmt->close();
	      }

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

       Example #2

	      Procedural style

	      <?php
	      /* Open a connection */
	      $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 Name, CountryCode FROM City ORDER BY Name";
	      if ($stmt = mysqli_prepare($link, $query)) {

		  /* execute query */
		  mysqli_stmt_execute($stmt);

		  /* bind result variables */
		  mysqli_stmt_bind_result($stmt, $name, $code);

		  /* store result */
		  mysqli_stmt_store_result($stmt);

		  /* seek to row no. 400 */
		  mysqli_stmt_data_seek($stmt, 399);

		  /* fetch values */
		  mysqli_stmt_fetch($stmt);

		  printf ("City: %s  Countrycode: %s
", $name, $code);

		  /* close statement */
		  mysqli_stmt_close($stmt);
	      }

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

	      The above examples will output:

	      City: Benin City	Countrycode: NGA

SEE ALSO

       mysqli_prepare(3).

PHP Documentation Group 												  MYSQLI_STMT_DATA_SEEK(3)

Linux and UNIX Man Pages

mysqli_stmt_bind_result(3) [php man page]

Check Out this Related Man Page