About This Project
In the Web Development with PHP and MySQL course (CA 086) at Mission College, our final project is to create a unified web site that includes:
- A template whereby all pages share the same general structure;
- Control structures such as loops and functions for generating web information;
- String functions for working with web information;
- Web forms for working with user input;
- Access to MySQL for storing and changing data; and
- Cookies and other state information for keeping track of user sessions.
The course consists of the following modules:
| Week | Module | Topics |
|---|---|---|
| 1 | Orientation | Install xAMP, FTP, SSH, and text editor |
| 2 | HTML Review | Web site, HTML, and CSS |
| 3 | Getting Started | Variables, data types, expressions, operators |
| 4 | Control | If and switch, for and while loops, functions |
| 5 | Strings | And regular expressions |
| 6 | Forms | Validation, templates, dynamic content |
| 9 | Files | Files, directories, file permissions, uploading |
| 10 | Arrays | Indexed arrays, associative arrays |
| 11 | MySQL | Databases, MySQL command line |
| 12 | PHP and MySQL | The mysqli library |
| 14 | State | Query strings, cookies, sessions |