Can't connect to postgresql using php

Hello Everyone,

I am new to apache, postgresql, and php but i manage to installed it
in my winxp laptop. My php and apache are working and i can connect to
mysql database. However, i can't connect to postgresql. Please help,
need it badly...Thank in advanced.

Best regards,

--
Roche Tumlad Magsayo
rtmsoft(at)yahoo(dot)com
rtmsoft(at)gmail(dot)com

roche magsayo wrote:
> Hello Everyone,
>
> I am new to apache, postgresql, and php but i manage to installed it
> in my winxp laptop. My php and apache are working and i can connect to
> mysql database. However, i can't connect to postgresql. Please help,
> need it badly...Thank in advanced.

What error do you get?

Have you installed the php-pgsql.dll file and also edited the php.ini
file to include it?

Have you restarted apache?

Does postgresql show up in a phpinfo() page?

--
Postgresql & php tutorials
http://www.designmagick.com/

> What error do you get?
This is the error i get:
===========================
The website cannot display the page
HTTP 500
Most likely causes:
The website is under maintenance.
The website has a programming error.
==========================

> Have you installed the php-pgsql.dll file and also edited the php.ini
> file to include it?
I've already installed it and edited the php.ini
[PHP_PGSQL]
extension=php_pgsql.dll

> Have you restarted apache?
i've restarted many time, still i got those...

> Does postgresql show up in a phpinfo() page?
phpinfo(), it's work.

--
Roche Tumlad Magsayo
rtmsoft(at)yahoo(dot)com
rtmsoft(at)gmail(dot)com

On Wed, 25 Jun 2008, roche magsayo wrote:

>> What error do you get?
> This is the error i get:
> ===========================
> The website cannot display the page
> HTTP 500
> Most likely causes:
> The website is under maintenance.
> The website has a programming error.
> ==========================
>
>> Have you installed the php-pgsql.dll file and also edited the php.ini
>> file to include it?
> I've already installed it and edited the php.ini
> [PHP_PGSQL]
> extension=php_pgsql.dll
>
>> Have you restarted apache?
> i've restarted many time, still i got those...
>
>> Does postgresql show up in a phpinfo() page?
> phpinfo(), it's work.

Does this mean there's a section in phpinfo() for postgresql?

If it does, post the code you're using to connect.

Vince.
--
Michigan VHF Corp. http://www.nobucks.net/ http://www.CDupe.com/
Bringing the world a little coloser to your business

Hi Vince,

Can you please specify the version of Apache and PHP? It seems there is a
problem with the pgsql extension in PHP5.2.6 - as Jason Minion had mentioned
in another thread, please refer http://bugs.php.net/bug.php?id=44905.
I am using WAMPServer 2 (http://www.wampserver.com/en/index.php) - which
provides a good development environment for Windows based Apache - PHP. It
allows you to install almost all the existing releases(
http://www.wampserver.com/en/add-ons.php) of Apache, PHP (and MySQL) and
configure them easily - so that you can enable the MySQL or PgSQL modules as
you want in your PHP extensions.

I have PostgreSQL 8.2.4 and WampServer2 (Apache 2.2.6 and PHP 5.2.5)
installed on my XP laptop and it works fine. I also use phppgadmin (
http://sourceforge.net/projects/phppgadmin) which is similar to but not as
much userfriendly (atleast) like phpmyadmin.

Though I have not used myself, I still know that WampServer allows you to
install * any number of * latest releases of Apache and PHP and configure
and switch between them.

Thanks and Regards,
Chandra-ASGI

On Wed, Jun 25, 2008 at 7:05 AM, Vince Vielhaber <vev(at)michvhf(dot)com> wrote:

> On Wed, 25 Jun 2008, roche magsayo wrote:
>
> What error do you get?
>>>
>> This is the error i get:
>> ===========================
>> The website cannot display the page
>> HTTP 500
>> Most likely causes:
>> The website is under maintenance.
>> The website has a programming error.
>> ==========================
>>
>> Have you installed the php-pgsql.dll file and also edited the php.ini
>>> file to include it?
>>>
>> I've already installed it and edited the php.ini
>> [PHP_PGSQL]
>> extension=php_pgsql.dll
>>
>> Have you restarted apache?
>>>
>> i've restarted many time, still i got those...
>>
>> Does postgresql show up in a phpinfo() page?
>>>
>> phpinfo(), it's work.
>>
>
> Does this mean there's a section in phpinfo() for postgresql?
>
> If it does, post the code you're using to connect.
>
> Vince.
> --
> Michigan VHF Corp. http://www.nobucks.net/ http://www.CDupe.com/<http://www.cdupe.com/>
> Bringing the world a little coloser to your business
>
>
>
>
> --
> Sent via pgsql-php mailing list (pgsql-php(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-php
>

Hi Vince,

Can you please specify the version of Apache and PHP? It seems there is a
problem with the pgsql extension in PHP5.2.6 - as Jason Minion had mentioned
in another thread, please refer http://bugs.php.net/bug.php?id=44905.

I am using WAMPServer 2 (http://www.wampserver.com/en/index.php) - which
provides a good development environment for Windows based Apache - PHP. It
allows you to install almost all the existing releases(
http://www.wampserver.com/en/add-ons.php) of Apache, PHP (and MySQL) and
configure them easily - so that you can enable the MySQL or PgSQL modules as
you want in your PHP extensions.

I have PostgreSQL 8.2.4 and WampServer2 (Apache 2.2.6 and PHP 5.2.5)
installed on my XP laptop and it works fine. I also use phppgadmin (
http://sourceforge.net/projects/phppgadmin) which is similar to but not as
much userfriendly (atleast) like phpmyadmin.

Though I have not used myself, I still know that WampServer allows you to
install * any number of * latest releases of Apache and PHP and configure
and switch between them.

Thanks and Regards,
Chandra-ASGI