pg_send_query(3) [php man page]

PG_SEND_QUERY(3)														  PG_SEND_QUERY(3)

pg_send_query - Sends asynchronous query

SYNOPSIS

       bool pg_send_query (resource  $connection, string  $query)

DESCRIPTION

       pg_send_query(3)  sends	a  query or queries asynchronously to the $connection. Unlike pg_query(3), it can send multiple queries at once to
       PostgreSQL and get the results one by one using pg_get_result(3).

	Script execution is not blocked while the queries are executing. Use pg_connection_busy(3) to check if the connection is  busy	(i.e.  the
       query is executing). Queries may be cancelled using pg_cancel_query(3).

	Although  the user can send multiple queries at once, multiple queries cannot be sent over a busy connection. If a query is sent while the
       connection is busy, it waits until the last query is finished and discards all its results.

PARAMETERS

	      o $connection
		- PostgreSQL database connection resource.

	      o $query
		- The SQL statement or statements to be executed.  Data inside the query should be properly escaped.

RETURN VALUES

       Returns TRUE on success or FALSE on failure.

	Use pg_get_result(3) to determine the query result.

EXAMPLES

       Example #1

	      pg_send_query(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_query(3), pg_cancel_query(3), pg_get_result(3), pg_connection_busy(3).

PHP Documentation Group 													  PG_SEND_QUERY(3)

PG_QUERY_PARAMS(3)														PG_QUERY_PARAMS(3)

pg_query_params  -  Submits  a command to the server and waits for the result, with the ability to pass parameters separately from the SQL command
text.

SYNOPSIS

       resource pg_query_params ([resource  $connection], string  $query, array  $params)

DESCRIPTION

	Submits a command to the server and waits for the result, with the ability to pass parameters separately from the SQL command text.

       pg_query_params(3) is like pg_query(3), but offers additional functionality: parameter values can be specified separately from the  command
       string proper. pg_query_params(3) is supported only against PostgreSQL 7.4 or higher connections; it will fail when using earlier versions.

	If  parameters	are  used,  they  are referred to in the $query string as $1, $2, etc. The same parameter may appear more than once in the
       $query; the same value will be used in that case. $params specifies the actual values of the parameters. A NULL value in this  array  means
       the corresponding parameter is SQL NULL.

	The primary advantage of pg_query_params(3) over pg_query(3) is that parameter values may be separated from the $query string, thus avoid-
       ing the need for tedious and error-prone quoting and escaping. Unlike pg_query(3), pg_query_params(3) allows at most one SQL command in the
       given string. (There can be semicolons in it, but not more than one nonempty command.)

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 $query
		- The parameterized SQL statement. Must contain only a single statement. (multiple statements separated  by  semi-colons  are  not
		allowed.) If any parameters are used, they are referred to as $1, $2, etc.  User-supplied values should always be passed as param-
		eters, not interpolated into the query string, where they form possible  SQL injection attack vectors and introduce bugs when han-
		dling data containing quotes. If for some reason you cannot use a parameter, ensure that interpolated values are properly escaped.

	      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.  Values intended for bytea fields are not supported as parameters.
		Use pg_escape_bytea(3) instead, or use the large object functions.

RETURN VALUES

	A query result resource on success or FALSE on failure.

EXAMPLES

       Example #1

	      Using pg_query_params(3)

	      <?php
	      // Connect to a database named "mary"
	      $dbconn = pg_connect("dbname=mary");

	      // Find all shops named Joe's Widgets.  Note that it is not necessary to
	      // escape "Joe's Widgets"
	      $result = pg_query_params($dbconn, 'SELECT * FROM shops WHERE name = $1', array("Joe's Widgets"));

	      // Compare against just using pg_query
	      $str = pg_escape_string("Joe's Widgets");
	      $result = pg_query($dbconn, "SELECT * FROM shops WHERE name = '{$str}'");

	      ?>

SEE ALSO

       pg_query(3).

PHP Documentation Group 													PG_QUERY_PARAMS(3)