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 ] )

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

Warning

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

参见 pg_meta_data()。

参数

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() - 获得表的元数据

PHP手册 - N: 将关联的数组值转换为适合 SQL 语句的格式。

用户评论:

Andrew Falanga (24-Feb-2005 08:03)

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.

(31-Mar-2004 04:02)

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.

dharana at dharana dot net (12-May-2003 02:28)

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.