CTP 130 - Programming in PHP/MySQL

3 credit hours - Two hours of lecture and two hours of laboratory weekly; one term.
Formerly CSI 138 - Programming in PHP/MySQL

Use fundamental design principles and problem-solving techniques introduced in CTP 115 to develop Web applications using PHP server-side scripting language and the MySQL relational database management system. Participate in hands-on activities to learn topics that include Web application concepts and environments, PHP language structure, relational database concepts, and techniques to develop Web applications that include database management systems and user interaction.

Prerequisite(s): CTP 115 and CTP 118 or permission of CTP department chair.

Note: Typically offered OL; fall and spring terms.

Course Outcomes:

Use Client/Server architecture.
Use Client-Side Scripting.
Use Server-Side Scripting.
Install a Web Server.
Install PHP.
Install MySQL.
Test a Web development environment.
Structure a PHP Script.
Use data types.
Use operators.
Use control structures.
Write functions.
Use strings in PHP scripts.
Use arrays.
Work With files.
Use relational database concepts.
Use Structured Query Language.
Use a MySQL Database.
Manage user accounts.
Manage databases, tables and records.
Connect to a database.
Execute SQL Commands.
Add, delete, and update records.
Use cookies to preserve state.
Use sessions to preserve state.
Use encapsulation and classes.
Define and use PHP classes.
Use syntax, logic, and run-time errors.
Use reporting errors.
Apply common debugging techniques.