Friday, September 26, 2008

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

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


No comments: