10152167Advanced PHP and MySQL Web Development
Course Information
Description
This course prepares the student to implement professional PHP and MySQL web applications. Students will learn advanced techniques for session management, validation, and authentication. Advanced web application features such as shopping carts, content management, web forums and connecting to web services are discussed. Installation and customization of open source PHP web applications are also covered.
Total Credits
3
Course Competencies
  1. Explore different ways to implement authentication
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise implements PHP and MySQL authentication
    you distinguish between authentication methods
    project implements PHP and MySQL authentication

  2. Identify the advantages of using PHP and MySQL to implement authentication
    Assessment Strategies
    through a written evaluation
    Criteria
    you explain the features of authentication for web applications
    you explain the advantages of using PHP and MySQL for authentication

  3. Identify the advantages of using PHP and MySQL to implement secure transactions
    Assessment Strategies
    through a written evaluation
    Criteria
    you explain how to implement secure transactions using PHP and MySQL
    you explain the advantages of using PHP and MySQL to implement secure transactions

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

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

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

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

  8. Write PHP scripts that use functions for managing the date and time
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes functions for managing the date and time used correctly in scripts
    you interpret the use of functions for managing the date and time, correctly predicting statement results
    project includes functions for managing the date and time used correctly in scripts

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

  10. Explore advanced MySQL programming techniques
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes advanced MySQL programming techniques, used correctly in scripts
    you interpret the use of advanced MySQL programming techniques, correctly predicting statement results
    project includes advanced MySQL programming techniques, used correctly in scripts

  11. Write MySQL scripts that use advanced MySQL administration practices
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes advanced MySQL administration practices
    you interpret the use of advanced MySQL administration practices, correctly predicting statement results
    project includes advanced MySQL administration practices

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

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

  14. Write PHP scripts using one or more template systems as a way to manage a large project
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of one or more template systems
    you interpret the use of one or more template systems, correctly predicting statement results
    project includes use of one or more template systems as a way to manage a large project

  15. Write PHP scripts using a framework as a way to manage a large project
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of a framework
    you interpret the use of a framework, correctly predicting statement results
    project includes a framework as a way to manage a large project

  16. Write PHP scripts that build and use web user authentication
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes building and using web user authentication correctly in scripts
    you interpret the use of web user authentication, correctly predicting statement results
    project includes building and using web user authentication correctly in scripts

  17. Write PHP scripts that build and use web user personalization
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes building and using web user personalization correctly in scripts
    you interpret the use of web user personalization, correctly predicting statement results
    project includes building and using web user personalization correctly in scripts

  18. Explore PHP scripts that build and use an electronic shopping cart
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes an electronic shopping cart used correctly in scripts
    you interpret the use of an electronic shopping cart, correctly predicting statement results
    project includes an electronic shopping cart used correctly in scripts

  19. Write PHP scripts implementing a shopping cart
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of PHP and MySQL to implement a shopping cart, correctly in scripts
    you interpret the use of PHP and MySQL to implement a shopping cart, correctly predicting statement results
    project includes use of PHP and MySQL to implement a shopping cart, correctly in scripts

  20. Write PHP scripts that build a content management system
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes implementing a content management system
    you interpret the use of PHP to build a content management system, correctly predicting statement results
    project includes building a content management system

  21. Write PHP scripts that use a framework to build a content management system
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of a framework to build a content management system
    you interpret the use of a framework to build a content management system, correctly predicting statement results
    project includes use of a framework to build a content management system

  22. Explore the building of a web-based email service
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes implementing a web-based email service
    you interpret the PHP code for building a web-based email service, correctly predicting statement results
    project includes the building of a web-based email service

  23. Write PHP scripts that build a web-based email service using templates
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes implementing a web-based email service using templates
    you interpret the use of PHP to build a web-based email service using templates, correctly predicting statement results
    project includes building a web-based email service using templates

  24. Write PHP scripts that build a mailing list manager
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes code that implements a mailing list manager
    you interpret the use of code that builds a mailing list manager, correctly predicting statement results
    project includes code that builds a mailing list manager

  25. Write PHP scripts that use a framework to build a mailing list manager
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes implementation of PHP code that uses a framework to build a mailing list manager
    you interpret the use of constructs that use a framework to build a mailing list manager, correctly predicting statement results
    project includes use of a framework to build a mailing list manager

  26. Write PHP scripts that build web forums
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of PHP to implement a web forum
    you interpret the use of PHP to build web forums, correctly predicting statement results
    project includes use of PHP to build web forums

  27. Write PHP scripts that use a template system to build web forums
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes use of a template system to build web forums
    you interpret the use of a template system to build web forums, correctly predicting statement results
    project includes use of a template system to build web forums

  28. Write PHP scripts that generate personalized documents using templates
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise generates personalized documents using templates
    you interpret the use of PHP to generate personalized documents using templates
    project generates personalized documents using templates

  29. Write PHP scripts that generate personalized documents using PHP's PDF format generator
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes generating personalized documents using PHP's PDF format generator
    you interpret the use of PHP to generate personalized documents using PHP's PDF format generator, correctly predicting statement results
    project includes generating personalized documents using PHP's PDF format generator

  30. Write PHP scripts that connect to web services using XML
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise connects to web services using XML
    you interpret the use of PHP to connect to web services using XML
    project connects to web services using XML

  31. Write PHP scripts that connect to web services using SOA
    Assessment Strategies
    through an in-class lab exercise
    through a written evaluation
    through a programming project
    Criteria
    lab exercise includes connecting to web services using SOA
    you interpret the use of PHP to connect to web services using SOA, correctly predicting statement results
    project includes connecting to web services using SOA