| Lab | Date | Topic | Manual | Materials
|
|---|
| 1
| 08/23
| HTML and CSS
| HTML, CSS
Slide
|
Exercise, Resource1, Resource2, Resource3
|
| 2
| 08/30
| PHP Programming
| PHP1 PHP2
Slide
|
Exercise1, Exercise2
Worksheet Resource1, Worksheet Resource2, Worksheet Resource3
Exercise Resource1,Exercise Resource2
|
| 3
| 09/06
| Form Validation and Processing
| PDF
Slide
|
Woksheet1, Worksheet2, Worksheet3
Exercise, Resource
Note (Homework)
Section 1 (Morning) --> Exercise --> Question 1
Section 2 (Afternoon) --> Exercise --> Question 3
|
| 4
| 09/13
| Database Design and Administration
| Workbench (PDF), phpMyAdmin (PDF)
MYSQL (PDF)
Slide
|
Resource
, **MySQL Solution
|
| 5
| 09/20
| Data Manipulation I
| PDF
|
Worksheet1, Worksheet2, Worksheet3
|
| 6
| 09/27
| * Mini Project Presentation Day
|
| ***Project Instruction
|
|
|
| MIDTERM EXAMINATION (No class)
|
| 7
| 10/11
| Data Manipulation II
| PDF
|
Worksheet1, Worksheet2, Worksheet3
|
| 8
| 10/18
| Data Manipulation III
| PDF,
Example DB (World database), Example Code, Finish Code
|
Worksheet1, Worksheet2, Worksheet3
Homework
Section 1 ---> Worksheet 3 (Orange)
Section 2 ---> Worksheet 2 (Blue)
|
| 9
| 10/25
| Login and Session Handling
| PDF,
Example Session,
Example Session Complete
|
Worksheet, Exercise1, Exercise2, Exercise3
|
| 10
| 11/01
| Stored Procedure and Function
| PDF
|
Example DB, Database
|
| 11
| 11/08
| Trigger
| PDF
|
- |
| 12
| 11/15
| Project Development
|
|
|
| 13
| 11/22
| * Project Presentation Day
|
| ***Project Instruction
***Project Instruction and Exam detail***
|
|
|
| FINAL EXAMINATION (Closed Book) (follow the schedule on reg.siit.tu.ac.th)
|
Database Programming Laboratory
