pg_select

(PHP 4 >= 4.3.0, PHP 5)

pg_select --  选择记录

说明

array pg_select ( resource connection, string table_name, array assoc_array [, int options] )

pg_select() 根据 assoc_array 数组中的 field=>value 值来选择记录。成功的查询返回和 assoc_array 指定的条件相匹配的包括记录和字段的数组。如果指定了 optionspg_convert() 会按照指定选项作用于 assoc_array 之上。

例子 1. pg_select

<?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";
    }
?>

警告

本函数是实验性的。本函数的行为,包括函数名称以及其它任何关于本函数的文档可能会在没有通知的情况下随 PHP 以后的发布而改变。使用本函数风险自担。

参见 pg_convert()


add a note add a note User Contributed Notes
wietse at cj2 dot nl
28-Feb-2006 12:20
David mentioned that you can't do a Select all.
However, when executing this script:
<?php
   $conn_string
= "dbname=mydb";
  
$db = pg_connect($conn_string);
  
$selectfields = array("imgid" => "");
  
$records = pg_select($db,"mmsfiles",$selectfields);
  
print_r($records);
?>
...I get this result:
Array
(
   [0] => Array
       (
           [imgid] => 1
           [file] => /home/wietse/public_html/mms/images/1.gif
           [thumb] =>
       )
   [1] => Array
       (
           [imgid] => 2
           [file] => /home/wietse/public_html/mms/images/2.gif
           [thumb] =>
       )
   [2] => Array
       (
           [imgid] => 3
           [file] => /home/wietse/public_html/mms/images/3.gif
           [thumb] =>
       )
   [3] => Array
       (
           [imgid] => 4
           [file] => /home/wietse/public_html/mms/images/4.gif
           [thumb] =>
       )
)
david dot tulloh at infaze dot com dot au
17-May-2005 12:46
Valid options are PGSQL_DML_NO_CONV, PGSQL_DML_EXEC, PGSQL_DMP_ASYNC, PGSQL_DML_STRING (pulled out of source code).

This function does not support selecting from multiple tables.  You can get around this by setting the PGSQL_DML_NO_CONV option.  This prevents the error which occurs when the function tries to convert the condition array.

I think it is also important to point out that the table_name field is not safe, particularily with the PGSQL_DML_NO_CONV option.

The arguements array field is compulsory, as documented.  What isn't so clear is that the array has to actually have some values in it, you can't do a select all.

In summary, this function is good for a very small subset of basic queries.  If you are after anything more complex you are better off with pg_query.