14.1. What Is LAMP?14.1.1. Apache14.1.2. MySQL14.1.3. PHP14.1.4. The Rebel Platform14.1.5. Evaluating the LAMP Platform14.1.5.1. Cost and Licensing14.1.5.2. Certification14.1.5.3. Support and Services14.1.5.4. Vendor/Developer Community Relationship14.1.5.5. Integration with and Support for Other Technologies14.2. Apache14.2.1. Virtual Hosting14.2.2. Installation and Configuration of PHP 514.2.2.1. PHP Configuration14.2.2.2. Installation of PHP Modules14.2.3. Apache Basic Authentication14.2.4. Apache and SSL14.2.5. Integrating SSL with HTTP Authentication14.3. MySQL14.3.1. Installing MySQL14.3.2. Configuring and Starting the Database14.3.3. Changing the Default Password14.3.4. The MySQL Client Interface14.3.5. Relational Databases14.3.6. SQL14.3.6.1. Creating Tables14.3.6.2. Inserting a Record14.3.6.3. Searching for Records14.3.6.3.1. The SELECT Clause14.3.6.3.2. The WHERE Clause14.3.6.4. Editing a Record14.3.6.5. Deleting Records14.3.7. The Relational Model14.3.7.1. Relations, Tuples, and Attributes14.3.7.2. Keys and Relationships14.3.7.3. Relational Operators14.3.7.4. Data Integrity14.3.7.5. Data Modeling and Normalization14.4. PHP14.4.1. The PHP Language14.4.1.1. Language Basics14.4.1.2. Requiring/Including Files14.4.1.3. Magic Type Casting14.4.1.4. Arrays/Lists/Dictionaries14.4.1.5. Functions14.4.1.6. Scope14.4.1.7. Loops and Iterators14.4.1.8. Objects14.4.1.9. Pass by Reference/Pass by Value?14.4.2. Error Handling14.4.3. Error-Handling Exceptions14.4.4. Optimization Techniques14.4.4.1. Strings14.4.4.2. Arrays14.4.4.3. xdebug: Profiling and/or Debugging PHP Code14.4.5. Installing Additional PHP Software14.4.6. Logging14.4.7. Parameter Handling14.4.7.1. Register Globals14.4.8. Session Handling14.4.9. Unit Testing14.4.10. Databases and PHP14.4.11. PHP Frameworks14.5. The DVD Library14.5.1. Version 1: The Developer's Nightmare14.5.2. Version 2: Basic Application with DB-Specific Data Layer14.5.3. Version 3: Rewriting the Data Layer, Adding Logging and Exceptions14.5.3.1. Adding Database Abstraction14.5.3.2. Exceptions14.5.3.3. Logging14.5.4. Version 4: Applying a Templating Framework14.6. Summary