If you are reading a printed copy of this page, you are reading an incomplete version, please print http://openlib.org/home/krichel/courses/lis651p05a/lis651p05a.letter.pdf for US letter paper or http://openlib.org/home/krichel/courses/lis651p05a/lis651p05a.a4.pdf for A4 sized paper.
Course Description
This course focuses on the construction of active web sites. Such web sites change contents depending on what the user does with them. Many times, such sites involve users filling in a form, which is then processed. For an example, think of a query in a web-based library catalog. But active sites may also be as simple as saying "Merry Xmas" before 25 December, and leave it out afterwards. Students will learn how build simple active web sites. There are two aspects to this process. The first is the information itself. It is usually held in relational databases. The course therefore studies relational databases. It introduces the mySQL database software. The secord aspect is the interface between the data in the database and the web. This is achieved with a procedural computing language. The course studies PHP, a purpose-built language for active web sites.
Course objectives
After taking this course the stundents
Finally, in the last class, students will build their own Linux servers on machines that they may bring along.
Prerequisites
Student normally must have passed LIS650 before taking this course. Students who wish to qualify for an exeption should contact the instructor prior to registering.
Instructor
Thomas
Krichel
Palmer School of Library
and Information Science
C.W. Post
Campus of Long Island
University
720 Northern Boulevard
Brookville, NY 11548–1300
krichel@openlib.org
work phone: +1–(516)299–2843
Private contact details may be obtained from the online CV.
Class structure
Classes will be held in computer lab of the Palmer School, normally on Sundays between 12:00 and 17:00. The first two classes, however, are exeptions. The first class will be taught by Angela Cornwell and run from 15:00 to 20:00, and be followed by a Vachin Mont-d'Or cheese and whine reception. The second class will run 12:00 to 17:00, but on a Saturday.
Each class will have a lengthy presentation by the instructor. For some small part of class time the students will work directly with their computers under the supervision of the instructor. However, give the hefty weight of the class material, students are expected to do much of the work on the web site at home.
Class details:
| 0 | 2005–10–23 | 15:00 to 20:00 | getting and presenting data |
| 1 | 2005–10–29 | 12:00 to 17:00 | more on PHP, introduction to database |
| 2 | 2005–11–06 | 12:00 to 17:00 | intrduction to mySQL and PHP mySQL function |
| 3 | 2005–11–13 | 12:00 to 17:00 | PHP sessions and functions |
| 4 | 2005–11–20 | 12:00 to 17:00 | fun with PHP and mySQL |
| 5 | 2005–12–04 | 12:00 to 17:00 | Regular expressions and wotan use |
To print the slides in Microsoft powerpoint, press control-p to print, then under "Print what" choose "Handouts", and under "Color/grayscale" choose "Pure Black and White". You can also use openoffice to print the slides.
Readings
PHP is documented on its web site at http://www.php.net that students will probably find all gobbledigook when they first look at it. Most books on PHP also cover some relational database theory and practice. Students may find Ullman (2004) as reasonably priced introductory books on the topics of the course.
The instructor found that Lea et al. (2001) is an intoduction that is probably suitably paced for the beginner. Meloni (2000) receives favorable reviews as a beginners' book.
Assessment
Before each class except the first and second, there will be a quiz on the issued covered in the previous class. The average of all the quiz results will count for 40% of the assessment. For the third class meeting, the students will prepare a one-page web site that will state web site that they want to build. This statement should cover both the purpose of the web site and the site's architecture. The assessment of this statement will not count for assessment. The remaining 60% will be assessed through the final web site.
Mailing list
There is a mailing list for the course at https://lists-1.liu.edu/mailman/listinfo/cwp-lis651-krichel. All students are encouraged to subscribe. As a rule, answers to email sent to the instructor will be copied to the list. There are exceptions to this rule
Students
Amalia Connolly
Sarah L.
Glasser
Sharon Kullberg
Sharon
A. Pullen
Mark
Sandford
Michael
Tarrant
Mary Pat
Takacs
Clara
Tran