PHP-200

Course Outline

1. Week 1 - The PHP Environment
   • MySQL hosting
   • MySQL database
   • Setting up a local development environment
   • Setting up a remote development environment
   Week 1 Project
2. Week 2 - Connections
   • MySQL connector
   • Connecting to the database
   • Closing the connection
   • Connection properties
   Week 2 Project
3. Week 3 - Recordsets
   • Accessing data from tables
   • SQL selection statements
   • Recordset Navigation
   • Displaying fields
   Week 3 Project
4. Week 4 - Data manipulation
   • Essential SQL
   • Retrieving data
   • Modifying data
   • Deleting data
   Week 4 Project
5. Week 5 - Integrating Forms and Databases
   • Creating a data entry form
   • Creating a data display form
   • Data validation
   • Translating data types from the database to the form
   • Translating data types from the form to the database
   Week 5 Project
6. Week 6 - Wrap-up Project
   • An application using forms and databases
   • Data Entry
   • Redisplaying the Data
   • Saving the Data
   • Retrieving the data
   • Modifying the data
   • Cleaning up
   Week 6 Project