Skip to main content
10152167 Advanced 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.  Students will also learn how to create and deploy a LAMP stack locally and remotely to a dedicated hosting platform. Advanced web application features such as PDO, content management using WordPress, customizing WordPress, and creating web services are discussed. Installation and customization of open source PHP web applications are also covered.
Total Credits
3

Course Competencies (Course Outcomes)
  1. Identify the advantages of using PHP and MySQL to implement authentication and secure transactions
    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
    you explain the advantages of using PHP and MySQL to implement secure transactions

  2. 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 of PHP session control, correctly predicting statement results
    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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. Write PHP scripts using one or more template systems and 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 one or more template systems
    you interpret the use of one or more template systems, correctly predicting statement results
    you interpret the use of a framework, correctly predicting statement results
    project includes use of one or more template systems as a way to manage a large project
    project includes a framework as a way to manage a large project

  10. Write PHP scripts that build and use web user authentication and 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 authentication correctly in scripts
    you interpret the use of web user personalization, correctly predicting statement results
    you interpret the use of web user authentication, correctly predicting statement results
    project includes building and using web user authentication correctly in scripts

  11. 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

  12. 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

  13. 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

  14. 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

  15. 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

  16. 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

  17. 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

  18. 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

  19. Write PHP scripts that generate personalized documents using templates and PHP's PDF format generator
    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
    you interpret the use of PHP to generate personalized documents using PHP's PDF format generator, correctly predicting statement results
    project generates personalized documents using templates

  20. Write PHP scripts that connect to web services using XML and using SOA
    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
    you interpret the use of PHP to connect to web services using SOA, correctly predicting statement results
    project connects to web services using XML
    project includes connecting to web services using SOA