pg_result_status
(PHP 4 >= 4.2.0)
pg_result_status -- Get status of query result
Description
int pg_result_status ( resource result)
pg_result_status() returns status of result resource. Possible
return values are PGSQL_EMPTY_QUERY, PGSQL_COMMAND_OK, PGSQL_TUPLES_OK,
PGSQL_COPY_TO, PGSQL_COPY_FROM, PGSQL_BAD_RESPONSE, PGSQL_NONFATAL_ERROR
and PGSQL_FATAL_ERROR.
See also pg_connection_status().
pg_select
(PHP 4 >= 4.3.0)
pg_select -- Select records.
Description
array pg_select ( resource connection, string table_name,
array assoc_array [, int options])
pg_select() selects records specified by assoc_array which
has field=>value. For successful query, it returns array
contains all records and fields that match the condition
specified by assoc_array. If options is specified, pg_convert()
is applied to assoc_array with specified option.
Example 1. pg_select() example
<?php
$db = pg_connect('dbname=foo');
// This is safe, since $_POST is converted automatically
$rec = pg_select($db, 'post_log', $_POST);
if ($rec) {
echo "Records selected\n";
var_dump($rec);
} else {
echo "User must have sent wrong inputs\n";
}
?>
Warning
This function is EXPERIMENTAL. The behaviour of this function,
the name of this function, and anything else documented
about this function may change without notice in a future
release of PHP. Use this function at your own risk.
See also pg_convert()
