Re: Problem with pg_connect() in PHP

From: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
To: 'pgsql-sql' <pgsql-sql(at)postgresql(dot)org>, "Edward W(dot) Rouse" <erouse(at)comsquared(dot)com>
Subject: Re: Problem with pg_connect() in PHP
Date: 2008-09-26 18:47:02
Message-ID: 522927.60381.qm@web59501.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

--- On Fri, 9/26/08, Edward W. Rouse <erouse(at)comsquared(dot)com> wrote:

> From: Edward W. Rouse <erouse(at)comsquared(dot)com>
> Subject: Re: [SQL] Problem with pg_connect() in PHP
> To: "'pgsql-sql'" <pgsql-sql(at)postgresql(dot)org>
> Date: Friday, September 26, 2008, 5:23 PM
> Can I assume the missing ‘.”’ From the end of
> PG_PASSWORD is a cut and paste error?
>
>
>
> Edward W. Rouse
>
>
>
> From: pgsql-sql-owner(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org] 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

first create a file that contains this

<? phpinfo(); ?>

save this with php extension, run this file from the browser and seek for the directory extension, then look if the file php_pgsql.dll is there

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma 2008-09-26 19:12:35 Re: Finding sequential records
Previous Message ries van Twisk 2008-09-26 18:27:48 Re: Problem with pg_connect() in PHP