If you are reading a printed copy of this page, you are reading an incomplete version, please print http://openlib.org/home/krichel/courses/lis651p06a/lis651p06a.letter.pdf for US letter paper or http://openlib.org/home/krichel/courses/lis651p06a/lis651p06a.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 may build their own Linux servers on machines that they may bring along.
Prerequisites
Student normally must have passed LIS650 before taking this course. Students must be comfortable with the LIS650 material because this course is a lot more difficult than LIS650. 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 normally be held on Sundays between 13:00 and 18:00 in the computer lab of the Palmer School.
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.
Note that the slides are drafts from the previous edition of the course.
Class details:
| 0 | 2006–10–29 | 13:00 to 18:00 | getting and presenting data |
| 1 | 2006–11–05 | 13:00 to 18:00 | more on PHP, introduction to database |
| 2 | 2006–11–12 | 13:00 to 18:00 | introduction to mySQL and PHP mySQL function |
| 3 | 2006–11–19 | 13:00 to 18:00 | PHP sessions and functions |
| 4 | 2006–12–03 | 13:00 to 18:00 | regular expressions |
| 5 | 2006–12–10 | 13:00 to 18:00 | use of wotan |
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 Sklar (2004) did bring much good material. This book and Welling and Thompson (2005) is where much of the teaching material is lifted from. Earlier, he used Lea et al. (2001) as 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. This site has to be handed at the date of the last class meeting.
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
Judy
Brink
Jennifer
Spanier
Hao
Zeng
Matt
Catalano