Beginning PHP and MySQL: From Novice to Professional-repost

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
Integrating jQuery and PHP
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