php man page for pg_send_query_params

Query: pg_send_query_params

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

PG_SEND_QUERY_PARAMS(3) 												   PG_SEND_QUERY_PARAMS(3)

pg_send_query_params - Submits a command and separate parameters to the server without waiting for the result(s).

SYNOPSIS
bool pg_send_query_params (resource $connection, string $query, array $params)
DESCRIPTION
Submits a command and separate parameters to the server without waiting for the result(s). This is equivalent to pg_send_query(3) except that query parameters can be specified separately from the $query string. The function's parameters are handled identically to pg_query_params(3). Like pg_query_params(3), it will not work on pre-7.4 PostgreSQL connections, and it allows only one command in the query string.
PARAMETERS
o $connection - PostgreSQL database connection resource. 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. 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 or FALSE on failure. Use pg_get_result(3) to determine the query result.
EXAMPLES
Example #1 Using pg_send_query_params(3) <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); // Using parameters. Note that it is not necessary to quote or escape // the parameter. pg_send_query_params($dbconn, 'select count(*) from authors where city = $1', array('Perth')); // Compare against basic pg_send_query usage $str = pg_escape_string('Perth'); pg_send_query($dbconn, "select count(*) from authors where city = '${str}'"); ?>
SEE ALSO
pg_send_query(3). PHP Documentation Group PG_SEND_QUERY_PARAMS(3)
Related Man Pages
pg_convert(3) - php
pg_prepare(3) - php
pg_parameter_status(3) - php
pg_query(3) - php
pg_set_error_verbosity(3) - php
Similar Topics in the Unix Linux Community
city wide connection
How to substitute brackets in the beginning of string in perl?
How to put db2 query result into an array in shell script?
Finding a string and displaying the text before?
Passing parameters and accepting in Array