PHP & MySQL for Dummies
Table of Contents
Part I: Developing a Web Database Application Using PHP and MySQL
Chapter 1: 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
Chapter 2: Setting Up Your Work
Environment
- The Required Tools
- Finding a Place to Work
- Testing, Testing, 1, 2, 3
Chapter 3: Developing a Web Database
Application
- Planning Your Web Database Application
- Presenting the Two Running Examples in the Book
- Designing the Database
- Designing the Sample Databases
- Types of Data
- Taking a Look at the Sample Database Designs
- Developing the Application
Part II: MySQL Database
Chapter 4: Building the Database
- Communicating with MySQL
- Building a Database
- Moving Data In and Out of the Database
Chapter 5: Protecting Your Data
- Controlling Access to Your Data
- Setting Up MySQL Accounts
- Backing Up Your Data
- Restoring Your Data
- Types of Data
- Taking a Look at the Sample Database Designs
- Developing the Application
Part III: PHP
Chapter 6: 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
Chapter 7: PHP Building Blocks for
Programs
- Useful Simple Statements
- Using PHP Arrays
- Useful Conditional Statements
- Using Loops
- Using Functions
Chapter 8: Data In, Data Out
- PHP/MySQL Functions
- Making a Connection
- Getting Information from a Database
- Getting Information from the User
- Putting Information into a Database
- Getting Information in Files
Chapter 9: Moving Information from One
Web Page to Another
- Moving Your User from One Page to Another
- Moving Information from Page to Page
- Using PHP Sessions
Part IV: Applications
Chapter 10: Putting It All Together
- Organizing the Application
- Keeping It Private
- Completing Your Documentation
Chapter 11: Building an Online Catalog
- Designing the Application
- Building the Database
- Designing the Look and Feel
- Writing the Programs
Chapter 12: Building a Members Only Web
Site
- Designing the Application
- Building the Database
- Designing the Look and Feel
- Writing the Programs
- Planning for Growth
Part V: The Part of Tens
Chapter 13: Ten Things You Might Want to
Do Using PHP Functions
Chapter 14: Ten PHP Gotchas
Part VI: Appendixes
Appendix A: Installing MySQL
Appendix B: Installing PHP
Appendix C: Installing Apache
Appendix D: Syntax for MySQL and MySQL
Improved Functions