IT. Expert System.

PHP

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


pg_send_query_params

(PHP 5 >= 5.1.0)

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

Description

bool pg_send_query_params ( resource $connection , string $query , array $params )

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

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

Parameters

connection

PostgreSQL database connection resource.

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.

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() to determine the query result.

Examples

Example #1 Using pg_send_query_params()

<?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



Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 65 / 159266385. Delta: 0.04739 с