maxdb_stmt_bind_result(3) [php man page]

MAXDB_STMT_BIND_RESULT(3)						 1						 MAXDB_STMT_BIND_RESULT(3)

maxdb_stmt_bind_result - Binds variables to a prepared statement for result storage

       Procedural style

SYNOPSIS

       bool maxdb_stmt_bind_result (resource  $stmt, mixed  &$var1, [mixed  &$...])

DESCRIPTION

       Object oriented style
       bool maxdb_stmt::bind_result (mixed  &$var1, [mixed  &$...])

       maxdb_stmt_bind_result(3)  is  used to associate (bind) columns in the result set to variables. When maxdb_stmt_fetch(3) is called to fetch
       data, the MaxDB client/server protocol places the data for the bound columns into the specified variables $var1, ....

       Note

	       Note that all columns must be bound prior to calling maxdb_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 maxdb_stmt_fetch(3) is called.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Object oriented style

	      <?php
	      $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

	      if (maxdb_connect_errno()) {
		 printf("Connect failed: %s
", maxdb_connect_error());
		 exit();
	      }

	      /* prepare statement */
	      if ($stmt = $maxdb->prepare("SELECT zip, name FROM hotel.city ORDER BY name")) {
		 $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 */
	      $maxdb->close();

	      ?>

       Example #2

	      Procedural style

	      <?php
	      $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

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

	      /* prepare statement */
	      if ($stmt = maxdb_prepare($link, "SELECT zip, name FROM hotel.city ORDER BY name")) {
		 maxdb_stmt_execute($stmt);

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

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

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

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

       The above example will output something similar to:

       12203 Albany
       60601 Chicago
       60615 Chicago
       45211 Cincinnati
       33575 Clearwater
       75243 Dallas
       32018 Daytona Beach
       33441 Deerfield Beach
       48226 Detroit
       90029 Hollywood
       92714 Irvine
       90804 Long Beach
       11788 Long Island
       90018 Los Angeles
       70112 New Orleans
       10019 New York
       10580 New York
       92262 Palm Springs
       97213 Portland
       60018 Rosemont
       95054 Santa Clara
       20903 Silver Spring
       20005 Washington
       20019 Washington
       20037 Washington

SEE ALSO

       maxdb_stmt_bind_param(3),  maxdb_stmt_execute(3),   maxdb_stmt_fetch(3),   maxdb_prepare(3),   maxdb_stmt_prepare(3),   maxdb_stmt_init(3),
       maxdb_stmt_errno(3), maxdb_stmt_error(3).

PHP Documentation Group 												 MAXDB_STMT_BIND_RESULT(3)

Check Out this Related 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)

Linux and UNIX Man Pages

maxdb_stmt_bind_result(3) [php man page]

Check Out this Related Man Page