PHP4 and PostGresql

Anon

Hi,

I am new to PHP and am having the following problem:

I have PHP and Apache working, i.e. the standard Hello World examples work. When I try to use pg_pconnect(blah, blah); I get an error message saying the the function pg_pconnect is undefined. I have compiled PHP with the --with-pgsql option, what am i doing wrong and how do I find out if my compile worked properly....

Brett

Anon

I don't know how you've got things set up, but it's possible
you have compiled the pgsql support as a loadable module,
in which case you will need to load it.

There are several ways to do this. If your site uses the pg_*
stuff extensively then you probably want to put

extension=pgsql.so

in your php.ini script. Otherwise, you just need to stick something like <?php dl(pgsql.so); ?> in your page.

Anon

Hi, Drew

Thanks for your input I did need to check php.ini, but I found that my mistake was compiling php with the pgsql parameter pointing at the binaries files instead of the source, got it all working now.

Brett.

Anon

Brett,

I am having the exact same problem you had. I have php4.0.3 and apache_1.3.14 installed on freeBSD 4.2. The "Hello world" test
program works. Compiled php and apache with
pgsql option. when I tried to connect to postgresql it says pg_connect() undefined.

In your follow-up message, you said you got
it all working. It would be appreciated if you can let me how you got the problem solved.

Thanks,

Yaodong

Anon

Hi Yaodong,

My problem was that I had compiled php with the --with-pgsql directory path set to the binary files, it should be set to the source file path (/usr/src/postgresxxxx for example). The other thing to check is php.ini (default location /usr/local/lib/), make sure your paths and such are setup correctly.

Brett