CISW 129 Web Programming with PHP
Students will use the PHP scripting language to create web applications with database connectivity. The course includes a discussion of the MySQL database management system and fundamental aspects of the Apache open-source web server
General Education Competency
[GE Core type]
CISW 129Web Programming with PHP
Please note: This is not a course syllabus. A course syllabus is unique to a particular section of a course by instructor. This curriculum guide provides general information about a course.
I. General Information
Department
Information Technology
II. Course Specification
Course Type
Program Requirement
General Education Competency
[GE Core type]
Semester Contact Hours Lecture
30
Semester Contact Hours Lab
30
Grading Method
Letter grade
III. Catalog Course Description
Students will use the PHP scripting language to create web applications with database connectivity. The course includes a discussion of the MySQL database management system and fundamental aspects of the Apache open-source web server
IV. Student Learning Outcomes
Upon completion of this course, a student will be able to:
- Introduction to PHP and Server Side Scripting
- Students will be introduced to the ideas of PHP and server side scripting.
- Writing PHP
- Students will write a basic PHP program. They will be introduced to the style and syntax of PHP.
- Processing Client Data
- Students will review HTML forms and then learn how to retrieve client inputted data with PHP.
- Decision Making
- Students will learn about Boolean Values and Operators. The will learn how to make decision making statements using if, else, else if, and switch statements.
- Loops and Arrays
- Students will learn the while, do while, and for loop statements. They will be introduced to Arrays and learn how to use them in loops.
- Functions and Programming Techniques
- Learning good programming techniques is essential to being productive. Students will learn some good techniques for reusing code.They will implement this through functions, global and local variables, and include files.
- Error Handling
- This section will build on the programming techniques learned in the last section. Students will learn how to handle and avoid errors in PHP. They will learn how to debug existing scripts and some techniques that will help them avoid making common mistakes.
- Working with the Client
- Students will learn how to effectively use query strings, sessions, and cookies to make a better experience for the end user.
- MySQL
- Students will learn about MySQL. They will install MySQL and test their installation.They will build users and make a basic database with the PHPMyAdmin, MySQL client.
V. Topical Outline (Course Content)
Introducing server side programming
Initial environment setup
Creating a first page
Combining PHP and HTML
MySQL
Brief introduction to databases
Connecting to a database with PHP
Querying data best practices
Forms and program design
Creating interactive forms
Retrieving and interacting with user submitted data
Best practices for project design – MVC pattern
User Tracking
Cookies use and best practices
Sessions use and best practices
Authentication
Getting credentials from the user
Best practices for password storage
HTTPS basic primer
Putting it all together
Managing a project at size
Creating a final project
VI. Delivery Methodologies
Required Assignments
Incremental programming tasks for each unit
Required Exams
Final comprehensive project
Required Materials
Murach’s PHP and MySQL, by Joel Murach and Ray Harris
Specific Course Activity Assignment or Assessment Requirements
Incremental programming tasks for each unit Final comprehensive project