O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Book Description

Learn PHP and MySQL programming— the quick and easy way!

 

Easy visual approach uses demonstrations and real-world examples to guide you step by step through advanced techniques for dynamic Web development using PHP and MySQL.

 

• Concise steps and explanations let you get up and running in no time.

• Essential reference guide keeps you coming back again and again.

• Whether you’re new to programming or an experienced veteran just needing to get up to speed on PHP and MySQL, this book will teach you all you need to know, including the latest changes in the languages, and much more!

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