TEAC882B Database and Web Applications

Resources:

1. Examples and Resources
1. Session 1 - Basic HTML and Tools
2. Session 1 - HTML and CSS
3. Session 2 - Basic PHP
1. zipped download
4. Session 3 - Forms - In Class Examples
   1. Creating a form and showing results. - directory or zip download
   2. Cleaning up form input data. - directory or zip download
   3. Using form data to change page color. - directory or zip download
   4. Very basic first form. - directory or zip download
   5. Working with the GET method. - directory or zip download
   6. Using $_REQUEST. - directory or zip download
   7. Using Control Structures. - directory or zip download
   8. Using Includes. - directory or zip download
   9. Login Example. - directory or zip download
5. Session 4 - Web Forms & Validation
1. Lab Examples
6. Session 5 - Cookies, Sessions, & Functions
1. In class examples
7. Session 5 & 6 - Intro to MySQL
• MySQL Resources
  • MySQL Workbench
  • MySQL Workbench Documentation
• phpMyAdmin Resources
• Access phpMyAdmin on Tess3
8. Sessions 7 & 8 - Database Design
   1. Normalization Links
      1. Wikipedia - Database Normalization
      2. MySQL
      3. Database Journal
      4. littstip Normalization
      5. PHPBuilder
      6. ServerWatch
      7. Microsoft
   2. ER Diagrams
      1. ER Diagrams
      2. Wikipedia - Entity Relationship Model
      3. University of Wisconson
9. Session 9 - PHP & MySQL Connections Continued
   1. Examples
   2. Previous Labs
10. Session 11 - Email, Files, and File Uploads
    1. Examples
11. Session 12 - Worked Examples
    1. Working Link to Quiz Example
    2. Online Quiz -Source files - PHP pages
    3. MySQL Dump of WebQuiz DB Tables