 |
| ::: T4VN Statistics ::: |
 PHP Scripts : 64 |
| PHP Example : 67 |
| PHP Tutorials : 21 |
| PHP News : 93 |
| Total Coupon : 36 |
| Other Tutorials : |
| Member : 215 |
| Visitor Online : 3 |
| Today Visit: 268 |
| Total Visitor : 301290 |
| Most Online : 41 |
|
 |
|
Data Type Converter between PHP and PostgreSQL
Author : pgasioro
This class converts variables:
PHP -> PostgreSQL
PostgreSQL -> PHP
I often use it for converting PHP arrays
| PHP Example : | |
<?php
/**
* Dia_DataTypeConverter
*
* Data Type Converter between PHP and PostgreSQL
*
* @package Diamond
* @author Pawel Gasiorowski
* @copyright Copyright (c) 2005
* @version $Id$
* @access public
**/
class Dia_DataTypeConverter
{
/**
* Dia_DataTypeConverter::pgsql_to_php()
*
* @param $pgVal
* @param $pg_field_type
* @return
**/
function pgsql_to_php($pgVal, $pg_field_type)
{
switch ($pg_field_type)
{
case 'bool':
return ($pgVal == 't') ? true : false;
break;
case 'numeric':
settype($pgVal, "integer");
return $pgVal;
break;
default:
return $pgVal;
break;
} // switch
}
/**
* Dia_DataTypeConverter::php_to_pqsql()
*
* @param $phpVal
* @return
**/
function php_to_pqsql($phpVal)
{
if (is_null($phpVal))
{
return 'null';
}
else if (is_bool($phpVal))
{
return ($phpVal === true) ? 'true' : 'false';
}
else if (is_string($phpVal))
{
return "'" . ereg_replace("'", "\'", $phpVal) . "'";
}
else if (is_array($phpVal))
{
foreach ($phpVal as $key => $item)
{
$phpVal[$key] = $this->php_to_pqsql($item);
}
return '[' . implode(',', $phpVal) . ']';
}
else
{
return $phpVal;
}
}
}
?>
|
Usage Example:
| PHP Example : | |
<?
$pgArray = Dia_DataTypeConverter::php_to_pqsql(array(1,2,3,));
?>
| |
| |
|
|
| ::: Resources ::: |
|
|
| ::: New Templates ::: |
|
| ::: Other Tutorials ::: |
|
|
Home
