PHP and PostgreSQL connection

------=_Part_2013_7175093.1136982680073
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello!
Is there any special config to connect PHP+PostgreSQL+Apache2.0.54?,
because I try to do pg_connect() and it seems that PHP doesn=B4t find the d=
b,
so please any help will be appreciated

Rafa

------=_Part_2013_7175093.1136982680073
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Re: PHP and PostgreSQL connection

At 07:31 AM 1/11/06, Rafael Mora wrote:
> Is there any special config to connect PHP+PostgreSQL+Apache2.0.54?,=20
> because I try to do pg_connect() and it seems that PHP doesn=B4t find the=
=20
> db, so please any help will be appreciated


Presumably you've already installed php and pgsql. You also need to=20
install php-pgsql package; then enable the module.=20


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

Re: PHP and PostgreSQL connection

------=_Part_2369_31025830.1136984465998
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I've found something about erase ";" on ";ext=3D php_pgsql" on my
php.inifile, Im working with WinXP, i put it in C:\WINDOWS as well...

anything else?, how do I enable the module??

Rafa

------=_Part_2369_31025830.1136984465998
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Re: PHP and PostgreSQL connection

What does your phpinfo() says? It sould say that your version of PostgreSQL
installation is Enabled. If so, what is the error message when you try to
connect with pg_connect ?

Regards,

Javier


On Wed, 11 Jan 2006 07:48:35 -0500, Frank Bax wrote
> At 07:31 AM 1/11/06, Rafael Mora wrote:
> > Is there any special config to connect PHP+PostgreSQL+Apache2.0.54?,
> > because I try to do pg_connect() and it seems that PHP doesn´t find the
> > db, so please any help will be appreciated
>
> Presumably you've already installed php and pgsql. You also need to
> install php-pgsql package; then enable the module.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings


--
nediam.com.mx


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: PHP and PostgreSQL connection

------=_Part_2537_7071537.1136985443202
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Javier where can I find phpinfo()?? sorry I'm new with this... thanx for
your help

Rafa

------=_Part_2537_7071537.1136985443202
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Re: PHP and PostgreSQL connection

Hi,

make a simple text/php file e.g. info.php like this:

phpinfo();
?>

place the file into your document root dir set in apache httpd.conf.
Exec info.php in browser and you'll get a nice html table of
your php conf.

regards,
iges.

On Wednesday, 11. January 2006 15:17, you wrote:
> Javier where can I find phpinfo()?? sorry I'm new with this... thanx for
> your help
>
> Rafa

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

http://archives.postgresql.org

Re: PHP and PostgreSQL connection

This is a multi-part message in MIME format.

------=OPENWEBMAIL_ATT_0.575359069084776
Content-Type: text/plain;
charset=iso-8859-1

Create a new file with the following line:



and save as for example "hello.php" (it could be any name).

Then in your browser check it:

http://yourhost/path/to/hello.php

More information about this function: http://www.php.net/phpinfo

Regards,

Javier

PD. After you finish using this file hello.php, I recommend you to delete this file or change its permissions, or move it to another directory that it's not browsable by web.

On Wed, 11 Jan 2006 09:17:23 -0400, Rafael Mora wrote
> Javier where can I find phpinfo()?? sorry I'm new with this... thanx for your help
>  
> Rafa

--
nediam.com.mx



------=OPENWEBMAIL_ATT_0.575359069084776
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable







Create a new file with the following line:



<?php echo phpinfo(); ?>



and save as for example "hello.php" (it could be any name).



Then in your browser check it:



http://yourhost/path/to/hello.php





More information about this function: http://www.php.net/phpinfo



Regards,



Javier



PD. After you finish using this file hello.php, I recommend you to de=
lete this file or change its permissions, or move it to another directory t=
hat it's not browsable by web.





On Wed, 11 Jan 2006 09:17:23 -0400, Rafael Mora w=
rote

> Javier=20
where can I find phpinfo()?? sorry I'm new with this... thanx for your=20
help


> =A0


>=20
Rafa






--=20



nediam.com.mx=20











------=OPENWEBMAIL_ATT_0.575359069084776--

Re: PHP and PostgreSQL connection

------=_Part_3125_7207708.1136988862944
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Thank you all guys, it's amazing the speed of answers here!!!!, I'll be
writing you soon If I find more problems after the test, I've listened abou=
t
some install app that installs everything you need, i mean apache, php and
postgresql, have you heard about them??

Thank you very much!!
Regards from Caracas, Venezuela

Rafa


On 1/11/06, Javier Carlos wrote:
>
> Create a new file with the following line:
>
>
>
> and save as for example "hello.php" (it could be any name).
>
> Then in your browser check it:
>
> http://yourhost/path/to/hello.php
>
>
> More information about this function: http://www.php.net/phpinfo
>
> Regards,
>
> Javier
>
> PD. After you finish using this file hello.php, I recommend you to delete
> this file or change its permissions, or move it to another directory that
> it's not browsable by web.
>
>
> *On Wed, 11 Jan 2006 09:17:23 -0400, Rafael Mora wrote*
> > Javier where can I find phpinfo()?? sorry I'm new with this... thanx fo=
r
> your help
> >
> > Rafa
>
>
> --
> nediam.com.mx
>
>

------=_Part_3125_7207708.1136988862944
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Re: PHP and PostgreSQL connection

At 08:17 AM 1/11/06, Rafael Mora wrote:

>Javier where can I find phpinfo()?? sorry I'm new with this... thanx for
>your help
>


Have you tried google? Either of the first two hits when searching for
"phpinfo" would have answered this question.


---------------------------(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

Re: PHP and PostgreSQL connection

------=_Part_3345_18654591.1136989991290
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Yeah sure no doubt Google would help me, but I'm doing another project in
Java using RMI, im studying Informatic Engineering (like Computer
Engineering) and I prefered to get your help!! while I'm focused on the
other project...

Rafa


On 1/11/06, Frank Bax wrote:
>
> At 08:17 AM 1/11/06, Rafael Mora wrote:
>
> >Javier where can I find phpinfo()?? sorry I'm new with this... thanx for
> >your help
> >
>
>
> Have you tried google? Either of the first two hits when searching for
> "phpinfo" would have answered this question.
>
>
> ---------------------------(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
>

------=_Part_3345_18654591.1136989991290
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline