pg_send_query_params

pg_send_query_params

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

 **pg_send_query_params** PgSql\Connection $connection string $query array $params

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

This is equivalent to  except that query 
parameters can be specified separately from the 
 string. The function's parameters are 
handled identically to . Like 
, it will not work on pre-7.4 PostgreSQL 
connections, and it allows only one command in the query string. 

pg_send_query``query``pg_query_params``pg_query_params

connection``queryThe 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.

paramsAn 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.

Returns true on success, false or  on failure.  Use 
to determine the query result.

0``pg_get_result

**Voorbeeld: Using **

<?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}'");
?>

pg_send_query