Practical PHP and MySQL Website Databases: A Simplified Approach

Table of contents

1. Title Page
2. Dedication
3. Contents at a Glance
4. Contents
5. About the Author
6. About the Technical Reviewer
7. Acknowledgments
8. Introduction
9. CHAPTER 1: Create and Test a MySQL Database and Table
   1. Defining the Term Database
   2. Methods for Developing and Maintaining Databases
   3. Using XAMPP on Your Own Computer
   4. Summary
10. CHAPTER 2: Create Web Pages That Interact with Users
    1. Create the Folder for Holding the Database Pages
    2. Create the Temporary Template
    3. Introducing the PHP include() Function
    4. Styling the Temporary Template
    5. The Interactive Version of the Template
    6. Connecting to the Database
    7. The PHP Keyword echo
    8. Styling the Form Fields
    9. Sticky Forms
    10. The Thank You Page
    11. Displaying Error Messages That Are Collected in an Array
    12. Viewing Members’ Records
    13. The View Users Page
    14. The Change Password Page
    15. Confirming a Successful Password Change
    16. Dealing with an Apostrophe
    17. Tutorial Dealing with the Apostrophe
    18. More About Arrays
    19. Summary
11. CHAPTER 3: Login/Logout for Members and an Administrator
    1. Create the Logindb Database and Table
    2. Tidy the Styling
    3. Remove or Replace Redundant Menu Buttons in the Headers
    4. The Registration Page and Undesirable Characters
    5. Differentiating Between Two Types of Membership
    6. Create User Levels to Limit Access to Private Pages
    7. Log In
    8. A Members-only Page
    9. Planning the Administrator’s Role
    10. A New Header for the Administration Page
    11. The Administrator’s Page
    12. The Logout Page
    13. Testing the Login/logout Function
    14. Amending and Deleting Individual Records
    15. Summary
12. CHAPTER 4: Display Membership Tables for the Administrator
    1. The Administration Database
    2. Revising the View Users Page to Include Editing and Deleting
    3. Displaying Pages of Records (Pagination)
    4. Planning the Search Criteria
    5. A Temporary Page for Displaying Specified Members
    6. The Search Form
    7. The Final Form Handler for Receiving Search Form Input
    8. Editing Records
    9. Summary
13. CHAPTER 5: Register Addresses and Phone Numbers
    1. Create a New Database and a Table with 17 Columns
    2. The Importance of Documentation
    3. Extend the Registration Form, and Add a Pull-down Menu
    4. Add PayPal Debit/Credit Card Images
    5. Include PayPal on the Thank You Page
    6. Register Some Members
    7. Amend the Administrator’s Header
    8. Apply Pagination to the admin_view_users Table
    9. Searching and Editing Records
    10. Searching for Members’ Addresses and Phone Numbers
    11. Summary
14. CHAPTER 6: The Finishing Touches
    1. Create the Database
    2. Create the Table by Importing an SQL Dump File
    3. Tidy the Folders and Filing System
    4. Degrees of Security
    5. Validation and Sanitization
    6. A More Secure Registration Page
    7. Search for an Address and Telephone Number
    8. Summary
15. CHAPTER 7: Migrating to a Host and Backing Up Your Web Site Database
    1. Making Last-Minute Changes
    2. Safe E-mailing
    3. Migrating the Database and Tables to a Remote Host
    4. Back Up Your Database
    5. Summary
16. CHAPTER 8: Creating a Product Catalog
    1. Prepare the Database and Administration Plan
    2. Create a New Database
    3. Create the File for Connecting to the Database
    4. Security
    5. Creating a Home Page with Search Capability
    6. Displaying the Catalog
    7. The Header for the Page of Search Results
    8. Creating the Admin/Add a House Page
    9. The Header for the Administrator’s Page
    10. Administrator’s View of the Entire Stock of Houses for Sale
    11. The Administrator’s Search Page
    12. The Contact Us Page
    13. Summary
17. CHAPTER 9: Adding Multiple Tables and Other Enhancements
    1. Introduction to Multiple Tables
    2. Payments by Check
    3. Printing Online Forms
    4. Summary
18. CHAPTER 10: Creating a Message Board
    1. The Plan
    2. Create the Database
    3. Create the Tables
    4. Create the Template for the Message Board Web Site
    5. Create the Registration Form
    6. Register Some Members
    7. The Login Page
    8. Logging Out
    9. Creating a Gateway to the Two Categories of Quotes
    10. The Form for Posting Quotations
    11. Processing the Postings
    12. Post Some Quotations
    13. The Home Page
    14. Adding Search Facilities
    15. The Header for View Posts.php
    16. Search for Specific Words or Phrases
    17. Displaying the Search Results
    18. Enhancing the Message Board
    19. Summary
19. CHAPTER 11: E-Commerce: A Brief Introduction
    1. Items Common to Both Shopping Carts
    2. Features Applicable Only to the PayPal Shopping Cart
    3. A Custom Shopping Cart
    4. Summary
20. CHAPTER 12: Troubleshooting Your Database-Driven Web Site
    1. HTML Code Errors
    2. PHP Script Errors
    3. MySQL Errors
    4. Summary
21. APPENDIX: Appendix
    1. PHP Quick Reference
    2. MySQL and phpMyAdmin Quick Reference
    3. What Next?
    4. Resources for PHP and MySQL
    5. PHP and MySQL Internet Resources
    6. Summary
22. Index