PHP Web Development with MySQL

slicedmitesSecurity

Feb 16, 2014 (3 years and 1 month ago)

67 views

PHP Web Development with MySQL

Course Outcome Summary

Course Information

Organization

Madison Area Technical College

Developers

Dean W Jefferson

Development Date

5/14/2007

Course Number

10-152-166

Instructional Level

Associate Degree

Potential Hours of
Instruction

72

Total Credits

3


Description
Students learn to create dynamic web pages using the PHP programming language and the
MySQL database management system. Students will learn how PHP works, how to effectively
use many of its powerful features, and how to design and build their own PHP web applications.
The popular MySQL open source database management software (DBMS) will also be
introduced as a powerful backend for PHP websites.CrLfCrLf


Target Population
This course is a required course in the IT Programmer/Analyst Associate Degree program. It is
targeted to those students and programming professionals as a first course in PHP programming
for dynamic websites with an introduction to the MySQL database management system.

Types of Instruction
Instruction Type Contact Hours Credits
Classroom Presentation

36

2

On-Campus lab

36

1


Textbooks
Ellie Quigley & Marko Gargenta. PHP and MySQL by Example. O'Reilly. Edition: 3.

Luke Welling & Laura Thomson. PHP and MySQL Web Development. O'Reilly. Edition: 3.


Learner Supplies
Java/PHP CD (can be purchased from MATC IT Association). Manufacturer: MATC Information
Technology Association. Quantity: 1. Source: MITA.


Prerequisites
Completed Introduction to Visual Basic.NET Programming, 10-152-101 with a grade of C or
better or consent of instructor

Completed Website Development - XHTML, 10-152-120 with a grade of C or better or consent of
instructor


Exit Learning Outcomes

Core Abilities
A.

Critical thinking

B.

Science and Technology


Competencies

Unit 1.

Introduction to PHP, MySQL and Web Applications

A.

Explore differences between static and dynamic web sites



Linked Core Abilities



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes dynamic web content



A.2. you distinguish between static and dynamic web pages



A.3. project includes dynamic web content

B.

Identify the advantages of using PHP language



Linked Core Abilities



Science and Technology



Learner will demonstrate competence:



B.1. through a written evaluation



Learner performance will be successful when:



B.1. you explain the features of the PHP language



B.2. you explain the advantages of the PHP language

C.

Identify the advantages of using MySQL database software



Linked Core Abilities



Science and Technology



Learner will demonstrate competence:



C.1. through a written evaluation



Learner performance will be successful when:



C.1. you explain the features of the MySQL database software



C.2. you explain the advantages of the MySQL database software

Unit 2.

Basic PHP Syntax: Data Types, Variables, Constants and Operators

A.

Write PHP scripts containing variables and constants



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes variables and constants used correctly in scripts



A.2. you interpret the use of PHP variables and constants, correctly predicting
statement results



A.3. project includes variables and constants used correctly in scripts

B.

Write PHP scripts using operators



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes PHP operators used correctly in scripts



B.2. you interpret the use of PHP operators, correctly predicting statement results



B.3. project includes PHP operators used correctly in scripts

Unit 3.

Basic PHP Syntax: Conditional Execution and Looping

A.

Write PHP scripts containing conditional execution



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes conditional execution statements used correctly in scripts



A.2. you interpret the use of PHP conditional execution statements, correctly
predicting statement results



A.3. project includes conditional execution statements used correctly in scripts

B.

Write PHP scripts using loops



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes PHP loop constructs used correctly in scripts



B.2. you interpret the use of PHP loop constructs, correctly predicting statement
results



B.3. project includes PHP loop constructs used correctly in scripts

Unit 4.

More PHP Syntax: Strings and String Manipulation

A.

Explore PHP syntax for creating and manipulating strings



Linked Core Abilities



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes PHP strings and string manipulation statements used
correctly in scripts



A.2. you interpret the use of PHP strings and string manipulation statements, correctly
predicting statement results



A.3. project includes PHP strings and string manipulation statements used correctly in
scripts

B.

