Task
|
Description
|
Skill |
Name
|
Example
|
Due Date
|
1 |
Create
a web page that displays a new joke each day. Jokes are read from a database |
Using a database to drive a web
site. |
jokes.php |
MySQL notes |
July 23 |
2 |
Add fields to your Jokes
database. |
Displaying images stored in
a database. |
|
|
July 30 |
2 |
Create all options for the
Contacts database |
Using a web page to add, delete,
and search a database. |
read_contact
new_contact
delete_contact
search_contacts |
main_menu |
Aug 10 |
3 |
Set up the Videomania database. Write a program to
add videos to the videomania database (2 programs required). |
|
new_video.php
insert_video.php |
main_menu.html
|
Aug 13 |
4 |
Write a program to
add bookings to the videomania database |
|
new_booking.php
insert_booking.php |
|
Aug 13 |
5 |
Write
programs to search the videos table and the bookings table of the
videomania database |
|
search_videos.php
search_bookings.php |
|
August 20 |
6 |
Write programs
display the videos table and the bookings table and delete videos and
bookings (4 programs in all) |
|
read_videos.php
read_bookings.php
delete_video.php
delete_booking.php |
|
August 20 |
7 |
Toadstool music site-
Instructions |
|
|
|
Sept 3 |
8 |
More activities (taken from PTK) |
|
various |
various |
|
9 |
Edit the message forum provided
(right-click and save zipped file). Unzip the file to the root directory of
your Foxserv folder. |
|
forum.zip |
|
|