[PHP] PEAR::MDB2 andquery

[Alain Roger]

Hi,

I'm still wondering how are linked MDB2 class and MDB2_Driver_pgsql class.
when i analyze the code of DB.php and pgsql.php, it's clear that
DB.phpcheck a class based on phptype and therefore include the
pgsql.php file.

But i did not find something similar in MDB2.php.
i would like to understand how can i do execute a query via MDB2 class on a
postgreSQL DB.

here is my code and for sure it does not work.
the $db2->query(); is not a function from MDB2...only from MDB2_Driver_pgsql
class.


global $dsn;
$options = array('debug'       => 2,
                              'portability' => MDB2_PORTABILITY_ALL,
                              );

$query = 'SELECT * from sp_u_001(\'all\')';

$db2 = & new MDB2();
$db2->connect($dsn);
if (MDB2::isError($db2))
{
  die("Error connection :
".$db2->getMessage()."<br><br>".$res->getUserinfo());
}

$res =$db2->query($query);
if (MDB2::isError($res))
{
 die("Error connection :
".$res->getMessage()."<br><br>".$res->getUserinfo());
}

--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5