Fully updated to reflect the most recent developments in PHP and MySQL, Sams Teach Yourself PHP, MySQL and Apache All in One, Third Edition combines these most popular open source Web development tools into a complete book, packaged with one easy-to-use Starter Kit CD. This book teaches the reader to install, configure and set up the PHP scripting language, the MySQL database system, and the Apache Web server. By the end of this book the reader will understand how these technologies work, and more importantly, how they work together to create a dynamic Web site. After creating a simple Web site using these tools, the reader will be able to manage a simple mailing list, and to create an online address book, shopping cart, and storefront. Sams Teach Yourself PHP, MySQL and Apache All in One, Third Edition also teaches the reader how to fine-tune Apache and MySQL, and covers simple Web server security.

• Laying the Groundwork
  • Installation QuickStart Guide
  • Installing and Configuring MySQL
  • Installing and Configuring Apache
  • Installing and Configuring PHP
• PHP Language Structure
  • The Building Blocks of PHP
  • Flow Control Functions in PHP
  • Working with Functions
  • Working with Arrays
  • Working with Objects
• Getting Involved with the Code
  • Working with Strings, Dates, and Time
  • Working with Forms
  • Working with Cookies and User Sessions
  • Working with Files and Directories
  • Working with Images
• PHP and MySQL Integration
  • Understanding the Database Design Process
  • Learning Basic SQL Commands
  • Using Transactions and Stored Procedures in MySQL
  • Interacting with MySQL Using PHP
• Basic Projects
  • Managing a Simple Mailing List
  • Creating an Online Address Book
  • Creating a Simple Discussion Forum
  • Creating an Online Storefront
  • Creating a Shopping Cart Mechanism
  • Creating a Simple Calendar
  • Restricting Access to Your Applications
  • Logging and Monitoring Web Server Activity
  • Application Localization
  • Working with XML
  • Apache Performance Tuning and Virtual Hosting
  • Setting Up a Secure Web Server
  • Optimizing and Tuning MySQL
  • Software Upgrades