pg_convert

Convert associative array values into suitable for SQL statement (PHP 4 >= 4.3.0, PHP 5)
array pg_convert ( resource connection, string table_name, array assoc_array [, int options] )

pg_convert() checks and converts the values in assoc_array into suitable values for use in a SQL statement. Precondition for pg_convert() is the existence of a table table_name which has at least as many columns as assoc_array has elements. The fieldnames in table_name must match the indices in assoc_array and the corresponding datatypes must be compatible. Returns an array with the converted values on success, FALSE otherwise.

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:

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.

Parameters

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.

Return Values

An array of converted values, or FALSE on error.

Examples

Example 1910. pg_convert() example

copy to clipboard

<?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_convert

Convert associative array values into suitable for SQL statement (PHP 4 >= 4.3.0, PHP 5)
array pg_convert ( resource connection, string table_name, array assoc_array [, int options] )

Parameters

Return Values

Examples

Example 1910. pg_convert() example

Code Examples / Notes » pg_convert

Change Language

pg_convert

Convert associative array values into suitable for SQL statement (PHP 4 >= 4.3.0, PHP 5) array pg_convert ( resource connection, string table_name, array assoc_array [, int options] )

Parameters

Return Values

Examples

Example 1910. pg_convert() example

Code Examples / Notes » pg_convert

Change Language

Convert associative array values into suitable for SQL statement (PHP 4 >= 4.3.0, PHP 5)
array pg_convert ( resource connection, string table_name, array assoc_array [, int options] )