Sitemap
Sams Teach Yourself PHP, MySQL and Apache All in One
Chapter 1. Installing and Configuring MySQL
Current and Future Versions of MySQL
Installing MySQL on Linux/Unix
Troubleshooting Your Installation
Introducing the MySQL Privilege System
Chapter 2. Installing and Configuring Apache
Current and Future Versions of Apache
Choosing an Installation Method
Installing Apache on Linux/Unix
Apache Configuration File Structure
Starting Apache for the First Time
Chapter 3. Installing and Configuring PHP
Current and Future Versions of PHP
Building PHP on Linux/Unix with Apache
Installing PHP Files on Windows
Part II: PHP Language Structure
Chapter 4. The Building Blocks of PHP
Chapter 5. Flow Control Functions in PHP
Code Blocks and Browser Output
Chapter 6. Working with Functions
Returning Values from User-Defined Functions
Saving State Between Function Calls with the static Statement
Testing for the Existence of a Function
Chapter 7. Working with Arrays and Objects
Part III: Getting Involved with the Code
Chapter 8. Working with Strings, Dates, and Times
Using Date and Time Functions in PHP
Accessing Form Input with User-Defined Arrays
Combining HTML and PHP Code on a Single Page
Using Hidden Fields to Save State
Sending Mail on Form Submission
Chapter 10. Working with User Sessions
Working with Session Variables
Passing Session IDs in the Query String
Destroying Sessions and Unsetting Variables
Chapter 11. Working with Files and Directories
Including Files with include()
Opening a File for Writing, Reading, or Appending
Writing or Appending to a File
Chapter 12. Working with the Server Environment
Opening Pipes to and from Processes Using popen()
Running Commands with system() or passthru()
Chapter 13. Working with Images
Understanding the Image-Creation Process
Necessary Modifications to PHP
Part IV: PHP and MySQL Integration
Chapter 14. Learning the Database Design Process
The Importance of Good Database Design
Chapter 15. Learning Basic SQL Commands
Learning the Table Creation Syntax
Selecting from Multiple Tables
Using the UPDATE Command to Modify Records
Frequently Used String Functions in MySQL
Using Date and Time Functions in MySQL
Chapter 16. Interacting with MySQL Using PHP
Chapter 17. Managing a Simple Mailing List
Developing the Subscription Mechanism
Developing the Mailing Mechanism
Chapter 18. Creating an Online Address Book
Planning and Creating the Database Tables
Creating the Record Addition Mechanism
Creating the Record Deletion Mechanism
Chapter 19. Creating a Simple Discussion Forum
Creating the Input Forms and Scripts
Displaying the Posts in a Topic
Chapter 20. Creating an Online Storefront
Planning and Creating the Database Tables
Displaying Categories of Items
Chapter 21. Creating a Shopping Cart Mechanism
Planning and Creating the Database Tables
Integrating the Cart with Your Storefront
Payment Methods and the Checkout Sequence
Chapter 22. Creating a Simple Calendar
Building a Simple Display Calendar
Chapter 23. Restricting Access to Your Applications
Apache Authentication Module Functionality
Using Apache for Access Control
Combining Apache Access Methods
Limiting Access Based on HTTP Methods
Restricting Access Based on Cookie Values
Chapter 24. Logging and Monitoring Web Server Activity
Standard Apache Access Logging
Logging Custom Information to a Database
Chapter 25. Application Localization
About Internationalization and Localization
Creating a Localized Page Structure
Part VI: Administration and Fine Tuning
Chapter 26. Apache Performance Tuning and Virtual Hosting
Chapter 27. Setting Up a Secure Web Server
Obtaining and Installing SSL Tools
Chapter 28. Optimizing and Tuning MySQL
Building an Optimized Platform
Optimizing Your Table Structure
Part VII: Looking Toward the Future
Chapter 30. Features and Backward Compatibility of PHP 5.0
So, When Should I Upgrade to PHP 5?
Chapter 31. Features and Backward Compatibility of MySQL 4.1
Internationalization Enhancements
Looking Further Ahead to MySQL 5.0
Appendix A. Installing MySQL, Apache, and PHP from the CD-ROM