Beginning PHP and MySQL 5: From Novice to Professional (Beginning Series: Open Source) - Paperback

Beginning PHP 5 and MySQL 5: From Novice to Professional, Second Edition, offers a comprehensive guide 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 5, which is MySQL's most significant release to date, this second edition shows readers how to take advantage of both technologies to build powerful, manageable, and stable web applications. Essentially three books in one, the second edition includes comprehensive discussions about PHP 5, MySQL 5, and demonstrates how these two popular open source technologies work together to create powerful websites. The book is packed with practical examples and insight into the real-world challenges faced by developers. Based on the author's seven years experience working with these technologies, readers will repeatedly return to this book as a valuable instructional tool and reference guide. TOC:An Introduction to PHP.- Installing and Configuring PHP.- PHP Basics.- Functions.- Arrays.- Object-Oriented PHP.- Advanced OOP Features.- Error and Exception Handling.- Strings and Regular Expressions.- Working with the File and Operating System.- PEAR.- Forms and Navigational Cues.- Authentication.- Handling File Uploads.- Networking with PHP.- PHP and LDAP.- Session Handlers.- Templating with Smarty.- Web Services.- Secure PHP Programming.- SQLite.- Introducing MySQL.- Installing and Configuring MySQL.- MySQL Administration.- The Many MySQL Clients.- MySQL Table Structures and Datatypes.- Securing MySQL.- PHP's mysql Library.- PHP's mysqli Library.- Stored Procedures.- Triggers.- Views.- Practical Database Queries.- Indexes and Searching.- Transactions.- Importing and Exporting Data.