PostGre Support in PHP

[embj]

I am trying to setup Postgre so I can test a few database files. I have it setup correctly but, how do I configure it for php usage? Thanks.

[embj]

Bump. Plz I am sure somebody has to use Postgre.

[qball]

I haven't, but you don't need to configure Postgre, you need to connect through PHP.

<?php
$dbconn = pg_connect ("dbname=mary");
//connect to a database named "mary"
$dbconn2 = pg_connect ("host=localhost port=5432 dbname=mary");
// connect to a database named "mary" on "localhost" at port "5432"
$dbconn3 = pg_connect ("host=sheep port=5432 dbname=mary user=lamb password=foo");
//connect to a database named "mary" on the host "sheep" with a username and password
$conn_string = "host=sheep port=5432 dbname=test user=lamb password=bar";
$dbconn4 = pg_connect ($conn_string);
//connect to a database named "test" on the host "sheep" with a username and password
?>

[embj]

Well, I installed Postgre and was going to setup phpbb on it and it said that php wasn't configured to support an installation with PostGre.

[qball]

Well, I installed Postgre and was going to setup phpbb on it and it said that php wasn't configured to support an installation with PostGre.

what said what wasn't installed properly???

regardless, can you access Postgre DB through any client?

http://www.phpbb.com/

as you are using their product, ask them?

I could be wrong, but PHP just app server, no special configs needed to access:

mysql,
Access,
ASA, sqlanywhere.

Haven't tried Oracle/DB2/SQLServer, but sure PHP can access them rather easily.

Sorry I can't help more.

[Praetorian]

PHP is just like any application. I can be compiled with or without support for certain programs. In the earlier vers of PHP, MySQL was by default enabled (this has changed. You must enable it yourself now). PostgreSQL was optional. You had to recompile PHP to add Postgres. On FreeBSD this is very easy to do.

cd /usr/ports/www/mod_php4
make distclean
make (choose postgres at option screen)
make install

I haven't done this on anothe other *nix box. I think you'll just have to grab the source and compile it with make -with-pgsql (after configure of course).

HTH (Hope This Helps)

-Praetorian

[qball]

PHP is just like any application. I can be compiled with or without support for certain programs.

Sure, we all recompile outlook to use different mailservers!

I had to recompile notepad so it could read *.java/*.html/*.css files!

PHP is app server.
postgree is DB server.

All versions of PHP (3+) I have used, already support mySQL and postgre, plus more... No need to recompile, much less reconfigure (some PHP settings may improve performance). If you can get PHP working properly thru web server, PHP working.

The DB is similar. You install and (maybe)configure DB, then access thru web server, or other client. Then DB working.

You get the above 2, PHP can access postgre DB.

phpbb is not an application, just PHP BB scripting package, that uses apps:

PHP
web server
DB server

and that(phpbb) where problem of post lies.

[Praetorian]

PHP is a scripting language, not an application. It is interpreted by Apache in the form of a module, and the language itself is very modular. Just like any Unix program, you can add or remove features. The default version of mod_php4 on FreeBSD 5.0 does not have PostgreSQL compiled in. You have to compile it yourself (the same is not true on Debian Woody). I'm assuming this may be the issue with whatever version of *nix embj is running on. Qball, please get more information about each Distro/OS and it's features before you go saying that a particular application contains support that it does not, by default.

Also, PostgreSQL is a relational database management system, not database server.

[qball]

PHP is a scripting language, not an application. It is interpreted by Apache...

what? if I have just Apache, can I 'execute' a PHP script?

PostgreSQL is a relational database management system, not database server.

define, exactly:
database management system
database server

what does each do?
===

http://www.postgresql.org/

"PostgreSQL, the worlds most advanced Open Source database software"

DBMS?

[Praetorian]

what? if I have just Apache, can I 'execute' a PHP script?

I also said in the form of a module. I'm not sure where that part got left out.

"PHP is an HTML-embedded scripting language. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated pages quickly." - PHP web site

mod_php4 = PHP Apache module on FreeBSD. PHP is separate from Apache. You need PHP installed on your system, and loaded by Apache before you can execute a PHP script on your web server.

define, exactly:
database management system
database server

what does each do?

Hmm...I've never seen any major DB refered to as a database server. I would call an database management system the database software that runs on a server. I would call a database server the computer on which the database software runs.

http://www.postgresql.org/
"PostgreSQL, the worlds most advanced Open Source database software"
DBMS?

Where do you see this? I see:
"PostgreSQL : The most advanced Open Source database system in the world"
on http://advocacy.postgresql.org/about/.

PostgreSQL is a RDBMS (Relational Database Management System).