pg_send_execute(3) [php man page]

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)

Check Out this Related Man Page

PG_SET_ERROR_VERBOSITY(3)												 PG_SET_ERROR_VERBOSITY(3)

pg_set_error_verbosity - Determines the verbosity of messages returned bypg_last_error(3)andpg_result_error(3).

SYNOPSIS

       int pg_set_error_verbosity ([resource  $connection], int  $verbosity)

DESCRIPTION

	Determines the verbosity of messages returned by pg_last_error(3) and pg_result_error(3).

       pg_set_error_verbosity(3)  sets	the verbosity mode, returning the connection's previous setting. In PGSQL_ERRORS_TERSE mode, returned mes-
       sages include severity, primary text, and position only; this will normally fit on a single line. The default mode (  PGSQL_ERRORS_DEFAULT)
       produces messages that include the above plus any detail, hint, or context fields (these may span multiple lines). The PGSQL_ERRORS_VERBOSE
       mode includes all available fields. Changing the verbosity does not affect the messages available  from	already-existing  result  objects,
       only subsequently-created ones.

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 $verbosity
		- The required verbosity: PGSQL_ERRORS_TERSE, PGSQL_ERRORS_DEFAULT or PGSQL_ERRORS_VERBOSE.

RETURN VALUES

	The previous verbosity level: PGSQL_ERRORS_TERSE, PGSQL_ERRORS_DEFAULT or PGSQL_ERRORS_VERBOSE.

EXAMPLES

       Example #1

	      pg_set_error_verbosity(3) example

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

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

		pg_set_error_verbosity($dbconn, PGSQL_ERRORS_VERBOSE);
		$res1 = pg_get_result($dbconn);
		echo pg_result_error($res1);
	      ?>

SEE ALSO

       pg_last_error(3), pg_result_error(3).

PHP Documentation Group 												 PG_SET_ERROR_VERBOSITY(3)

Linux and UNIX Man Pages

pg_send_execute(3) [php man page]

Check Out this Related Man Page