Transcript Course Objectives, Outcomes and Syllabus

Course Preliminaries

Course Objectives

Students’ Learning Outcomes

Grading Policy

Course Resources

Course Outline
CSC 405: Web Application Engineering II
1.1
Course Objectives

To introduce basic PHP programming

To design and implement simple databases using SQL

To construct Web applications that




access simple databases from PHP using dynamically generated
SQL
extract information from foreign Web sites
send emails to potential users
perform access control using Cookies

To describe and evaluate the mechanisms behind dynamic
Web sites

To introduce the techniques used for constructing advanced
community Web sites
CSC 405: Web Application Engineering II
1.2
Students’ Learning Outcomes

At the end of this course students should be






conversant with requirements and tools for server-side
programming
able to design and implement SQL databases
design and implement Web applications that use databases to
carryout their transactions
to implement access control in Web applications using
Cookies
to design and implement Web applications with various user
roles and privileges
Note: Writing good Web applications requires
knowledge of
text processing, photography, publishing, system administration,
database knowledge, understanding of user interfaces, programming
experience, knowledge about design methodologies, . . . .
CSC 405: Web Application Engineering II
1.3
Grading Policy

Grading is based on the standard University
guidelines: 40% CA, 60% Exams

The CA scores will be earned through



A written test
Several Web development assignments
Additional marks can be earned through
dedication and quality work!
CSC 405: Web Application Engineering II
1.4
Course Resources

Reference Textbook:
Luke Welling & Laura Thomson. PHP and MySQL
Web Development. Third Edition. Sams Publishing.
ISBN: 0-672-32672-8. October 2004



E-copy will be provided
PowerPoint Slides
CSC 405: Web Application Engineering II
1.5
Course Outline
S/No
Topics
Reference
1
Lecture 1: Course introduction. Static Web pages,
HTML, HTML-forms
HTML Overview
2
Introduction to PHP. The first dynamic Web page.
Variables, arithmetic expressions, conditional
statements, string operations, while loops. Querying
data from users, simple forms, form variables
PHP and MySQL Web Development, 1-55
(Introduction, Chapter 1)
3
PHP continued. For-loops. Built-in functions, random
numbers. User defined functions, code reuse,
functions for constructing a changeable Web page
design. Strategies for Web sites that are programs
PHP and MySQL Web Development, 129-155
(Chapter 5)
4
PHP continued. Form-variables in links. Radio buttons,
select lists. Hidden form variables. Arrays. Example:
throwing dices. Check boxes.
PHP and MySQL Web Development, 79-104 (Chapter
3)
5
PHP continued. Regular expressions. Checking form
variables. Fetching data from foreign Web sites
PHP and MySQL Web Development, 105-128
(Chapter 4)
6
File-based databases. Relational databases.
Introduction to SQL (Structured Query Language).
MySQL.
PHP and MySQL Web Development, 57-78 (Chapter
2), 205-216 (Chapter 8)
CSC 405: Web Application Engineering II
1.6
… Course Outline
S/No
Topics
Reference
7
SQL continued. Aggregate requests, calculated fields,
outer joins, indexes, keys
PHP and MySQL Web Development, 217-263
(Chapters 9-10)
8
SQL continued. Connection to MySQL database from
PHP on the Web server. Web sites that are databases.
Database transactions via Web forms
PHP and MySQL Web Development, 265-283
(Chapter 11)
9
Sending email. Text substitution with regular
expressions. Example: Sending emails from mail list
service. Example: On-line classification system
PHP and MySQL Web Development, 507-521
(Chapter 24)
10
Dates. Example: Todo list service. Simple user
authentication. Community Web sites.
PHP and MySQL Web Development, 439-449
(Chapter 20)
11
Cookies and sessions. User authentication with
cookies. User tracking. Analysing user behavior.
PHP and MySQL Web Development, 479-494
(Chapter 22)
12
Advanced Web Programming Techniques.
Programming Web Applications with SMLserver.
Research paper: Web Programming with SMLserver
CSC 405: Web Application Engineering II
1.7