Postgres PHP

[FidoDifo]

I am trying to connect to a remote server running Postgres

<?
$conn_string = "host=localhost port=5432 dbname=test user=test";
$conn = pg_connect($conn_string) or die("Connect Error");
?>

but I got this ---
Call to undefined function: pg_connect() in c:\program files\apache group\apache\htdocs\test\test.php on line 4

Can anyone help!!!

[phpdevelopers]

Your PHP is compiled without support for PostgreSQL, that's why you are getting this error. You need to recompile PHP with --with-pgsql=/path/to/postgresql option if you are on Unix.

[shu]

PHP on Windoze doesn't come with PostgreSQL support by default! You best bet would to use an database abstraction layer. Take a look at PEAR :: DB, or my favorite, PHPLib. There are many out there to choose from! Good luck...

[FidoDifo]

I have already downloaded the PEAR :: DB, but how should I install the PEAR :: DB packages into the Windows??
Sorry, I am kind of new to PHP....
Can you provide me the instructions...?? 🙂

Thanx in advance!!!!!

[shu]

Just put the PEAR.php and DB.php into your include path, then you can use the include, or require method to import them into your php pages. It would be to hard to explain how to use it here, but I would recommend reading the following two short tutorials, they should give you a pretty good idea as how to use PEAR :: DB classes:

Quick Start Guide to Pear DB

PEAR DB Tutorial on phpbuilder.com

[FidoDifo]

It works!!!! 🙂

Thanx!!!!....