pg_field_name是返回欄位的名字,返回給定 PostgreSQL result 資源中的 field_number 所代表的欄位名;
pg_field_name,說明,
pg_field_name
(PHP 4 >= 4.2.0)
說明
string pg_field_name ( resource result, int field_number)
pg_field_name() 欄位編號從 0 開始。
例子 1. 獲取欄位信息 <?php $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); $res = pg_query($dbconn, "select * from authors where author = 'Orwell'"); $i = pg_num_fields($res); for ($j = 0; $j < $i; $j++) { echo "column $j\n"; $fieldname = pg_field_name($res, $j); echo "fieldname: $fieldname\n"; echo "printed length: ".pg_field_prtlen($res, $fieldname)." characters\n"; echo "storage length: ".pg_field_size($res, $j)." bytes\n"; echo "field type: ".pg_field_type($res, $j)." \n\n"; } ?> 上例的輸出如下: column 0fieldname: authorprinted length: 6 characters storage length: -1 bytesfield type: varcharcolumn 1fieldname: year printed length: 4 charactersstorage length: 2 bytesfield type: int2column 2 fieldname: titleprinted length: 24 charactersstorage length: -1 bytes field type: varchar |
注: 本函式以前的名字為 pg_fieldname()。