PHP & MySQL for Dummies, 4th Edition Table of Contents

Developing a Web Database Application Using PHP and MySQL

Introduction to PHP and MySQL

  • What is a Web Database Application
  • MySQL, My Database
  • PHP, a Data Mover
  • MySQL and PHP, the Perfect Pair
  • Keeping Up with PHP and MySQL Changes

Setting Up Your Work Environment

  • Anatomy of a Web Site
  • Building a Web Site
  • Deciding Where to Publish Your Web Site
  • Deciding Where to Develop Your Web Site
  • Setting Up Your Web Site
  • Setting Up Your Development Environment
  • Testing, Testing, 1, 2, 3

Developing a Web Database Application

  • Planning Your Web Database Application
  • Presenting the Two Running Examples in This Book
  • Designing the Database
  • Designing the Sample Databases
  • Types of Data
  • Taking a Look at the Sample Database Designs
  • Developing the Application

MySQL Database

Building the Database

  • Communicating with MySQL
  • Building a Database
  • Moving Data Into and Out of the Database

Protecting Your Data

  • Controlling Access to Your Data
  • Setting Up MySQL Accounts
  • Backing Up Your Data
  • Restoring Your Data
  • Upgrading MySQL

PHP

General PHP

  • Adding a PHP Section to an HTML Page
  • Writing PHP Statements
  • Using PHP Variables
  • Using PHP Constants
  • Working with Numbers
  • Working with Character Strings
  • Working with Dates and Times
  • Comparing Values
  • Joining Comparisons with and/or/xor
  • Adding Comments to Your Program

PHP Building Blocks for Programs

  • Useful Simple Statements
  • Using PHP Arrays
  • Useful Conditional Statements
  • Using Loops
  • Using Functions

Data In, Data Out

  • PHP and MySQL Functions
  • Making a Connection
  • Getting Information from a Database
  • Getting Information from the User
  • Putting Information into a Database
  • Getting Information in Files

Moving Information from One Web Page to the Next

  • Moving Your User from One Page to Another
  • Moving Information from Page to Page
  • Using PHP Sessions

Applications and Programs

Putting It All Together

  • Organizing the Application
  • Keeping It Private
  • Completing Your Documentation

Building an Online Catalog

  • Designing the Application
  • Building the Database
  • Designing the Look and Feel
  • Writing the Programs

Building a Members Only Web Site

  • Designing the Application
  • Building the Database
  • Designing the Look and Feel
  • Writing the Programs
  • Planning for Growth

Part of Tens

Ten Things You Might Want to Do Using PHP Functions

    Ten PHP Gotchas

      Appendixes

      Appendix A: Installing PHP, MySQL, and Apache from XAMPP

        Appendix B: Configuring PHP