pg_send_execute

Sends a request to execute a prepared statement with given parameters, without waiting for the result(s). (PHP 5 >= 5.1.0)
bool pg_send_execute ( resource connection, string stmtname, array params )

Example 1972. Using pg_send_execute()

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

  }

  
?>

pg_send_execute

Sends a request to execute a prepared statement with given parameters, without waiting for the result(s). (PHP 5 >= 5.1.0) bool pg_send_execute ( resource connection, string stmtname, array params )

Example 1972. Using pg_send_execute()

Change Language

Sends a request to execute a prepared statement with given parameters, without waiting for the result(s). (PHP 5 >= 5.1.0)
bool pg_send_execute ( resource connection, string stmtname, array params )