pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedPHP and PostgreSQL connection
15+ messages / 7 participants
[nested] [flat]
* PHP and PostgreSQL connection
@ 2006-01-11 12:31 Rafael Mora <moraloco@gmail.com>
0 siblings, 0 replies; 15+ messages in thread
From: Rafael Mora @ 2006-01-11 12:31 UTC (permalink / raw)
To: pgsql-php
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´t find the db,
so please any help will be appreciated
Rafa
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
@ 2006-01-11 12:48 Frank Bax <fbax@sympatico.ca>
2006-01-11 13:01 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
0 siblings, 2 replies; 15+ messages in thread
From: Frank Bax @ 2006-01-11 12:48 UTC (permalink / raw)
To: pgsql-php
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
@ 2006-01-11 13:01 ` Rafael Mora <moraloco@gmail.com>
1 sibling, 0 replies; 15+ messages in thread
From: Rafael Mora @ 2006-01-11 13:01 UTC (permalink / raw)
To: pgsql-php
I've found something about erase ";" on ";ext= 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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
@ 2006-01-11 13:10 ` Javier Carlos <nediam@nediam.com.mx>
2006-01-11 13:17 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
2006-01-11 14:25 ` Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
1 sibling, 2 replies; 15+ messages in thread
From: Javier Carlos @ 2006-01-11 13:10 UTC (permalink / raw)
To: Frank Bax <fbax@sympatico.ca>; pgsql-php
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
@ 2006-01-11 13:17 ` Rafael Mora <moraloco@gmail.com>
2006-01-11 13:41 ` Re: PHP and PostgreSQL connection seem.iges@mail.ee
2006-01-11 13:55 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
1 sibling, 2 replies; 15+ messages in thread
From: Rafael Mora @ 2006-01-11 13:17 UTC (permalink / raw)
To: pgsql-php
Javier where can I find phpinfo()?? sorry I'm new with this... thanx for
your help
Rafa
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
2006-01-11 13:17 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
@ 2006-01-11 13:41 ` seem.iges@mail.ee
1 sibling, 0 replies; 15+ messages in thread
From: seem.iges@mail.ee @ 2006-01-11 13:41 UTC (permalink / raw)
To: Rafael Mora <moraloco@gmail.com>; +Cc: pgsql-php
Hi,
make a simple text/php file e.g. info.php like this:
<?php
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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
2006-01-11 13:17 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
@ 2006-01-11 13:55 ` Javier Carlos <nediam@nediam.com.mx>
2006-01-11 14:14 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
1 sibling, 1 reply; 15+ messages in thread
From: Javier Carlos @ 2006-01-11 13:55 UTC (permalink / raw)
To: Rafael Mora <moraloco@gmail.com>; pgsql-php
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 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
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
2006-01-11 13:17 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
2006-01-11 13:55 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
@ 2006-01-11 14:14 ` Rafael Mora <moraloco@gmail.com>
0 siblings, 0 replies; 15+ messages in thread
From: Rafael Mora @ 2006-01-11 14:14 UTC (permalink / raw)
To: Javier Carlos <nediam@nediam.com.mx>; +Cc: pgsql-php
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 about
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 <nediam@nediam.com.mx> wrote:
>
> 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 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
>
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
@ 2006-01-11 14:25 ` Frank Bax <fbax@sympatico.ca>
2006-01-11 14:33 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
1 sibling, 1 reply; 15+ messages in thread
From: Frank Bax @ 2006-01-11 14:25 UTC (permalink / raw)
To: pgsql-php
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.
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
2006-01-11 14:25 ` Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
@ 2006-01-11 14:33 ` Rafael Mora <moraloco@gmail.com>
2006-01-11 16:03 ` Re: PHP and PostgreSQL connection Joshua D. Drake <jd@commandprompt.com>
2006-01-11 17:54 ` Re: PHP and PostgreSQL connection operationsengineer1@yahoo.com
0 siblings, 2 replies; 15+ messages in thread
From: Rafael Mora @ 2006-01-11 14:33 UTC (permalink / raw)
To: Frank Bax <fbax@sympatico.ca>; +Cc: pgsql-php
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 <fbax@sympatico.ca> 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
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
2006-01-11 14:25 ` Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 14:33 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
@ 2006-01-11 16:03 ` Joshua D. Drake <jd@commandprompt.com>
1 sibling, 0 replies; 15+ messages in thread
From: Joshua D. Drake @ 2006-01-11 16:03 UTC (permalink / raw)
To: Rafael Mora <moraloco@gmail.com>; +Cc: Frank Bax <fbax@sympatico.ca>; pgsql-php
Rafael Mora wrote:
> 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...
More specifically, the PHP docs will help you. We are happy to help of
course but you should do a little research.
Sincerely,
Joshua D. Drake
>
> Rafa
>
>
> On 1/11/06, *Frank Bax* <fbax@sympatico.ca <mailto:fbax@sympatico.ca>>
> 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
>
>
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
2006-01-11 14:25 ` Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 14:33 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
@ 2006-01-11 17:54 ` operationsengineer1@yahoo.com
2006-01-11 18:20 ` Re: PHP and PostgreSQL connection operationsengineer1@yahoo.com
1 sibling, 1 reply; 15+ messages in thread
From: operationsengineer1@yahoo.com @ 2006-01-11 17:54 UTC (permalink / raw)
To: Rafael Mora <moraloco@gmail.com>; Frank Bax <fbax@sympatico.ca>; +Cc: pgsql-php
> 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
Rafa, welcome! since i didn't hear this mentioned,
what operating system and version are you using -
Linux, Windows or Mac? I have a reasonably thorough
apache, php and pgsql isntall tutorial for winxp i'd
be glad to share if it is relevant to your case.
good luck.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
2006-01-11 14:25 ` Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 14:33 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
2006-01-11 17:54 ` Re: PHP and PostgreSQL connection operationsengineer1@yahoo.com
@ 2006-01-11 18:20 ` operationsengineer1@yahoo.com
2006-01-11 18:49 ` Re: PHP and PostgreSQL connection operationsengineer1@yahoo.com
0 siblings, 1 reply; 15+ messages in thread
From: operationsengineer1@yahoo.com @ 2006-01-11 18:20 UTC (permalink / raw)
To: operationsengineer1@yahoo.com, Rafael Mora <moraloco@gmail.com>; Frank Bax <fbax@sympatico.ca>; +Cc: pgsql-php
> > 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
>
> Rafa, welcome! since i didn't hear this mentioned,
> what operating system and version are you using -
> Linux, Windows or Mac? I have a reasonably thorough
> apache, php and pgsql isntall tutorial for winxp i'd
> be glad to share if it is relevant to your case.
>
> good luck.
>
i had a request to post the winxp apache, php and
postrgresql install instructions, so here goes...
http://www.geocities.com/operationsengineer1/
do feel free to provide feedback (good and/or bad). i
think it is close (and should get someone up and
running), but i'm sure it can be improved and i'd be
happy to do so if i get some feedback. of course, the
software versions may well have changed, so feel free
to apply the most up to date software in place of what
i used.
good luck.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:10 ` Re: PHP and PostgreSQL connection Javier Carlos <nediam@nediam.com.mx>
2006-01-11 14:25 ` Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 14:33 ` Re: PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
2006-01-11 17:54 ` Re: PHP and PostgreSQL connection operationsengineer1@yahoo.com
2006-01-11 18:20 ` Re: PHP and PostgreSQL connection operationsengineer1@yahoo.com
@ 2006-01-11 18:49 ` operationsengineer1@yahoo.com
0 siblings, 0 replies; 15+ messages in thread
From: operationsengineer1@yahoo.com @ 2006-01-11 18:49 UTC (permalink / raw)
To: operationsengineer1@yahoo.com, Rafael Mora <moraloco@gmail.com>; Frank Bax <fbax@sympatico.ca>; +Cc: pgsql-php
if the downloads reach their bandwidth limit, try back
later. i will not be taking them down anytime soon.
as a courtesy to others, though, it would be best to
download apache, get it set up, download php, get it
set up, download pgsql and get it set up.
that way the badwidth will be spread out and more
people will be able to get started.
again, please give feedback - good, bad or ugly. i'd
like to keep improving the documents.
> i had a request to post the winxp apache, php and
> postrgresql install instructions, so here goes...
>
> http://www.geocities.com/operationsengineer1/
>
> do feel free to provide feedback (good and/or bad).
> i
> think it is close (and should get someone up and
> running), but i'm sure it can be improved and i'd be
> happy to do so if i get some feedback. of course,
> the
> software versions may well have changed, so feel
> free
> to apply the most up to date software in place of
> what
> i used.
>
> good luck.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: PHP and PostgreSQL connection
@ 2006-01-11 17:09 Eustache Safari <eustache.safari@vodacom.cd>
0 siblings, 0 replies; 15+ messages in thread
From: Eustache Safari @ 2006-01-11 17:09 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; Rafael Mora <moraloco@gmail.com>; +Cc: Frank Bax <fbax@sympatico.ca>; pgsql-php
Rafael,
Open source is :
1. read docs from the software.
2. If you can't find an answer, then you Google it...
3. lastly, people on the distribution will assist.
From your Project, you'll get more benefit by "trying it your self
first". Especially while you're learning.
Regards
-----Original Message-----
From: pgsql-php-owner@postgresql.org
[mailto:pgsql-php-owner@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Wednesday, January 11, 2006 5:03 PM
To: Rafael Mora
Cc: Frank Bax; pgsql-php@postgresql.org
Subject: Re: [PHP] PHP and PostgreSQL connection
Rafael Mora wrote:
> 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...
More specifically, the PHP docs will help you. We are happy to help of
course but you should do a little research.
Sincerely,
Joshua D. Drake
>
> Rafa
>
>
> On 1/11/06, *Frank Bax* <fbax@sympatico.ca <mailto:fbax@sympatico.ca>>
> 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
>
>
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 15+ messages in thread
end of thread, other threads:[~2006-01-11 18:49 UTC | newest]
Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-11 12:31 PHP and PostgreSQL connection Rafael Mora <moraloco@gmail.com>
2006-01-11 12:48 Re: PHP and PostgreSQL connection Frank Bax <fbax@sympatico.ca>
2006-01-11 13:01 ` Rafael Mora <moraloco@gmail.com>
2006-01-11 13:10 ` Javier Carlos <nediam@nediam.com.mx>
2006-01-11 13:17 ` Rafael Mora <moraloco@gmail.com>
2006-01-11 13:41 ` seem.iges@mail.ee
2006-01-11 13:55 ` Javier Carlos <nediam@nediam.com.mx>
2006-01-11 14:14 ` Rafael Mora <moraloco@gmail.com>
2006-01-11 14:25 ` Frank Bax <fbax@sympatico.ca>
2006-01-11 14:33 ` Rafael Mora <moraloco@gmail.com>
2006-01-11 16:03 ` Joshua D. Drake <jd@commandprompt.com>
2006-01-11 17:54 ` operationsengineer1@yahoo.com
2006-01-11 18:20 ` operationsengineer1@yahoo.com
2006-01-11 18:49 ` operationsengineer1@yahoo.com
2006-01-11 17:09 Re: PHP and PostgreSQL connection Eustache Safari <eustache.safari@vodacom.cd>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox