Re: Problem with pg_connect() in PHP

Looks like you are missing the php_pgsql extension (I assume you
are running on a Windows server). On Debian GNU/Linux, it is called
php5-pgsql (or php4-pgsql, as appropriate). Not sure what it would
be called for Windows, but something similar.

Simply enabling it (by uncommenting the line in your php.ini file)
is not sufficient - the actual library needs to be installed as well.

Cheers,

Bob Edwards.

James Kitambara wrote:
> 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
>
>