Beginning PHP5, Apache, and MySQL Web Development -- About the Authors -- Credits -- Contents -- Part I: Getting Started -- Chapter 1: Configuring Your Installation -- Projects in This Book -- Brief Intro to PHP, Apache, MySQL, and Open Source -- How the Pieces of the AMP Module Work Together -- Configuring Your Apache Installation -- Configuring Your PHP Installation -- Configuring Your MySQL Installation -- Where to Go for Help and Other Valuable Resources -- Summary -- Part II: Movie Review Web Site -- Chapter 2: Creating PHP Pages Using PHP5 -- Overview of PHP Structure and Syntax -- Creating Your First Program -- Using HTML to Spice Up Your Pages -- Using Constants and Variables to Add Functionality -- Passing Variables between Pages -- Using if/else Arguments -- Using Includes for Efficient Code -- Using Functions for Efficient Code -- All About Arrays -- While You're Here . . . -- Alternate Syntax for PHP -- OOP Dreams -- Summary -- Exercises -- Chapter 3: Using PHP5 with MySQL -- Overview of MySQL Structure and Syntax -- How PHP Fits with MySQL -- Connecting to the MySQL Server -- Looking at a Ready-Made Database -- Querying the Database -- Helpful Tips and Suggestions -- Summary -- Exercises -- Chapter 4: Using Tables to Display Data -- Creating a Table -- Populating the Table -- Who's the Master? -- A Lasting Relationship -- Summary -- Exercises -- Chapter 5: Form Elements: Letting the User Work with Data -- Your First Form -- Driving the User Input -- Using Form Elements Together -- Summary -- Exercises -- Chapter 6: Letting the User Edit the Database -- Preparing the Battlefield -- Inserting a Simple Record from phpMyAdmin -- Inserting a Record in a Relational Database -- Deleting a Record -- Editing Data in a Record -- Summary -- Exercise -- Chapter 7: Manipulating and Creating Images with PHP -- Working with the GD Library.

Allowing Users to Upload Images -- Converting Image File Types -- Black and White -- Adding Captions -- Adding Watermarks and Merging Images -- Creating Thumbnails -- Summary -- Exercises -- Chapter 8: Validating User Input -- Users Are Users Are Users . . . -- Incorporating Validation into the Movie Site -- Forgot Something? -- Checking for Format Errors -- Summary -- Exercise -- Chapter 9: Handling and Avoiding Errors -- How the Apache Web Server Deals with Errors -- Error Handling and Creating Error Handling Pages with PHP -- Other Methods of Error Handling -- Summary -- Exercises -- Part III: Comic Book Fan Site -- Chapter 10: Building Databases -- Getting Started -- Designing Your Database -- Creating a Database in MySQL -- Creating the Comic Character Application -- Summary -- Exercises -- Chapter 11: Sending E-mail -- Setting Up PHP to Use E-mail -- Sending an E-mail -- Dressing Up Your E-mails with HTML -- Storing Images -- Getting Confirmation -- Creating a Reusable Mail Class -- Summary -- Exercises -- Chapter 12: User Logins, Profiles, and Personalization -- The Easiest Way to Protect Your Files -- Friendlier Logins Using PHP's Session and Cookie Functions -- Using Database-Driven Information -- Summary -- Exercises -- Chapter 13: Building a Content Management System -- Getting Your Users to Return -- Preparing the Database -- Coding for Reusability -- Transaction Pages -- User Interface -- Summary -- Exercises -- Chapter 14: Mailing Lists -- What Do You Want to Send Today? -- Coding the Administration Application -- Sign Me Up! -- Mailing List Ethics -- Summary -- Exercises -- Chapter 15: Online Stores -- Adding E-Commerce to the Comic Book Fan Site -- E-Commerce, Any Way You Slice It -- Summary -- Exercises -- Chapter 16: Creating a Bulletin Board System -- Your Bulletin Board -- Preparing the Database -- Reusable Code.

Transaction Pages -- Account Functionality -- Forum Functionality -- Afterthoughts -- Summary -- Exercises -- Chapter 17: Using Log Files to Improve Your Site -- Locating Your Logs -- Analyzing Your Log Data -- Putting the Analysis to Work -- Summary -- Chapter 18: Troubleshooting -- Installation Troubleshooting -- Parse Errors -- Empty Variables -- "Headers Already Sent" Error -- General Debugging Tips -- Where to Go for Help -- Summary -- Appendix A: Answers to Exercises -- Appendix B: PHP Quick Reference -- Appendix C: PHP5 Functions -- Appendix D: MySQL Data Types -- Appendix E: MySQL Quick Reference -- Appendix F: Comparison of Text Editors -- Appendix G: Choosing a Third-Party Host -- Appendix H: An Introduction to PEAR -- Appendix I: AMP Installation -- Index.