CIT 3301 INTERNET APPLICATION PROGRAMMING
Contact Hours 45
Pre requisite Fundamentals of Internet
Purpose of the Course
To introduce a learner to programming dynamic web sites using PHP and MySQL (or an
equivalent proprietary/open source environment).
Expected Learning Outcomes
At the end of the course the learner will be able to:
• Demonstrate understanding in PUP, ASP and MySQL programming and integration or any
equivalent
• Demonstrate understanding of PHP and MySql programming and, integration or
equivalent.
• Create dynamic web sites and on-line transactions using PHP, ASP and MySql techniques;
• Integrate the system with different programming languages and scripting.
Course Content
WEEK MAIN TOPIC SUB TOPICS/ LECTURES
Week 1 Introduction to • Overview of Internet programming
Internet • Understanding the significance of web
Programming development
and Internet • Introduction to internet protocols and services
Protocols • Understanding TCP/IP and FTP (File Transfer
Protocol)
• Key concepts of internet communication
Week 2 Working with • Introduction to HTML
HTML – Basics • Browser-client communication
• Structure of an HTML document
• Basic HTML tags and formatting text
• Paragraphs, headings, and block elements
Week 3 HTML Lists, • Creating lists in HTML (ordered, unordered)
Graphics, and • Inserting and managing images/graphics in
Tables HTML
• Building tables in HTML
Week 4 HTML Frames • Working with frames in HTML
and Documents • Linking documents and creating references
Reference • Structuring multi-page websites
Week 5 CAT 1
Week 6 CSS (Cascading • Introduction to CSS
Style Sheets) – • Understanding CSS elements and structure
Basics • Inline, internal, and external CSS
Week 7 JavaScript • Introduction to JavaScript
Programming – • Data types and variables in JavaScript
Basics (Part 1) • Using input/output statements in JavaScript
Week 8 JavaScript – • Control statements (if, else, loops, switch)
Control • Writing functions in JavaScript
Statements and • Passing parameters to functions
Functions (Part
2)
Week 9 Document Object •Introduction to DOM
Model (DOM) in •How JavaScript interacts with HTML elements
JavaScript •Manipulating DOM elements dynamically
Week 10 Introduction to •Basics of SQL and relational databases
SQL •Writing basic SQL queries: SELECT, INSERT,
UPDATE, DELETE
• Understanding primary keys, foreign keys, and
relationships
• Working with SQL to retrieve and manipulate
data
Week 11 Introduction to • Introduction to PHP and embedding PHP in
PHP (Part 1) HTML
• PHP syntax, variables, and control structures (if,
loops, etc.)
• Handling user input from HTML forms with PHP
Week 12 PHP and MySQL • Connecting PHP to MySQL databases
Integration (Part • Performing CRUD operations in PHP and
2) MySQL
• Advanced PHP features: sessions, cookies, and
form handling
Week 13 Introduction to • Introduction to ASP (Active Server Pages) and
ASP and Web how it works
Servers • Embedding ASP with HTML
• Using ASP to interact with databases (e.g., using
ADO)
• Web server installation and configuration (IIS for
ASP)
• Basic ASP syntax, control structures, and session
management
Week 14 & 15 Course Review and Final Exams
Mode of delivery
• Lectures
• Practical and tutorial sessions in Computer Laboratory
• Individual and group assignments
• Class exercises
• Project work
Instructional Materials
Overhead projector and computer, handouts, white boards, appropriate software, PCs and
access to a Web server and a database server.
Course Assessment
Type Weighting (%)
Examination 70%
Continuous Assessment 30%
Total 100%
Core Reading Material
1. PHP and MySQL Web Development, Welling and Thompson, Sams, ISBN: 0672317842,
978-0672317842
2. Beginning PHP and MySQL: From Novice to Professional, Jason Gilmore, Apress (2008),
ISBN: 1590598628, 978-1590598627
Recommended reference material
1. PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide, 2007), ISBN: 978-
0321525994
NAME OF THE LECTURER SIGNATURE DATE
KAJE DAVID MURITHI 01/09/2025