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 -- 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 Variables -- Getting Variables from Forms -- HTTP Environment Variables -- PART III: START WITH 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 -- Check 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 DATABASE -- Chapter 11 Establishing a Connection -- 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 a 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's a Cookie? -- Setting Cookies -- Using Cookie Variables -- Chapter 17 Session Basics -- Before You Begin…Check 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 Administration Menu -- Selecting Data from the my_contacts Table -- PART VII: ADDITIONAL ADMINISTRATION SCRIPTS -- 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 -- PART VIII: APPENDIXES -- Appendix A: Additional Configuration Options -- Appendix B: Basic PHP Language Reference -- Appendix C: Writing Your Own Functions -- Appendix D: Basic MySQL Reference -- Appendix E: Database Normalization -- Appendix F: Getting Help -- Index -- A -- B -- C -- D -- E -- F -- G -- H -- I -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W.