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)
-
Identify the advantages of using PHP and MySQL to implement authentication and secure transactionsAssessment Strategiesthrough a written evaluationCriteriayou explain the features of authentication for web applicationsyou explain the advantages of using PHP and MySQL for authenticationyou explain the advantages of using PHP and MySQL to implement secure transactions
-
Write PHP scripts using session control and MySQL for authentication of usersAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes session control and MySQL for authentication of users used correctly in scriptsyou interpret the use of PHP session control, correctly predicting statement resultsyou interpret the use session control and MySQL for authentication of users , correctly predicting statement resultsproject includes session control and MySQL for authentication of users used correctly in scripts
-
Write PHP scripts containing file system and server interactionAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes file system and server interaction used correctly in scriptsyou interpret the use of file system and server interaction statements, correctly predicting statement resultsproject includes file system and server interaction used correctly in scripts
-
Write PHP scripts using network and protocol functionsAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes network and protocol functions used correctly in scriptsyou interpret the use of network and protocol functions, correctly predicting statement resultsproject includes network and protocol functions used correctly in scripts
-
Write PHP scripts that use functions for managing the date and timeAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes functions for managing the date and time used correctly in scriptsyou interpret the use of functions for managing the date and time, correctly predicting statement resultsproject includes functions for managing the date and time used correctly in scripts
-
Write PHP scripts that use functions for generating imagesAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes functions for generating images used correctly in scriptsyou interpret the use of functions for generating images, correctly predicting statement resultsproject includes functions for generating images used correctly in scripts
-
Write PHP scripts containing custom error handlersAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes custom error handlers used correctly in scriptsyou interpret the use of custom error handlers, correctly predicting statement resultsproject includes custom error handlers used correctly in scripts
-
Write PHP scripts using debugging techniquesAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes debugging techniques used correctly in scriptsyou interpret the use of debugging techniques, correctly predicting statement resultsproject includes debugging techniques used correctly in scripts
-
Write PHP scripts using one or more template systems and using a framework as a way to manage a large projectAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes use of one or more template systemsyou interpret the use of one or more template systems, correctly predicting statement resultsyou interpret the use of a framework, correctly predicting statement resultsproject includes use of one or more template systems as a way to manage a large projectproject includes a framework as a way to manage a large project
-
Write PHP scripts that build and use web user authentication and personalizationAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes building and using web user authentication correctly in scriptsyou interpret the use of web user personalization, correctly predicting statement resultsyou interpret the use of web user authentication, correctly predicting statement resultsproject includes building and using web user authentication correctly in scripts
-
Write PHP scripts implementing a shopping cartAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes use of PHP and MySQL to implement a shopping cart, correctly in scriptsyou interpret the use of PHP and MySQL to implement a shopping cart, correctly predicting statement resultsproject includes use of PHP and MySQL to implement a shopping cart, correctly in scripts
-
Write PHP scripts that build a content management systemAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes implementing a content management systemyou interpret the use of PHP to build a content management system, correctly predicting statement resultsproject includes building a content management system
-
Write PHP scripts that use a framework to build a content management systemAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes use of a framework to build a content management systemyou interpret the use of a framework to build a content management system, correctly predicting statement resultsproject includes use of a framework to build a content management system
-
Write PHP scripts that build a web-based email service using templatesAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes implementing a web-based email service using templatesyou interpret the use of PHP to build a web-based email service using templates, correctly predicting statement resultsproject includes building a web-based email service using templates
-
Write PHP scripts that build a mailing list managerAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes code that implements a mailing list manageryou interpret the use of code that builds a mailing list manager, correctly predicting statement resultsproject includes code that builds a mailing list manager
-
Write PHP scripts that use a framework to build a mailing list managerAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes implementation of PHP code that uses a framework to build a mailing list manageryou interpret the use of constructs that use a framework to build a mailing list manager, correctly predicting statement resultsproject includes use of a framework to build a mailing list manager
-
Write PHP scripts that build web forumsAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes use of PHP to implement a web forumyou interpret the use of PHP to build web forums, correctly predicting statement resultsproject includes use of PHP to build web forums
-
Write PHP scripts that use a template system to build web forumsAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise includes use of a template system to build web forumsyou interpret the use of a template system to build web forums, correctly predicting statement resultsproject includes use of a template system to build web forums
-
Write PHP scripts that generate personalized documents using templates and PHP's PDF format generatorAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise generates personalized documents using templatesyou interpret the use of PHP to generate personalized documents using templatesyou interpret the use of PHP to generate personalized documents using PHP's PDF format generator, correctly predicting statement resultsproject generates personalized documents using templates
-
Write PHP scripts that connect to web services using XML and using SOAAssessment Strategiesthrough an in-class lab exercisethrough a written evaluationthrough a programming projectCriterialab exercise connects to web services using XMLyou interpret the use of PHP to connect to web services using XMLyou interpret the use of PHP to connect to web services using SOA, correctly predicting statement resultsproject connects to web services using XMLproject includes connecting to web services using SOA