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@yahoo.com
rtmsoft@gmail.com

--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: Can"t connect to postgresql using php

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/

--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: Can"t connect to postgresql using php

> 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@yahoo.com
rtmsoft@gmail.com

--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: Can"t connect to postgresql using php

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



--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

Re: Can"t connect to postgresql using php

------=_Part_9402_10008279.1214409027056
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 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/
> Bringing the world a little coloser to your business
>
>
>
>
> --
> Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-php
>

------=_Part_9402_10008279.1214409027056
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Re: Can"t connect to postgresql using php

------=_Part_12180_21227593.1214409296720
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_12180_21227593.1214409296720
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 .

I am using WAMPServer 2 () 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 () 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