Thread: 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

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