Friday, September 26, 2008

Re: [SQL] Problem with pg_connect() in PHP

On Sep 26, 2008, at 12:23 PM, Edward W. Rouse wrote:

Can I assume the missing '."' From the end of PG_PASSWORD is a cut and paste error?
Edward W. Rouse
From: [] On Behalf Of James Kitambara
Sent: Friday, September 26, 2008 1:22 AM
To: pgsql-sql
Cc: Kenichiro Arakaki; Ken Arakaki
Subject: [SQL] Problem with pg_connect() in PHP
Dear Members of
I have installed the Apache 2.0.61,  PHP 5.2.4 and PostgreSQL 8.1 on my local computer.
All three software were successfully tested. I changed ";extension=php_pgsql.dll"  to
"extension=php_pgsql.dll"    in the php.ini file in order to enable PostgreSQL in PHP.
The problem comes when I try to connect to the PostgreSQL Database using php function pg_connect
$dbconn = pg_connect("host=".PG_HOST_NAME." port=".PG_PORT_NUM."  dbname=".PG_DB_NAME." user=".PG_USER." password=".PG_PASSWORD);
All the arguments in the function pg_connect() are defined.
Unfortunately I am getting the Fatal error: "Call to undefined function pg_connect() in C:\Web\html\Staff_Management\example1.php on line 23"
C:\Web\html is my document root.
What could be the possible mistake?
Anyone to assist me!
Best regards,
James Kitambara

Did you re-start apache after you made the changes to the php.ini file?


No comments: