pg_convert

(PHP 4 >= 4.3.0, PHP 5)

pg_convert — 将关联的数组值转换为适合 SQL 语句的格式。

说明

array pg_convert ( resource $connection , string $table_name , array $assoc_array [, int $options = 0 ] )

pg_convert() 检查 assoc_array 中的值并将其转换为为适用于 SQL 语句的值。 pg_convert() 的前提条件是现有的表 table_name 中具有的列至少有 assoc_array 中的单元那么多。table_name 中的字段名以及字段值必须和 assoc_array 中的键名及值匹配。如果成功则返回一个包括转换后的值的数组，否则返回 FALSE 。

Note:

If there are boolean fields in table_name don't use the constant TRUE in assoc_array. It will be converted to the string 'TRUE' which is no valid entry for boolean fields in PostgreSQL. Use one of t, true, 1, y, yes instead.

Warning

此函数是实验性的。此函数的表象，包括名称及其相关文档都可能在未来的 PHP 发布版本中未通知就被修改。使用本函数风险自担。

参数

connection: PostgreSQL database connection resource.
table_name: Name of the table against which to convert types.
assoc_array: Data to be converted.
options: Any number of PGSQL_CONV_IGNORE_DEFAULT , PGSQL_CONV_FORCE_NULL or PGSQL_CONV_IGNORE_NOT_NULL , combined.

返回值

An array of converted values, or FALSE on error.

范例

Example #1 pg_convert() example

  <?php 
  $dbconn  =  pg_connect ( 'dbname=foo' );
  
   $tmp  = array(
       'author'  =>  'Joe Thackery' ,
       'year'  =>  2005 ,
       'title'  =>  'My Life, by Joe Thackery'
   );
  
   $vals  =  pg_convert ( $dbconn ,  'authors' ,  $tmp );
 ?>

参见

pg_meta_data() - 获得表的元数据

用户评论:

[#1] gorhas at gmail dot com [2014-10-07 20:41:50]

There is a problem when using interval.
If in the array
"time_pause" => '00:30:00'
and time_pause is an interval
the insert fails
pg_insert(): '00:30:00' does not match with '^(@?[ \t]+)?((([-+]?[ \t]+)?[0-9]+(\.[0-9]*)?[ ...

[#2] Andrew Falanga [2005-02-24 12:03:00]

Why does this function, pg_convert(), reject the string 'TRUE' as a valid value for the boolean types? I'm using PHP 4.3.9 and my web page originally set the value for submission to update, to 'TRUE'. pg_convert() threw it back to me saying that it's not a valid value for boolean types. However, the postgresql website says otherwise. See http://www.postgresql.org/docs/7.4/static/datatype-boolean.html for the context of my question/comment.

[#3] [2004-03-31 08:02:34]

The only options that I see are:

PGSQL_CONV_IGNORE_DEFAULT - Do not use DEAFULT value by removing field from returned array
PGSQL_CONV_FORCE_NULL - Convert to NULL if string is null string
PGSQL_CONV_IGNORE_NOT_NULL - Ignore NOT NULL constraints

These are constants, so don't quote them or anything.

[#4] dharana at dharana dot net [2003-05-12 06:28:45]

I've found "options" possible values:

PG_CONV_CHECK - check only
PG_CONV_STRICT - raise warning for non fatal error
PG_CONV_QUOTE - add quote around values for vchar, text datetime.
PG_CONV_SLASH - add slashes if it needed.
PG_CONV_NULLCHK - check values are defined for NOT NULL fields.
PG_CONV_NO_DEFAULT - ignore default value even if value is empty string.