php man page for mysqli_multi_query

MYSQLI_MULTI_QUERY(3)							 1						     MYSQLI_MULTI_QUERY(3)

mysqli::multi_query - Performs a query on the database

       Object oriented style

SYNOPSIS
       bool mysqli::multi_query (string  $query)

DESCRIPTION
       Procedural style
       bool mysqli_multi_query (mysqli	$link, string  $query)

	Executes one or multiple queries which are concatenated by a semicolon.

	To  retrieve  the  resultset from the first query you can use mysqli_use_result(3) or mysqli_store_result(3). All subsequent query results
       can be processed using mysqli_more_results(3) and mysqli_next_result(3).

PARAMETERS
	      o $
		link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)

	      o $query
		- The query, as a string.  Data inside the query should be properly escaped.

RETURN VALUES
	Returns FALSE if the first statement failed. To retrieve subsequent errors from other statements you have  to  call  mysqli_next_result(3)
       first.

EXAMPLES
       Example #1

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

	      $query  = "SELECT CURRENT_USER();";
	      $query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";

	      /* execute multi query */
	      if ($mysqli->multi_query($query)) {
		  do {
		      /* store first result set */
		      if ($result = $mysqli->store_result()) {
			  while ($row = $result->fetch_row()) {
			      printf("%s
", $row[0]);
			  }
			  $result->free();
		      }
		      /* print divider */
		      if ($mysqli->more_results()) {
			  printf("-----------------
");
		      }
		  } while ($mysqli->next_result());
	      }

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

	      $query  = "SELECT CURRENT_USER();";
	      $query .= "SELECT Name FROM City ORDER BY ID LIMIT 20, 5";

	      /* execute multi query */
	      if (mysqli_multi_query($link, $query)) {
		  do {
		      /* store first result set */
		      if ($result = mysqli_store_result($link)) {
			  while ($row = mysqli_fetch_row($result)) {
			      printf("%s
", $row[0]);
			  }
			  mysqli_free_result($result);
		      }
		      /* print divider */
		      if (mysqli_more_results($link)) {
			  printf("-----------------
");
		      }
		  } while (mysqli_next_result($link));
	      }

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

	      The above examples will output something similar to:

	      my_user@localhost
	      -----------------
	      Amersfoort
	      Maastricht
	      Dordrecht
	      Leiden
	      Haarlemmermeer

SEE ALSO
       mysqli_query(3), mysqli_use_result(3), mysqli_store_result(3), mysqli_next_result(3), mysqli_more_results(3).

PHP Documentation Group 												     MYSQLI_MULTI_QUERY(3)