10152166PHP Web Development with MySQL
Course Information
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.
Total Credits
3
Course Competencies
  1. Explore differences between static and dynamic web sites
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes dynamic web content
    you distinguish between static and dynamic web pages
    project includes dynamic web content

  2. Identify the advantages of using PHP language
    Assessment Strategies
    through a written evaluation
    Criteria
    you explain the features of the PHP language
    you explain the advantages of the PHP language

  3. Identify the advantages of using MySQL database software
    Assessment Strategies
    through a written evaluation
    Criteria
    you explain the features of the MySQL database software
    you explain the advantages of the MySQL database software

  4. Write PHP scripts containing variables and constants
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes variables and constants used correctly in scripts
    you interpret the use of PHP variables and constants, correctly predicting statement results
    project includes variables and constants used correctly in scripts

  5. Write PHP scripts using operators
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes PHP operators used correctly in scripts
    you interpret the use of PHP operators, correctly predicting statement results
    project includes PHP operators used correctly in scripts

  6. Write PHP scripts containing conditional execution
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes conditional execution statements used correctly in scripts
    you interpret the use of PHP conditional execution statements, correctly predicting statement results
    project includes conditional execution statements used correctly in scripts

  7. Write PHP scripts using loops
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes PHP loop constructs used correctly in scripts
    you interpret the use of PHP loop constructs, correctly predicting statement results
    project includes PHP loop constructs used correctly in scripts

  8. Explore PHP syntax for creating and manipulating strings
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes PHP strings and string manipulation statements used correctly in scripts
    you interpret the use of PHP strings and string manipulation statements, correctly predicting statement results
    project includes PHP strings and string manipulation statements used correctly in scripts

  9. Write PHP scripts that use strings and string manipulation functions
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes string manipulation functions used correctly in scripts
    you interpret the use of PHP string manipulation functions, correctly predicting statement results
    project includes string manipulation functions used correctly in scripts

  10. Explore PHP syntax for pattern matching using regular expressions
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes PHP pattern matching using regular expressions, used correctly in scripts
    you interpret the use of PHP pattern matching using regular expressions, correctly predicting statement results
    project includes PHP pattern matching using regular expressions, used correctly in scripts

  11. Write PHP scripts that use built-in functions for pattern matching involving regular expressions
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes PHP built-in functions for pattern matching involving regular expressions, used correctly in scripts
    you interpret the use of PHP built-in functions for pattern matching involving regular expressions, correctly predicting statement results
    project includes PHP built-in functions for pattern matching involving regular expressions, used correctly in scripts

  12. Write PHP scripts containing simple arrays
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes simple arrays used correctly in scripts
    you interpret the use of simple arrays, correctly predicting statement results
    project includes simple arrays used correctly in scripts

  13. Write PHP scripts using associative arrays
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes associative arrays used correctly in scripts
    you interpret the use of PHP associative arrays, correctly predicting statement results
    project includes associative arrays used correctly in scripts

  14. Write PHP scripts that use built-in functions to manipulate arrays
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes PHP built-in functions that manipulate arrays, used correctly in scripts
    you interpret the use of PHP built-in functions that manipulate arrays, correctly predicting statement results
    project includes PHP built-in functions that manipulate arrays, used correctly in scripts

  15. Create HTML forms for use with PHP scripts
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of HTML forms with PHP scripts
    you interpret the use of HTML forms with PHP scripts, correctly predicting statement results
    project includes use of HTML forms with PHP scripts

  16. Write PHP programs that use data from HTML forms
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes PHP scripts that accept and manipulate data from HTML forms
    you interpret the use of PHP scripts that accept and manipulate data from HTML forms, correctly predicting statement results
    project includes PHP scripts that accept and manipulate data from HTML forms

  17. Write PHP scripts using built-in functions
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes PHP built-in functions used correctly in scripts
    you interpret the use of PHP built-in functions, correctly predicting statement results
    project includes PHP built-in functions used correctly in scripts

  18. Write PHP scripts containing user-defined functions
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes user-defined functions used correctly in scripts
    you interpret the use of PHP user-defined functions, correctly predicting statement results
    project includes user-defined functions used correctly in scripts

  19. Write PHP scripts that use the include and require directives to reuse code
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of the include and require directives to reuse code, used correctly in scripts
    you interpret the use of the include and require directives to reuse code, correctly predicting statement results
    project includes use of the include and require directives to reuse code, used correctly in scripts

  20. Write PHP scripts using file input and output
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes file input and output used correctly in scripts
    you interpret the use of PHP file input and output statements, correctly predicting statement results
    project includes file input and output used correctly in scripts

  21. Write PHP scripts using the PHP stream functions to handle input and output
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of the PHP stream functions to handle input and output, used correctly in scripts
    you interpret the use of PHP stream functions to handle input and outputs, correctly predicting statement results
    project includes use of the PHP stream functions to handle input and output, used correctly in scripts

  22. Write PHP scripts that use directory manipulation functions
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of the directory manipulation functions, used correctly in scripts
    you interpret the use of the directory manipulation functions, correctly predicting statement results
    project includes use of the directory manipulation functions, used correctly in scripts

  23. Write PHP scripts using object-oriented constructs
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes PHP 5 object-oriented constructs
    you interpret the use of PHP 5 object-oriented constructs, correctly predicting statement results
    project includes PHP 5 object-oriented constructs

  24. Write PHP scripts using the object-oriented Exception class for error handling
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of the object-oriented Exception class for error handling
    you interpret the use of the PHP 5 object-oriented Exception class for error handling, correctly predicting statement results
    project includes use of the object-oriented Exception class for error handling

  25. Explore connecting to and using a MySQL database
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes connecting to and navigating a MySQL database
    you interpret the command syntax for connecting to and using a MySQL database, correctly predicting statement results
    project includes connecting to and navigating a MySQL database

  26. Write SQL scripts to create and populate tables in a MySQL database
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes writing SQL scripts to create and populate tables in a MySQL database
    you interpret the use of SQL scripts to create and populate tables in a MySQL database, correctly predicting statement results
    project includes use of SQL scripts to create and populate tables in a MySQL database

  27. Write PHP scripts that connect to and use a MySQL database
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes code that connects to and uses a MySQL database
    you interpret the use of code that connects to and uses a MySQL database, correctly predicting statement results
    project includes code that connects to and uses a MySQL database

  28. Write PHP scripts that create and update both data and tables in a MySQL database
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes constructs that create and update both data and tables in a MySQL database
    you interpret the use of constructs that create and update both data and tables in a MySQL database, correctly predicting statement results
    project includes constructs that create and update both data and tables in a MySQL database

  29. Write PHP scripts that use PHP built-in functions to set and retrieve HTTP cookies
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of PHP built-in functions to set and retrieve HTTP cookies
    you interpret the use of PHP built-in functions to set and retrieve HTTP cookies
    project includes use of PHP built-in functions to set and retrieve HTTP cookies

  30. Write PHP scripts that use PHP built-in functions to create and manage HTTP sessions
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of PHP built-in functions to create and manage HTTP sessions
    you interpret the use of PHP built-in functions to create and manage HTTP sessions, correctly predicting statement results
    project includes use of PHP built-in functions to create and manage HTTP sessions

  31. Write PHP scripts that demonstrate accepted PHP security practices
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise demonstrates accepted PHP security practices
    you interpret the use of code employing accepted PHP security practices
    project demonstrates accepted PHP security practices

  32. Write PHP scripts that use PHP debugging facilities to find and fix errors in code
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of PHP debugging facilities to find and fix errors in code
    you interpret the use of PHP debugging facilities to find and fix errors in code, correctly predicting statement results
    project includes use of PHP debugging facilities to find and fix errors in code