Syllabus:

Instructor: Xusheng Wang
Email: wangx@winthrop.edu
Webpage: http://faculty.winthrop.edu/wangx/teaching/CSCI241/syllabus.htm
Phone: (803) 323-4824
Office: 304 Thurmond
Office hours: MW 02:50pm - 05:00pm TR 03:15pm - 05:00pm, or by appointment
Classroom: THUR 408
Class meeting time: MW 12:30pm - 01:45pm
Lab: THUR 303
Lab meeting time: MW 02:00pm - 02:50pm
Course credit hours: 4

Textbooks:
Luke Welling and Laura Thomson, PHP and MySQL Web Development, Fourth Edition, ISBN-10: 0672329166, ISBN-13: 9780672329166, Addison Wesley, 2009.

Prerequisites: CSCI 101C and INFD 141.

Course Description (from Catalog):
As a continuation of INFD 141, this course focuses on the web programming at the server-side. Server-side scripting languages such as Perl, PHP and Ruby will be introduced to develop interactive and dynamic database-driven web applications. An open source database server will be used to store and process data. Topics cover HTTP protocol, CGI, server-side scripting, database creation and manipulation, session and state control, web authentication and security. Basics of XML and Ajax/remote scripting will be discussed if . A term project is required to use the learned skills to develop an online database-driven web site.

Course Contents:
PHP and MySQL will be chosen as server-side scripting language and database server for this semester. The detailed topics include:

• fundamentals of the server side web programming
• programming platform (for example, Linux, Apache, PHP, and MySQL)
• HTTP protocol
• XHTML forms
• PHP components: installation and configuration, PHP basic syntax, strings, arrays, passing information from client to server, regular expression and user input validation, querying and writing to database, sessions and states, authentication and security, handling errors and exceptions, sending emails, etc.
• MySQL components: installation and configuration, database creation, basic SQL query, insert, delete and update statements, basic administration, etc.
• Ajax and remote scripting: basic concepts and coding skills if time is enough

Course Objectives:
After completing this course, a student will be able to:

• understand the web application infrastructure
• use web development tools to develop and maintain web sites
• understand concepts, methods, data structures and techniques related to the web server side programming
• use PHP and MySQL to develop interactive database-driven web-based applications
• understand and implement security strategies in web applications
• understand Ajax and use Ajax to implement advanced interactions in web applications

Course Grading Policy:
7 Assignments - 35%
1 Term Project - 10%
2 Tests - 30%
Final Exam - 25%

The final grade will be based on the following scale:
100 >= A >= 93%, 93 > A- >= 90%,
90 > B+ >= 87%, 87 > B >= 83%, 83 > B- >= 80%,
80 > C+ >= 77%, 77 > C >= 73%, 73 > C- >= 70%,
70 > D+ >= 67%, 67 > D >= 63%, 63 > D- >= 60%%,
60% > F.

All assignments must be handed in to the instructor by the due time that will be specified on each assignment. Late submission will be accepted with a penalty of 5% for every delayed day. You are expected to take exams at the scheduled times.  If you cannot take an exam at the scheduled time, you must request an alternate time before the scheduled exam date. The instructor will judge the validity of the request, and either disallow it or assign another time.

Attendance Policy:
Attendance is required and will be monitored. Students are responsible for the information provided in every class. Missed classes may negatively affect grades on assignments and exams.

Students with Disabilities:
Winthrop University is dedicated to providing access to education. If you have a disability and require specific accommodations to complete this course, contact Gena Smith, Program Director, Services for Students with Disabilities, at 323-3290. Once you have your official notice of accommodations from Services for Students with Disabilities, please inform me as early as possible in the semester.

Syllabus change policy:
The grading and attendance policies for this course, as described above, will not be changed and are adhered to strictly. The schedule of class meetings, listed below, may change due to unexpected events such as class cancellation due to weather.

College of Business Expectations Regarding Professionalism in the Classroom

The College of Business Administration is a professional organization with a well-defined and widely disseminated mission of student development. Accordingly, each class represents a gathering of professionals and professionals-in-training. The instructor's job as a professional is to deliver quality instruction in each class, to start and end each class on time, to be responsive to student perspectives, issues and questions, and to treat each student respectfully. The student's job, as a professional-on-training is to be prepared for class, to be on time, to attend all classes, and to be respectful of others in the classroom.

In accordance with and pursuant to these roles the following guidelines were established to specify to students (both present and prospective) faculty expectations regarding their behaviors

1. Students will attend all class meetings. There are no automatically "excused" absences. In the event that you will be unable to attend a class session, you should inform your professor in advance as a matter of professional courtesy just as you would/should with an employer.
2. Students will arrive in advance of the beginning of the class session. Late arrivals are disruptive, inconsiderate and unprofessional. Professors may make arrangements for delinquent, but are not obliged to do so. Those not present at the beginning of the classroom period will be considered absent.
3. Students will not converse among themselves during class except when instructed to do so. When a student creates a disturbance in the classroom, instructors will either ask the student to desist immediately or speak to the student at the conclusion of class. Repeat offenders will be sanctioned.
4. Students will not leave class before its conclusion. Early departures are disruptive, inconsiderate and unprofessional. Professors may make arrangements under some circumstance, but are not obliged to do so. Those not present at the conclusion of the classroom session will be considered absent.
5. Students will have procured textbook/materials prior to the first class. Instruction will begin with the first class meeting and consume the remainder of the class period.