pg_get_result(3) [php man page]

PG_GET_RESULT(3)														  PG_GET_RESULT(3)

pg_get_result - Get asynchronous query result

SYNOPSIS

       resource pg_get_result ([resource  $connection])

DESCRIPTION

       pg_get_result(3)  gets the result resource from an asynchronous query executed by pg_send_query(3), pg_send_query_params(3) or pg_send_exe-
       cute(3).

       pg_send_query(3) and the other asynchronous query functions can send multiple queries to a PostgreSQL server and pg_get_result(3)  is  used
       to get each query's results, one by one.

PARAMETERS

	      o $connection
		- PostgreSQL database connection resource.

RETURN VALUES

	The result resource, or FALSE if no more results are available.

EXAMPLES

       Example #1

	      pg_get_result(3) example

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		if (!pg_connection_busy($dbconn)) {
		    pg_send_query($dbconn, "select * from authors; select count(*) from authors;");
		}

		$res1 = pg_get_result($dbconn);
		echo "First call to pg_get_result(): $res1
";
		$rows1 = pg_num_rows($res1);
		echo "$res1 has $rows1 records

";

		$res2 = pg_get_result($dbconn);
		echo "Second call to pg_get_result(): $res2
";
		$rows2 = pg_num_rows($res2);
		echo "$res2 has $rows2 records
";
	      ?>

	      The above example will output:

	      First call to pg_get_result(): Resource id #3
	      Resource id #3 has 3 records

	      Second call to pg_get_result(): Resource id #4
	      Resource id #4 has 1 records

SEE ALSO

       pg_send_query(3).

PHP Documentation Group 													  PG_GET_RESULT(3)

PG_SEND_EXECUTE(3)														PG_SEND_EXECUTE(3)

pg_send_execute - Sends a request to execute a prepared statement with given parameters, without waiting for the result(s).

SYNOPSIS

       bool pg_send_execute (resource  $connection, string  $stmtname, array  $params)

DESCRIPTION

	Sends a request to execute a prepared statement with given parameters, without waiting for the result(s).

	This is similar to pg_send_query_params(3), but the command to be executed is specified by naming a previously-prepared statement, instead
       of giving a query string. The function's parameters are handled identically to pg_execute(3). Like  pg_execute(3),  it  will  not  work	on
       pre-7.4 versions of PostgreSQL.

PARAMETERS

	      o $connection
		- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
		is the last connection made by pg_connect(3) or pg_pconnect(3).

	      o $stmtname
		- The name of the prepared statement to execute. if "" is specified, then the unnamed statement is executed. The  name	must  have
		been previously prepared using pg_prepare(3), pg_send_prepare(3) or a PREPARE SQL command.

	      o $params
		-  An  array of parameter values to substitute for the $1, $2, etc. placeholders in the original prepared query string. The number
		of elements in the array must match the number of placeholders.

RETURN VALUES

       Returns TRUE on success, FALSE on failure. Use pg_get_result(3) to determine the query result.

EXAMPLES

       Example #1

	      Using pg_send_execute(3)

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		// Prepare a query for execution
		if (!pg_connection_busy($dbconn)) {
		  pg_send_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1');
		  $res1 = pg_get_result($dbconn);
		}

		// Execute the prepared query.	Note that it is not necessary to escape
		// the string "Joe's Widgets" in any way
		if (!pg_connection_busy($dbconn)) {
		  pg_send_execute($dbconn, "my_query", array("Joe's Widgets"));
		  $res2 = pg_get_result($dbconn);
		}

		// Execute the same prepared query, this time with a different parameter
		if (!pg_connection_busy($dbconn)) {
		  pg_send_execute($dbconn, "my_query", array("Clothes Clothes Clothes"));
		  $res3 = pg_get_result($dbconn);
		}

	      ?>

SEE ALSO

       pg_prepare(3), pg_send_prepare(3), pg_execute(3).

PHP Documentation Group 													PG_SEND_EXECUTE(3)