mysqli_stmt_reset(3) [php man page]

MYSQLI_STMT_RESET(3)							 1						      MYSQLI_STMT_RESET(3)

mysqli_stmt::reset - Resets a prepared statement

       Object oriented style

SYNOPSIS

       bool mysqli_stmt::reset (void  )

DESCRIPTION

       Procedural style
       bool mysqli_stmt_reset (mysqli_stmt  $stmt)

	Resets a prepared statement on client and server to state after prepare.

	It  resets  the statement on the server, data sent using mysqli_stmt_send_long_data(3), unbuffered result sets and current errors. It does
       not clear bindings or stored result sets. Stored result sets will be cleared when executing the prepared statement (or closing it).

	To prepare a statement with another query use function mysqli_stmt_prepare(3).

PARAMETERS

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

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

SEE ALSO

       mysqli_prepare(3).

PHP Documentation Group 												      MYSQLI_STMT_RESET(3)

MYSQLI_STMT_GET_RESULT(3)						 1						 MYSQLI_STMT_GET_RESULT(3)

mysqli_stmt::get_result - Gets a result set from a prepared statement

       Object oriented style

SYNOPSIS

       mysqli_result mysqli_stmt::get_result (void  )

DESCRIPTION

       Procedural style
       mysqli_result mysqli_stmt_get_result (mysqli_stmt  $stmt)

	Call to return a result set from a prepared statement query.

PARAMETERS

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

RETURN VALUES

	Returns a resultset or FALSE on failure.

MYSQL NATIVE DRIVER ONLY

	Available only with mysqlnd.

EXAMPLES

       Example #1

	      Object oriented style

	      <?php

	      $mysqli = new mysqli("127.0.0.1", "user", "password", "world");

	      if($mysqli->connect_error)
	      {
		  die("$mysqli->connect_errno: $mysqli->connect_error");
	      }

	      $query = "SELECT Name, Population, Continent FROM Country WHERE Continent=? ORDER BY Name LIMIT 1";

	      $stmt = $mysqli->stmt_init();
	      if(!$stmt->prepare($query))
	      {
		  print "Failed to prepare statement
";
	      }
	      else
	      {
		  $stmt->bind_param("s", $continent);

		  $continent_array = array('Europe','Africa','Asia','North America');

		  foreach($continent_array as $continent)
		  {
		      $stmt->execute();
		      $result = $stmt->get_result();
		      while ($row = $result->fetch_array(MYSQLI_NUM))
		      {
			  foreach ($row as $r)
			  {
			      print "$r ";
			  }
			  print "
";
		      }
		  }
	      }

	      $stmt->close();
	      $mysqli->close();
	      ?>

       Example #2

	      Procedural style

	      <?php

	      $link = mysqli_connect("127.0.0.1", "user", "password", "world");

	      if (!$link)
	      {
		  $error = mysqli_connect_error();
		  $errno = mysqli_connect_errno();
		  print "$errno: $error
";
		  exit();
	      }

	      $query = "SELECT Name, Population, Continent FROM Country WHERE Continent=? ORDER BY Name LIMIT 1";

	      $stmt = mysqli_stmt_init($link);
	      if(!mysqli_stmt_prepare($stmt, $query))
	      {
		  print "Failed to prepare statement
";
	      }
	      else
	      {
		  mysqli_stmt_bind_param($stmt, "s", $continent);

		  $continent_array = array('Europe','Africa','Asia','North America');

		  foreach($continent_array as $continent)
		  {
		      mysqli_stmt_execute($stmt);
		      $result = mysqli_stmt_get_result($stmt);
		      while ($row = mysqli_fetch_array($result, MYSQLI_NUM))
		      {
			  foreach ($row as $r)
			  {
			      print "$r ";
			  }
			  print "
";
		      }
		  }
	      }
	      mysqli_stmt_close($stmt);
	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      Albania 3401200 Europe
	      Algeria 31471000 Africa
	      Afghanistan 22720000 Asia
	      Anguilla 8000 North America

SEE ALSO

       mysqli_prepare(3), mysqli_stmt_result_metadata(3), mysqli_stmt_fetch(3), mysqli_fetch_array(3), mysqli_stmt_store_result(3).

PHP Documentation Group 												 MYSQLI_STMT_GET_RESULT(3)