Beginning PHP and PostgreSQL 8: From Novice to Professional / Edition 1

Paperback (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
  • All (15) from $1.99   
  • New (8) from $31.99   
  • Used (7) from $1.99   


Beginning PHP and PostgreSQL 8 delves into some of the most popular open-source web development technologies, the PostgreSQL 8 database server and PHP 5 scripting language. You’ll learn to reap the benefits of these core technologies by using them in unison to create dynamic, data-driven web applications. This is an ideal read if you are a web designer, programmer, hobbyist, or novice who wants to create applications with PHP 5 and PostgreSQL 8.

Read More Show Less

Product Details

  • ISBN-13: 9781590595473
  • Publisher: Apress
  • Publication date: 3/2/2006
  • Series: Beginning: from Novice to Professional Series
  • Edition description: 2006
  • Edition number: 1
  • Pages: 892
  • Product dimensions: 7.00 (w) x 9.10 (h) x 1.80 (d)

Meet the Author

W. Jason Gilmore is a web developer and business consultant with more than 15 years of experience helping companies large and small build amazing software solutions. He has been teaching developers from around the world about web development for over a decade, having written six books, including the bestselling Beginning PHP and MySQL, Fourth Edition and Easy PHP Websites with the Zend Framework, Second Edition .

Over the years Jason has been published more than 300 times within popular publications such as,, JSMag, and Linux Magazine, and instructed hundreds of students in the United States and Europe. He s recently led the successful development and deployment of a 10,000+ product e-commerce project, and is currently working on a variety of new e-commerce initiatives. Jason is cofounder of the wildly popular CodeMash Conference, the largest multi-day developer event in the Midwest.

Robert H. Treat is a longtime open source user, developer, and advocate. He is helping to maintain the websites, working on phpPgAdmin, and contributing to the PostgreSQL core. He has contributed several articles to the PostgreSQL "techdocs" site, was a two-time presenter at O'Reilly's Open Source Convention, worked as the PHP Foundry administrator on, and has been recognized as a "Major Developer" for his work within the PostgreSQL community.

Read More Show Less

Table of Contents

Ch. 1 An introduction to PHP 1
Ch. 2 Installing and configuring apache and PHP 9
Ch. 3 PHP basics 43
Ch. 4 Functions 91
Ch. 5 Arrays 103
Ch. 6 Object-oriented PHP 133
Ch. 7 Advanced OOP features 157
Ch. 8 Error and exception handling 177
Ch. 9 Strings and regular expressions 191
Ch. 10 Working with the file and operating system 229
Ch. 11 PEAR 259
Ch. 12 Date and time 271
Ch. 13 Forms and navigational cues 303
Ch. 14 Authentication 325
Ch. 15 Handling file uploads 345
Ch. 16 Networking 359
Ch. 17 PHP and LDAP 399
Ch. 18 Session handlers 425
Ch. 19 Templating with smarty 447
Ch. 20 Web services 473
Ch. 21 Secure PHP programming 515
Ch. 22 SQLite 535
Ch. 23 Introducing PDO 555
Ch. 24 Introducing PostgreSQL 573
Ch. 25 Installing PostgreSQL 579
Ch. 26 PostgreSQL administration 593
Ch. 27 The many PostgreSQL clients 611
Ch. 28 From database to datatypes 625
Ch. 29 Securing PostgreSQL 649
Ch. 30 PHP's PostgreSQL functionality 665
Ch. 31 Practical database queries 689
Ch. 32 Views and rules 707
Ch. 33 PostgreSQL functions 719
Ch. 34 PostgreSQL triggers 739
Ch. 35 Indexes and searching 749
Ch. 36 Transactions 765
Ch. 37 Importing and exporting data 777
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted February 22, 2008


    Are you a professional or novice to PHP and PostgreSQL 8? If you are, then this book is definitely for you. Authors W. Jason Gilmore and Robert H. Treat, have done an outstanding job of writing a book that offers users an impressive platform for building high-powered Web applications. Gilmore and Treat, begin by acquainting you with the basics of PHP offering insight into its roots, popularity, and users. Then, the authors show you how to install and configure PHP, as well as, the Apache Web server. Next, they cover the various aspects from the basics of the PHP language and class libraries to topics like authentication, security, session handlers and e-mail functionality. The authors also focus on PHP Extension and Application Repository (PEAR). They continue by addressing PostgreSQL, including tables and data types, views, functions, indexes and triggers. Then, the authors present the more pertinent PHP functionality to access PostgreSQL. Next, they show you how to install and configure your local test bed. The authors continue by describing the server strain that PG can handle. Then, they show you how to use Smarty and PearDB. Next, the authors also cover the integration between PostgreSQL and PHP the interface with PostgreSQL from PHP and how to write reusable queries. Finally, the authors go further by covering the installation and configuration of PostgreSQL. This most excellent book is not for beginners. Nevertheless, you will find plenty of tips and notes focusing shortcuts to complete both new and familiar tasks.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)