I wish to use PostgreSQL with PHP+PDO. I haven't use PDO before.
I have the php-pdo package installed on my CentOS 4.7 server:
# rpm -qa |grep pdo
php-pdo-5.1.6-3.el4s1.10
Now when I try connect to the PostgeSQL db with this code:
<?php
print "PDO test<br />";
try {
$db = new
PDO("pgsql:host=192.168.0.180;port=5432;dbname=mydb;user=test;password=test");
} catch(PDOException $e) {
print "Error : " . $e->getMessage() . "<br/>";
die();
}
?>
I get no output in the browser, but I see this error in Apache log:
PHP Fatal error: Class 'PDO' not found in /var/www/html/pdotest.php on line 4
Well, it appears the PDO class is not provided by the php-pdo package:
# rpm -ql php-pdo |less/etc/php.d/pdo.ini
/etc/php.d/pdo_sqlite.ini
/usr/lib/php/modules/pdo.so
/usr/lib/php/modules/pdo_sqlite.so
So, what package does provide it or have I misunderstood something?
Regards,
Peter