Write PHP scripts that use strings and string manipulation functions



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes string manipulation functions used correctly in scripts



B.2. you interpret the use of PHP string manipulation functions, correctly predicting
statement results



B.3. project includes string manipulation functions used correctly in scripts

Unit 5.

Regular Expressions and Pattern Matching

A.

Explore PHP syntax for pattern matching using regular expressions



Linked Core Abilities



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes PHP pattern matching using regular expressions, used
correctly in scripts



A.2. you interpret the use of PHP pattern matching using regular expressions,
correctly predicting statement results



A.3. project includes PHP pattern matching using regular expressions, used correctly
in scripts

B.

Write PHP scripts that use built-in functions for pattern matching involving
regular expressions



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes PHP built-in functions for pattern matching involving regular
expressions, used correctly in scripts



B.2. you interpret the use of PHP built-in functions for pattern matching involving
regular expressions, correctly predicting statement results



B.3. project includes PHP built-in functions for pattern matching involving regular
expressions, used correctly in scripts

Unit 6.

Arrays, Associative Arrays and Manipulating Arrays

A.

Write PHP scripts containing simple arrays



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes simple arrays used correctly in scripts



A.2. you interpret the use of simple arrays, correctly predicting statement results



A.3. project includes simple arrays used correctly in scripts

B.

Write PHP scripts using associative arrays



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes associative arrays used correctly in scripts



B.2. you interpret the use of PHP associative arrays, correctly predicting statement
results



B.3. project includes associative arrays used correctly in scripts

C.

Write PHP scripts that use built-in functions to manipulate arrays



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



C.1. through an in-class lab exercise



C.2. through a written evaluation



C.3. through a programming project



Learner performance will be successful when:



C.1. lab exercise includes PHP built-in functions that manipulate arrays, used
correctly in scripts



C.2. you interpret the use of PHP built-in functions that manipulate arrays, correctly
predicting statement results



C.3. project includes PHP built-in functions that manipulate arrays, used correctly in
scripts

Unit 7.

Using HTML Forms with PHP

A.

Create HTML forms for use with PHP scripts



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes use of HTML forms with PHP scripts



A.2. you interpret the use of HTML forms with PHP scripts, correctly predicting
statement results



A.3. project includes use of HTML forms with PHP scripts

B.

Write PHP programs that use data from HTML forms



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes PHP scripts that accept and manipulate data from HTML
forms



B.2. you interpret the use of PHP scripts that accept and manipulate data from HTML
forms, correctly predicting statement results



B.3. project includes PHP scripts that accept and manipulate data from HTML forms

Unit 8.

Functions, User-Defined Functions and Reusing Code

A.

Write PHP scripts using built-in functions



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes PHP built-in functions used correctly in scripts



A.2. you interpret the use of PHP built-in functions, correctly predicting statement
results



A.3. project includes PHP built-in functions used correctly in scripts

B.

Write PHP scripts containing user-defined functions



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes user-defined functions used correctly in scripts



B.2. you interpret the use of PHP user-defined functions, correctly predicting
statement results



B.3. project includes user-defined functions used correctly in scripts

C.

Write PHP scripts that use the include and require directives to reuse code



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



C.1. through an in-class lab exercise



C.2. through a written evaluation



C.3. through a programming project



Learner performance will be successful when:



C.1. lab exercise includes use of the include and require directives to reuse code,
used correctly in scripts



C.2. you interpret the use of the include and require directives to reuse code, correctly
predicting statement results



C.3. project includes use of the include and require directives to reuse code, used
correctly in scripts

Unit 9.

Using Files, Streams and Directories

A.

Write PHP scripts using file input and output



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes file input and output used correctly in scripts



A.2. you interpret the use of PHP file input and output statements, correctly predicting
statement results



A.3. project includes file input and output used correctly in scripts

B.

Write PHP scripts using the PHP stream functions to handle input and output



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes use of the PHP stream functions to handle input and output,
used correctly in scripts



B.2. you interpret the use of PHP stream functions to handle input and outputs,
correctly predicting statement results



