Exercise #2
Paired programming!
- Today you will work in pairs to complete an exercise.
- Start your work in one person's account
- At the end of the exercise, copy the code and make sure it works
in the other person's account also.
Create a Web-accessible database
- In your MySQL account on pearl.ils.unc.edu, create a database table called: courses.
- The fields in the courses table should be:
- semester
- coursenum
- sectionnum
- title
- instructor
- All fields can be varchar(40).
- The PK should be: {semester, coursenum, sectionnum}.
- Use the MySQL bulk loader to load data into the courses table from the file:
ex2_courses.txt
- Write a PHP program to display the contents of the of the courses
table on a web page in an HTML table, sorted by the instructor field.
What to turn in
- At the end of the exercise, copy the PHP code and make sure it works
in the other person's account also.
- Each student should submit a copy of the exercise via Sakai before 5:00pm tomorrow, Feb 6.
- Turn in only your PHP file.
- Name your file: youronyen_ex2.php
- Submit your file via Sakai->Assignments->Exercise 2.