Thread: Perl or PHP DB Access?
I did a search in the subjects for perl or php and only found one, asking if there was a php book . . . . What I'm trying to find is either a Perl or PHP way to connect to and access a postgres database. If there were some simple examples somewhere I would really appreciate finding them. I want to look into web based Postgres database applications. Thanks very much for your help. Paul -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
My site might be able to help you: http://pgsql.designmagick.com/ There's a fair bit of (hopefully) useful info on using PostgreSQL and PHP :) > I did a search in the subjects for perl or php and only found one, asking if > there was a php book . . . . What I'm trying to find is either a Perl or > PHP way to connect to and access a postgres database. If there were some > simple examples somewhere I would really appreciate finding them. I want to > look into web based Postgres database applications. > Thanks very much for your help. > Paul > > > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- >
http://pgsql.designmagick.com/tutorial.php cheers, --thalis On Thu, 14 Feb 2002, p s wrote: > I did a search in the subjects for perl or php and only found one, asking if > there was a php book . . . . What I'm trying to find is either a Perl or > PHP way to connect to and access a postgres database. If there were some > simple examples somewhere I would really appreciate finding them. I want to > look into web based Postgres database applications. > Thanks very much for your help. > Paul > > > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
Hi Paul, for Perl always look at CPAN http://www.cpan.org The DBI and DBD::Pg will be your friends. Actually DBI is easy to use and DBD::Pg (DBI Database connector to Postgres) works flawless. Regards Ulli
On Thu, 14 Feb 2002, p s wrote: > I did a search in the subjects for perl or php and only found one, > asking if there was a php book . . . . What I'm trying to find is > either a Perl or PHP way to connect to and access a postgres database. > If there were some simple examples somewhere I would really appreciate > finding them. I want to look into web based Postgres database > applications. Thanks very much for your help. Paul For Perl see DBI/DBD. Its a kind if a construction set. You need DBI and then for every database a DBD. For Perl I use DBD-Pg-0.95 and DBI-1.13. PHP is nice, too. Maybe a bit simpler for Web-Pages. PHP comes with HTML docs. You find there a section about the postgres functions.
You can also find instructions on building Apache, PHP and sample code on accessing PostgreSQL database at: http://www.redhat.com/support/resources/howto/database/database_php/ Hope this helps! Permaine > I did a search in the subjects for perl or php and only found one, asking if > there was a php book . . . . What I'm trying to find is either a Perl or > PHP way to connect to and access a postgres database. If there were some > simple examples somewhere I would really appreciate finding them. I want to > look into web based Postgres database applications. > Thanks very much for your help. > Paul > > > > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- >
At 08:25 PM 2/14/02 -0600, p s wrote: >I did a search in the subjects for perl or php and only found one, asking if >there was a php book . . . . What I'm trying to find is either a Perl or >PHP way to connect to and access a postgres database. If there were some >simple examples somewhere I would really appreciate finding them. I want to >look into web based Postgres database applications. >Thanks very much for your help. >Paul For Perl try the DBI and DBD modules. The perldocs are good enough for the perl side of things. Link.