PHP with PostgreSQL - postgres/php and windows

Author

postgres/php and windows

Dave Wayne

2005-11-20, 8:24 pm

Does anyone know if there is a good guide for setting up php to connect to postgres under windows? I've set up postgres, however the PConnect function fails for some reason.

Any help would be appriecated

Michael Glaesemann

2005-11-20, 8:24 pm

On Nov 21, 2005, at 7:04 , Dave Wayne wrote:

> Does anyone know if there is a good guide for setting up php to
> connect to postgres under windows? I've set up postgres, however
> the PConnect function fails for some reason.

What's the reason? What error message are you getting? One thing to
check is to make sure PHP was compiled with pgsql support. Provide
more details and hopefully someone will be able to provide better help.

Good luck!

Michael Glaesemann
grzm myrealbox com

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

John DeSoi

2005-11-21, 3:24 am

On Nov 20, 2005, at 5:04 PM, Dave Wayne wrote:

> Does anyone know if there is a good guide for setting up php to
> connect to postgres under windows? I've set up postgres, however
> the PConnect function fails for some reason.

Did you enable the pgsql dll in the php.ini file? The semicolon needs
to be removed.

;extension=php_pgsql
.dll

If that does not solve it, give more specifics about the error.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

CGMoller@StateStreet.com

2005-11-21, 9:24 am

In addition to error messages, what is your setup? What versions of PHP,
Postgres and Web (Apache?) are you using? The configurations are different
depending upon what you have installed.
Also you should check the PHP manual:
http://us3.php.net/manual/en/function.pg-connect.php.

Cameron G. Moller

Michael
Glaesemann
<grzm@myrealbox.c To
om> Dave Wayne <davewayne@shaw.ca>
Sent by: cc
pgsql-php-owner@p pgsql-php@postgresql.org
ostgresql.org Subject
Re: [PHP] postgres/php and windows

11/20/2005 06:25
PM

On Nov 21, 2005, at 7:04 , Dave Wayne wrote:

> Does anyone know if there is a good guide for setting up php to
> connect to postgres under windows? I've set up postgres, however
> the PConnect function fails for some reason.

What's the reason? What error message are you getting? One thing to
check is to make sure PHP was compiled with pgsql support. Provide
more details and hopefully someone will be able to provide better help.

Good luck!

Michael Glaesemann
grzm myrealbox com

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

manjusri schuit

2005-11-21, 1:23 pm

Hello
First you will need to know wheter php is been setup corectly.

Paste this

<?php
phpinfo()
?>

into a textfile or you're favorite editor and save it as phpinfo.php or so
in you're webroot (mydrive\Apache Group\ApacheX\htdocs
)

then goto http://localhost/phpinfo.php

1) Configurationfile (php.ini) Path must piont to the place wher you stored
you're php ini.
2) if you scroll down a bit you will find a block with "pgpsql" witchs means
that you have postgres support enabled in php.
If not found that means you're php ini is not setup correctly
check www.php.net <http://www.php.net> for more info on how to setup php.ini
..

--
Met vriendelijke groet
Manjusri Schuit

On 11/20/05, Dave Wayne <davewayne@shaw.ca> wrote:
>
> Does anyone know if there is a good guide for setting up php to connect to
> postgres under windows? I've set up postgres, however the PConnect function
> fails for some reason.
> Any help would be appriecated
>

operationsengineer1@yahoo.com

2005-11-21, 8:25 pm

--- Dave Wayne <davewayne@shaw.ca> wrote:

> Does anyone know if there is a good guide for
> setting up php to connect to postgres under windows?
> I've set up postgres, however the PConnect function
> fails for some reason.
>
> Any help would be appriecated

Dave, I have developed detailed instructions to
install Apache, with PHP CGI support, and Postgresql
8.0.

I will put them online and post a link later today.

OE1

____________________
______________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

operationsengineer1@yahoo.com

2005-11-22, 3:24 am

--- Dave Wayne <davewayne@shaw.ca> wrote:

> Does anyone know if there is a good guide for
> setting up php to connect to postgres under windows?
> I've set up postgres, however the PConnect function
> fails for some reason.
>
> Any help would be appriecated

Dave,

Check out this link...

http://www.geocities.com/operationsengineer1/

for my attempt to create a tutorial to isntall
Apache2, PHP5 and PGSQL8 on WinXP.

the links are for pdf files and they are about a meg
each. the webhost only allows a limited amount of
transfer bandwidth, so be sure to return if the limit
is exceeded.

I would also suggest that others not check the links
unless they are actively trying this install - at
least until Dave is able to download the files.

I will get the instructions up via a web page, but it
proved to be difficult using geocities.

Do fweel free to offer suggestions and point out
errors of any kind.

Good luck,

OE1

____________________
______________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links