pq\Statement pq\Connection::prepare(string $name, string $query[, array $types = NULL])

Prepare a named statement for later execution with pq\Statement::execute().

Params:

Returns:

Throws:

Example:


<?php

$connection 
= new pq\Connection;

$statement $connection->prepare(
    
"example"
    
"SELECT a from generate_series(1,9) a WHERE a > \$1"
    [
pq\Types::INT4]);
$result $statement->exec([5]);

var_dump($result->fetchAllCols(0));

?>

Yields:


array(4) {
  [0]=>
  int(6)
  [1]=>
  int(7)
  [2]=>
  int(8)
  [3]=>
  int(9)
}