B.3. project includes use of the PHP stream functions to handle input and output,
used correctly in scripts

C.

Write PHP scripts that use directory manipulation functions



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



C.1. through an in-class lab exercise



C.2. through a written evaluation



C.3. through a programming project



Learner performance will be successful when:



C.1. lab exercise includes use of the directory manipulation functions, used correctly
in scripts



C.2. you interpret the use of the directory manipulation functions, correctly predicting
statement results



C.3. project includes use of the directory manipulation functions, used correctly in
scripts

Unit 10.

Object-Oriented PHP and Exception Handling

A.

Write PHP scripts using object-oriented constructs



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes PHP 5 object-oriented constructs



A.2. you interpret the use of PHP 5 object-oriented constructs, correctly predicting
statement results



A.3. project includes PHP 5 object-oriented constructs

B.

Write PHP scripts using the object-oriented Exception class for error handling



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes use of the object-oriented Exception class for error handling


B.2. you interpret the use of the PHP 5 object-oriented Exception class for error
handling, correctly predicting statement results



B.3. project includes use of the object-oriented Exception class for error handling

Unit 11.

Designing and Creating a Web Database Using MySQL

A.

Explore connecting to and using a MySQL database



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes connecting to and navigating a MySQL database



A.2. you interpret the command syntax for connecting to and using a MySQL
database, correctly predicting statement results



A.3. project includes connecting to and navigating a MySQL database

B.

Write SQL scripts to create and populate tables in a MySQL database



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes writing SQL scripts to create and populate tables in a
MySQL database



B.2. you interpret the use of SQL scripts to create and populate tables in a MySQL
database, correctly predicting statement results



B.3. project includes use of SQL scripts to create and populate tables in a MySQL
database

Unit 12.

Using PHP and MySQL Together

A.

Write PHP scripts that connect to and use a MySQL database



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes code that connects to and uses a MySQL database



A.2. you interpret the use of code that connects to and uses a MySQL database,
correctly predicting statement results



A.3. project includes code that connects to and uses a MySQL database

B.

Write PHP scripts that create and update both data and tables in a MySQL
database



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes constructs that create and update both data and tables in a
MySQL database



B.2. you interpret the use of constructs that create and update both data and tables in
a MySQL database, correctly predicting statement results



B.3. project includes constructs that create and update both data and tables in a
MySQL database

Unit 13.

Using Cookies and Session Control in PHP

A.

Write PHP scripts that use PHP built-in functions to set and retrieve HTTP
cookies



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise includes use of PHP built-in functions to set and retrieve HTTP
cookies



A.2. you interpret the use of PHP built-in functions to set and retrieve HTTP cookies



A.3. project includes use of PHP built-in functions to set and retrieve HTTP cookies

B.

Write PHP scripts that use PHP built-in functions to create and manage HTTP
sessions



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes use of PHP built-in functions to create and manage HTTP
sessions



B.2. you interpret the use of PHP built-in functions to create and manage HTTP
sessions, correctly predicting statement results



B.3. project includes use of PHP built-in functions to create and manage HTTP
sessions

Unit 14.

PHP Security and Debugging

A.

Write PHP scripts that demonstrate accepted PHP security practices



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



A.1. through an in-class lab exercise



A.2. through a written evaluation



A.3. through a programming project



Learner performance will be successful when:



A.1. lab exercise demonstrates accepted PHP security practices



A.2. you interpret the use of code employing accepted PHP security practices



A.3. project demonstrates accepted PHP security practices

B.

Write PHP scripts that use PHP debugging facilities to find and fix errors in code



Linked Core Abilities



Critical thinking



Science and Technology



Learner will demonstrate competence:



B.1. through an in-class lab exercise



B.2. through a written evaluation



B.3. through a programming project



Learner performance will be successful when:



B.1. lab exercise includes use of PHP debugging facilities to find and fix errors in code


B.2. you interpret the use of PHP debugging facilities to find and fix errors in code,
correctly predicting statement results



B.3. project includes use of PHP debugging facilities to find and fix errors in code