Contents -- Introduction -- PART I: GETTING STARTED -- Chapter 1 Installing and Configuring MySQL -- Various MySQL Distributions -- Installing MySQL on Windows -- Installing MySQL for Linux -- Chapter 2 Installing Apache -- Installing Apache for Windows -- Installing Apache for Linux/UNIX -- Chapter 3 Installing PHP -- Installing PHP for Windows -- Installing PHP for Linux/UNIX -- PART II: THE ABSOLUTE BASICS OF CODING IN PHP -- Chapter 4 Mixing PHP and HTML -- How PHP Is Parsed -- PHP Start and End Tags -- Code Cohabitation -- Escaping Your Code -- Commenting Your Code -- Chapter 5 Introducing Variables and Operators -- What's a Variable? -- PHP Variable and Value Types -- What's an Operator? -- Chapter 6 Using PHP Variables -- Getting Variables from Forms -- HTTP Environment Variables -- PART III: START WITH THE SIMPLE STUFF -- Chapter 7 Displaying Dynamic Content -- Displaying Browser-Specific HTML -- Displaying Platform-Specific HTML -- Working with String Functions -- Redirecting to a New Location -- Chapter 8 Sending E-Mail -- Using an SMTP Server -- A Simple Feedback Form -- A Feedback Form with Custom Error Messages -- Chapter 9 Using Your File System -- File Paths and Permissions -- Displaying Directory Contents -- Working with fopen() and fclose() -- File System Housekeeping -- Chapter 10 Uploading Files to Your Web Site -- Checking Your php.ini File -- Understanding the Process -- Creating the Form -- Creating the Upload Script -- Uploading a File Using Your Form and Script -- PART IV: GETTING TO KNOW YOUR MYSQL DATABASE -- Chapter 11 Establishing a Connection and Poking Around -- Working with User Privileges in MySQL -- Connecting to MySQL -- Listing Databases on a Server -- Listing Tables in a Database -- Creating a New Database -- Deleting a Database -- Chapter 12 Creating a Database Table -- Planning for Your Tables.

A Two-Step Form Sequence -- Creating the Table-Creation Script -- Create That Table! -- Chapter 13 Inserting Data into the Table -- Creating the Record Addition Form -- Creating the Record Addition Script -- Populating Your Table -- Chapter 14 Selecting and Displaying Data -- Planning and Creating Your Administrative Menu -- Selecting Data from the my_music Table -- PART V: USER AUTHENTICATION AND TRACKING -- Chapter 15 Database-Driven User Authentication -- Why Authenticate Anyone? -- Creating the User Table -- Adding Users to Your Table -- Creating the Login Form -- Creating the Authentication Script -- Trying to Authenticate Yourself -- Chapter 16 Using Cookies -- What Are Cookies? -- Setting Cookies -- Using Cookie Variables -- Chapter 17 Session Basics -- Before You Begin…Checking php.ini -- What's a Session? -- Understanding Session Variables -- Managing User Preferences with Sessions -- PART VI: CREATING YOUR OWN CONTACT MANAGEMENT SYSTEM -- Chapter 18 Planning Your System -- Planning and Creating the Administration Menu -- Defining the my_contacts Table -- Chapter 19 Adding Contacts -- Creating the Record-Addition Form -- Creating the Record-Addition Script -- Populating Your Table -- Chapter 20 Modifying Contacts -- Creating the Record-Selection Form -- Creating the Record-Modification Form -- Creating the Record-Modification Script -- Modifying Contacts -- Chapter 21 Deleting Contacts -- Using the Record-Selection Form -- Creating the Record-Deletion Form -- Creating the Record-Deletion Script -- Deleting Contacts -- Chapter 22 Working with Contacts -- Modifying Your Administrative Menu -- Selecting Data from the my_contacts Table -- PART VII: ADDITIONAL PROJECT EXAMPLES -- Chapter 23 Managing a Simple Mailing List -- A Brief Word About Mailing List Software -- Developing a Subscription Mechanism -- Developing the Mailing Mechanism.

Chapter 24 Creating Custom Logs and Reports -- A Note About Apache Log Files -- Simple Access Counting with MySQL -- Chapter 25 Working with XML -- What Is XML? -- Preparing to Use XML with PHP -- Parsing XML with PHP -- PART VIII: APPENDIXES -- Appendix A: Additional Configuration Options -- Windows Extensions -- Linux Configuration Options -- Appendix B: Basic PHP Language Reference -- PHP Start and End Tags -- Variables -- Operators -- Control Structures -- Built-In Functions -- Appendix C: Writing Your Own Functions -- The Structure of Functions -- Using Functions in Your Code -- Appendix D: Writing Your Own Classes and Objects -- Working with Objects -- Appendix E: Database Normalization and SQL Reference -- Understanding Database Normalization -- Basic MySQL Reference -- Appendix F: Using SQLite -- Examples of SQLite in Action -- Appendix G: Getting Help -- PHP Resources -- MySQL Resources -- Apache Resources -- Index -- A -- B -- C -- D -- E -- F -- G -- H -- I -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- X -- Y.