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

Credits

3

Semester Contact Hours Lecture

30

Semester Contact Hours Lab

30

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]

Credit Hours Narrative

3

Semester Contact Hours Lecture

30

Semester Contact Hours Lab

30

Grading Method

Letter grade

Repeatable

N

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