Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmore’s authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Workbench, and much more. 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. Gilmore has seven years of experience working with these technologies, and he has packed 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. What you’ll learn How to install and configure Apache, PHP 5.3, and MySQL PHP and object-oriented programming basics New PHP 5.3 features and how to use them How to move beyond basic PHP, including using the Zend Framework How to use MySQL to securely store your website's data How to use MySQL Workbench to manage your database Who this book is for Developers who want to harness PHP and MySQL to create powerful web applications Table of Contents Introducing PHP Configuring Your Environment 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 Date and Time Forms Authenticating Your Users Handling File Uploads Networking PHP and LDAP Session Handlers Templating with Smarty Web Services Secure PHP Programming SQLite Building Web Sites for the World MVC and the Zend Framework Introducing MySQL Installing and Configuring MySQL The Many MySQL Clients MySQL Storage Engines and Datatypes Securing MySQL Using PHP with MySQL Introducing PDO Stored Routines MySQL Triggers MySQL Views Practical Database Queries Indexes and Searching Transactions Importing and Exporting Data