Connecting with PHP???

You use the pg_connect function. You can look it up in the on-line php documentation.


That is a php users best friend.

Houston, we have lift off!!!

I connected and inserted a record! Woo-Who!

Could you recommend any books to help with working with both PHP/PostgreSQL databases???

As you can see, I am just starting with both of these. My background is mainly VB/VBA and some PL/SQL...

Thanks again.

The postgresql docs that you can download and the mailing lists are great.

The php on line manual as I mentioned is great.

I have a book "PHP and PostgreSQL Advanced Web Programming" put out by SAMS. (ISBN 0-672-32382-6) It is o.k. I think they churned out a lot of stuff that was not all that necessary as relates to installing and setting up PostgreSQL. They didn't add anything that wasn't in the docs.

Dev Shed has some excellent tutorials on PHP and a few that are specifically PHP and postgresql. They are available to download in a printer friendly format and I have found them to be very useful.

I come from a VB, SQL Server background doing 2 tier distributed apps- not web stuff. I've found that the transition has not been too difficult. My books have been nice but the mailing lists and web sites provide me w/my primary sources of information.

The wrox book "Beginning Databases with PostgreSQL" (ISBN 1-861005-15-6) is also o.k. Pretty basic (but that is in the title so I expected it) It does help get the ball rolling.

The main postgresql site (I think puts you at a list of mirrors) will hook you up with tons of info. Many of the main developers are very active on the mailing lists. They go way above and beyond to help people diagnose and fix problems. It's a great community and an excellent product.

My opinion of the PostgreSQL docs is mixed.

The best book I recommend strongly is...

"PostgreSQL Developers Handbook"

Seriously now, in my opinion, this book is excellent. Its content is not nearly exhaustive, but it does provide good explanations, tips, and examples. It got me out of some tough situations when I was clueless.

GO POSTGRESQL!

Gary
gwinn7
A+, N+, I+

Thanks for the suggestion. Does this book have good examples(real world) and go into detail on "The reasons why..."?

Many of the books I've read reviews on or thumbed through at the store and making pretty big leaps in assuming knowledge about PHP/PostgreSQL. Again, I am just trying to get my foot in the door in this area.

Yes, its very 'real-world' oriented. I am not sure how advanced you are in database knowledge, but it will require that you be familiar with database terms and DBMS systems. This book takes you through product history, installation, setup and tuning, to programming its interfaces. Like I stated before, its not meant as an exhaustive reference. Its truly a practical guide to this ORDBMS (postgreSQL).

Hope that helps...

Gary
gwinn7
A+, N+, I+