pg_execute

Sends a request to execute a prepared statement with given parameters, and waits for the result. (PHP 5 >= 5.1.0)
resource pg_execute ( resource connection, string stmtname, array params )

resource pg_execute ( string stmtname, array params )

Example 1918. Using pg_execute()

<?php
// Connect to a database named "mary"
$dbconn = pg_connect("dbname=mary");

// Prepare a query for execution
$result = pg_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1');

// Execute the prepared query.  Note that it is not necessary to escape

// the string "Joe's Widgets" in any way
$result = pg_execute($dbconn, "my_query", array("Joe's Widgets"));

// Execute the same prepared query, this time with a different parameter
$result = pg_execute($dbconn, "my_query", array("Clothes Clothes Clothes"));

?>

Code Examples / Notes » pg_execute

I am not 100% sure in this, but pg_exec() could return 0 as Connection ID. because of that i change some of my code like this: $dbres = pg_exec($SQL); if ($dbres === false){ echo "DB is down"; exit; }else{ //do something }

pg_execute

Sends a request to execute a prepared statement with given parameters, and waits for the result. (PHP 5 >= 5.1.0) resource pg_execute ( resource connection, string stmtname, array params ) resource pg_execute ( string stmtname, array params )

Example 1918. Using pg_execute()

Code Examples / Notes » pg_execute

Change Language

Sends a request to execute a prepared statement with given parameters, and waits for the result. (PHP 5 >= 5.1.0)
resource pg_execute ( resource connection, string stmtname, array params )

resource pg_execute ( string stmtname, array params )