PostgreSQL 8 confuguration for PHP

reach_nmadhu

Hello

I am new in php developement. I have php and apache installed on WINNT and working fine. But whenever tried to connect PostgreSQL db from php, it gives error like:
Fatal error: Call to undefined function pg_connect() in D:\Apache\Apache2\htdocs\ ................

I have postgreSQL 8.0.2 installed, created db and want to connect to through php

Please help

Thanx

Sxooter

take a look here:

http://phppgadmin.sourceforge.net/?page=faq

reach_nmadhu

Even after editing the c:\winnt\system32\php.ini file, the problem remains as it is. It's giving error at very first line where I am trying to connect with database.

My code is like:
File - testcon.php
<?
$connString = "host=localhost port=5432 dbname=excampus user=www passward=www";
$conn = pg_connect($connString);
$sql = "SELECT name FROM test;";
$result = pg_query($conn, $sql);
$row = pg_fetch_object($result, 0);
echo "Name: " .$row;
?>

And error is:
Fatal error: Call to undefined function pg_connect() in D:\Apache\Apache2\htdocs\testcon.php on line 4

Is there anything I am not setting properly?

Please help

Sxooter

have you restarted your webserver?

reach_nmadhu

After editing php.ini file, I restarted the webserver(Apache). Still no luck.

Is it b'coz of my OS(winnt)?

Sxooter

Never having used PHP under windows / apache, I'm not sure where the problem might lie, really.

I'm assuming you did all the stuff for configuration in the link I provided, so at this point, I don't know what else to do. Does the php_pgsql.dll file exist on your system, and is php.ini pointing to the place where it is?

fldave850

I noticed you had password misspelled on line 2. These small mistakes can add up. Also if you configured php without psql you will receive that same error.