PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, Fifth Edition

Table of Contents

1. Cover Page
2. Title Page
3. Copyright Page
4. Dedication Page
5. Table of Contents
6. Introduction
7. Chapter 1 Introduction to PHP
   1. Basic Syntax
   2. Sending Data to the Browser
   3. Writing Comments
   4. What Are Variables?
   5. Introducing Strings
   6. Concatenating Strings
   7. Introducing Numbers
   8. Introducing Constants
   9. Single vs. Double Quotation Marks
   10. Basic Debugging Steps
   11. Review and Pursue
8. Chapter 2 Programming with PHP
   1. Creating an HTML Form
   2. Handling an HTML Form
   3. Conditionals and Operators
   4. Validating Form Data
   5. Introducing Arrays
   6. For and While Loops
   7. Review and Pursue
9. Chapter 3 Creating Dynamic Web Sites
   1. Including Multiple Files
   2. Handling HTML Forms, Revisited
   3. Making Sticky Forms
   4. Creating Your Own Functions
   5. Review and Pursue
10. Chapter 4 Introduction to MySQL
    1. Naming Database Elements
    2. Choosing Your Column Types
    3. Choosing Other Column Properties
    4. Accessing MySQL
    5. Review and Pursue
11. Chapter 5 Introduction to SQL
    1. Creating Databases and Tables
    2. Inserting Records
    3. Selecting Data
    4. Using Conditionals
    5. Using LIKE and NOT LIKE
    6. Sorting Query Results
    7. Limiting Query Results
    8. Updating Data
    9. Deleting Data
    10. Using Functions
    11. Review and Pursue
12. Chapter 6 Database Design
    1. Normalization
    2. Creating Indexes
    3. Using Different Table Types
    4. Languages and MySQL
    5. Time Zones and MySQL
    6. Foreign Key Constraints
    7. Review and Pursue
13. Chapter 7 Advanced SQL and MySQL
    1. Performing Joins
    2. Grouping Selected Results
    3. Advanced Selections
    4. Performing FULLTEXT Searches
    5. Optimizing Queries
    6. Performing Transactions
    7. Database Encryption
    8. Review and Pursue
14. Chapter 8 Error Handling and Debugging
    1. Error Types and Basic Debugging
    2. Displaying PHP Errors
    3. Adjusting Error Reporting in PHP
    4. Creating Custom Error Handlers
    5. PHP Debugging Techniques
    6. SQL and MySQL Debugging Techniques
    7. Review and Pursue
15. Chapter 9 Using PHP with MySQL
    1. Modifying the Template
    2. Connecting to MySQL
    3. Executing Simple Queries
    4. Retrieving Query Results
    5. Ensuring Secure SQL
    6. Counting Returned Records
    7. Updating Records with PHP
    8. Review and Pursue
16. Chapter 10 Common Programming Techniques
    1. Sending Values to a Script
    2. Using Hidden Form Inputs
    3. Editing Existing Records
    4. Paginating Query Results
    5. Making Sortable Displays
    6. Review and Pursue
17. Chapter 11 Web Application Development
    1. Sending Email
    2. Handling File Uploads
    3. PHP and JavaScript
    4. Understanding HTTP Headers
    5. Date and Time Functions
    6. Performing Transactions
    7. Review and Pursue
18. Chapter 12 Cookies and Sessions
    1. Making a Login Page
    2. Making the Login Functions
    3. Using Cookies
    4. Using Sessions
    5. Improving Session Security
    6. Review and Pursue
19. Chapter 13 Security Methods
    1. Preventing Spam
    2. Validating Data by Type
    3. Validating Files by Type
    4. Preventing XSS Attacks
    5. Using the Filter Extension
    6. Preventing SQL Injection Attacks
    7. Securing Passwords with PHP
    8. Review and Pursue
20. Chapter 14 Perl-Compatible Regular Expressions
    1. Creating a Test Script
    2. Defining Simple Patterns
    3. Using Quantifiers
    4. Using Character Classes
    5. Finding All Matches
    6. Using Modifiers
    7. Matching and Replacing Patterns
    8. Review and Pursue
21. Chapter 15 Introducing jQuery
    1. What Is jQuery?
    2. Incorporating jQuery
    3. Using jQuery
    4. Selecting Page Elements
    5. Event Handling
    6. DOM Manipulation
    7. Using Ajax
    8. Review and Pursue
22. Chapter 16 An OOP Primer
    1. Fundamentals and Syntax
    2. Working with MySQL
    3. The DateTime Class
    4. Review and Pursue
23. Chapter 17 Example—Message Board
    1. Making the Database
    2. Writing the Templates
    3. Creating the Index Page
    4. Creating the Forum Page
    5. Creating the Thread Page
    6. Posting Messages
    7. Review and Pursue
24. Chapter 18 Example—User Registration
    1. Creating the Templates
    2. Writing the Configuration Scripts
    3. Creating the Home Page
    4. Registration
    5. Activating an Account
    6. Logging In and Logging Out
    7. Password Management
    8. Review and Pursue
25. Appendix A Installation
    1. Installation on Windows
    2. Installation on macOS
    3. Managing MySQL Users
    4. Testing Your Installation
    5. Configuring PHP
    6. Configuring Apache
26. Index