Обсуждение: Re: Having tough time getting php working for postgresql..

Hello,

I was having trouble with setting up php-pgsql, but I think I have it
up and running. Before I attempt to move forward with attempting to
code without knowing if the environment is setup correctly, does
anybody know what exactly I am looking for in the phpinfo() tables. I
did a find for pgsql, postgre, etc. and didn't find anything.

I am running Windows XP Pro, Apache 2, PHP 5.1.1, PostgreSQL 8.0.

Thank you in advance.

Patrick

On 1/10/06, Sherwin M. Harris <Sherwin_Harris@byu.edu> wrote:
>
>
>
> Do NOT uninstall. The package you need to install is called php-pgsql. You
> should be able to do a (as root of course or sudo if that is set up)
>
> Yum install php-pgsql
>
> Restart apache and you are good to go.
>
> Sherwin Harris
>
>
>
>  ________________________________
>
>
> From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org]
> On Behalf Of manjusri schuit
>  Sent: Tuesday, January 10, 2006 7:05 AM
>  To: Jeff MacDonald
>  Cc: Jagan Reddy; pgsql-php@postgresql.org
>  Subject: Re: [PHP] Having tough time getting php working for postgresql..
>
>
>
>
> Hello
>  form the php site--
>
>  In order to enable PostgreSQL support, --with-pgsql[=DIR] is required when
> you compile PHP. DIR is the PostgreSQL base install directory, defaults to
> /usr/local/pgsql. If shared object module is available, PostgreSQL module
> may be loaded using extension directive in php.ini or dl() function.
>
>  The default php instalations on most linux distro's don't come with
> postgresql enabled !
>  So you need to unistall the default php version first.
>
>
>
>
> On 1/10/06, Jeff MacDonald <jam@zoidtechnologies.com> wrote:
>
> greetings,
>
>  On Mon, 2006-01-09 at 14:23 -0800, Jagan Reddy wrote:
>  > Hello,
>  > I have successfully compiled and installed postgresql 8.1.1. I have
>  > created some databases as well.
>  > But I want to get php working with pgsql so that I can do some web
>  > develoement.
>  >
>  > Whatever rpms I get and insall, it is still complaining for another.
>  > I believe I have PHP 4.3.9 and I tried here to insall php-pgsql4.3.9.
>  > No luck.
>  >
>  > I am still running the default PHP installed by RedHat linux
>  > installaion process.  I have not removed and installed source code
>  > based PHP though.
>  >
>  > Thanks
>  > Jagan Reddy
>  >
>
>  what version of redhat are you using?
>
>  what version of the php rpm to do you have installed? (use 'rpm -q php'
>  to check)
>
>  regards,
>  J
>  --
>  Jeff MacDonald
>  Zoid Technologies, http://zoidtechnologies.com/
>
>
>  ---------------------------(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
>
>
>
>
>  --
>  Met vriendelijke groet
>  Manjusri Schuit

Am Mittwoch, 11. Januar 2006 18:35 schrieb Patrick White:
> Hello,
>
> I was having trouble with setting up php-pgsql, but I think I have it
> up and running. Before I attempt to move forward with attempting to
> code without knowing if the environment is setup correctly, does
> anybody know what exactly I am looking for in the phpinfo() tables. I
> did a find for pgsql, postgre, etc. and didn't find anything.

you should find "pgsql" (look at the configuration parameters in
http://www.php.net/manual/en/ref.pgsql.php ; they should be listed)

> I am running Windows XP Pro, Apache 2, PHP 5.1.1, PostgreSQL 8.0.

Consult http://www.php.net/manual/en/ref.pgsql.php
Maybe you have to add the libary in your php.ini file

kind regards
janning

Thank you for the quick reply. I was actually able to get it up and
running. It is always as soon as you hit the send button when the
light bulb goes off. The issue I was having was that I didn't realise
the order of which the server will look for the php.ini file (I
thought it was simply looking in the PATH directories), such as the
list I will provide for future reference:

     1.PHPIniDir directive (Apache 2 module only)
     2.HKEY_LOCAL_MACHINE\SOFTWARE\PHP\IniFilePath
     3. The PHPRC environment variable
     4. Directory of PHP (for CLI), or the web server's directory (for
       SAPI modules)
     5. Windows directory (C:\windows or C:\winnt)

My problem was that Apache was set to look in a directory that
contained a completly default php.ini file.

Thanks again, and I apologize for the premature post.

Patrick

---------- Forwarded message ----------
From: Janning Vygen <vygen@gmx.de>
Date: Jan 11, 2006 1:00 PM
Subject: Re: [PHP] Having tough time getting php working for postgresql..
To: pgsql-php@postgresql.org
Cc: Patrick White <ptothew@gmail.com>


Am Mittwoch, 11. Januar 2006 18:35 schrieb Patrick White:
> Hello,
>
> I was having trouble with setting up php-pgsql, but I think I have it
> up and running. Before I attempt to move forward with attempting to
> code without knowing if the environment is setup correctly, does
> anybody know what exactly I am looking for in the phpinfo() tables. I
> did a find for pgsql, postgre, etc. and didn't find anything.

you should find "pgsql" (look at the configuration parameters in
http://www.php.net/manual/en/ref.pgsql.php ; they should be listed)

> I am running Windows XP Pro, Apache 2, PHP 5.1.1, PostgreSQL 8.0.

Consult http://www.php.net/manual/en/ref.pgsql.php
Maybe you have to add the libary in your php.ini file

kind regards
janning

> Hello,
>
> I was having trouble with setting up php-pgsql, but
> I think I have it
> up and running. Before I attempt to move forward
> with attempting to
> code without knowing if the environment is setup
> correctly, does
> anybody know what exactly I am looking for in the
> phpinfo() tables. I
> did a find for pgsql, postgre, etc. and didn't find
> anything.
>
> I am running Windows XP Pro, Apache 2, PHP 5.1.1,
> PostgreSQL 8.0.
>
> Thank you in advance.
>
> Patrick

1. test for the apache test page (prior to php
install).
2. test that phpinfo() displays (after php install).
3. edit->find to search for "sql" until you find the
reference to postgresql.  it should tell you what
version you are using.  of course, this is after pgsql
has been installed.

i also discuss how to use pgadminIII to test that
pgsql is working in the link to the install
instructions i posted earlier today.

once you get everything set up, you may want to
consider a db abstraction layer (i use adodb and find
it quite robust) and a forms generation and validation
class (i use manuel lemos' from phpclasses.org).  it
is also very nice.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com