* Offering a native Windows release, PostgreSQL 8.0 is poised to garner considerable market share in the open source arena. This book shows readers how to harness this popular open source database with PHP, the world’s most popular web scripting language. * Essentially three books in one, PostgreSQL 8.0 exposes readers to detailed introductions of PHP and PostgreSQL. Readers gain extensive knowledge about these two popular open source technologies to create powerful websites. * Authored by W. Jason Gilmore, author of the best selling Beginning PHP 5 and MySQL: From Novice to Professional, and noted PostgreSQL developer and community liaison Robert Treat.

Beginning PHP and MySQL: From Novice to Professional, Third Edition offers a comprehensive introduction to two of the most prominent open-source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQL's most significant release to date, readers will learn how to take advantage of the features of both technologies to build powerful, manageable, and stable web applications. Essentially three books in one, readers will not only profit from extensive introductions to the core features of each technology, but also learn how to effectively integrate the two in order to build robust data-driven applications. Packed with practical examples and insight into the real-world challenges faced by developers based on author W. Jason Gilmore's seven years of expertise working with these technologies, readers will repeatedly return to this book as both a valuable instructional tool and reference guide. What you’ll learn The PHP language How to back your web site with MySQL Templating so that you can apply a consistent design across all pages on your site How to authenticate your web site users How to use cookies to maintain information (such as items in a shopping cart) while a user is browsing your site Who this book is for This book is written for developers seeking to take advantage of the PHP language and MySQL database to create powerful web applications.

The first book to show readers how to create a complete e-commerce driven website using two of the most popular open source technologies, PHP and PostgreSQL Adapted from the strong selling Beginning PHP 5 and MySQL E-Commerce, this book is based on a proven and popular instructional model. PostgreSQL, long the second most popular open source database in the world, has seen a significant resurgence in interest throughout 2005 due to software enhancements and considerable capital injections. It stands to reason already strong interest in this database will continue to grow for the foreseeable future.

"Introduction. 1. Pt. I. Getting Started. 3. 1. Getting Started. 5. 2. Setting Up PHP. 15. 3. PHP Basics. 43. 4. Object-Oriented PHP. 121. Pt. II. Getting Started with PostgreSQL. 137. 5. Relational and Object-Relational Database Concepts. 139. 6. Installing PostgreSQL. 149. 7. Basic SQL. 177. 8. Advanced SQL. 225. 9. Embedded Languages. 307. 10. PostgreSQL Administration. 349. Pt. III. PHP/PostgreSQL Interaction. 379. 11. Writing Database-Driven Applications. 381. 12. Working with BLOBs. 405. 13. Working with Persistent Database Connections. 423. Pt. IV. Advanced Technologies. 433. 14. Managing Regular Expressions. 435. 15. Session Management. 463. 16. Working with Dynamic Documents, Images, and Movies. 475. 17. Working with Dates and Time. 521. 18. Tuning. 551. 19. XML. 573. 20. Security Issues. 585. Pt. V. Practical Examples. 597. 21. Web Applications. 599. 22. Extending PostgreSQL. 669. 23. High-Availability Systems. 695. Pt. VI. Migration. 709. 24. Migration. 711. . Index. 721.

*The most updated PostgreSQL book on the market, covering version 8.0 *Highlights the most popular PostgreSQL APIs, including C, Perl, PHP, and Java *This is two books in one; it simultaneously covers key relational database design principles, while teaching PostgreSQL

Beginning PHP and MySQL: From Novice to Professional, Fifth Edition is a major update of W. Jason Gilmore's authoritative book on PHP and MySQL. The latest edition includes detailed instructions for configuring the ultimate PHP and MySQL development environment on all major platforms, complete coverage of the latest additions and improvements to the PHP language, coverage of the Composer dependency manager, and thorough introductions to MySQL’s most relied-upon features. You'll not only receive extensive introductions to the core features of PHP, MySQL, and related tools, but you'll also learn how to effectively integrate them in order to build robust data-driven applications. Authors Jason Gilmore and Massimo Nardone draw upon more than fifteen years of experience working with these technologies to pack this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide. Some of the book’s highlights include: Detailed instructions regarding installing PHP, MySQL and several popular web servers A thorough introduction to the PHP language, including its string handling, networking, forms processing, and object-oriented features An extensive overview of MySQL’s fundamental features, including supported data types, database management syntax, trigger, view, stored routine syntax, and import/export capabilities Hundreds of examples demonstrating countless facets of PHP and MySQL integration