Php pg send execute () function

Write your php code

(no version information, might be only in CVS)

pg_send_execute -- Asynchronously execute a previously prepared query

Syntax

resource pg_send_execute ( string stmtname, array params )

resource pg_send_execute ( resource connection, string stmtname, array params )

pg_send_execute() executes a previously prepared named query on the connection, with the specified parameters. Unlike pg_execute(), script execution is not blocked while the query is executing.

pg_send_execute() returns a query result resource if the named prepared query could be executed with the given parameters. It returns FALSE on failure or if connection is not a valid connection. It is identical to pg_send_query_params() except that it takes the name of a previously prepared query instead of an actual query.

Examples

Example 1. 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);
  }
  
?>

Php pg send execute Function syntax tag

pg send execute php code on this is provided for your study purpose, it will guide you to know how create and design a website using php. use it to practice and train your self online

Php pg send execute syntax tutorial

php tutorial guide and code design are for easy learning and programming. The code practice section provided at the top is for practising of this syntax. Use the code section up to practice your php programming online. Learning php is very easy, all you need is to use the examples on this site and practice them to perfect your skills.