10152196PHP and MySQL Programming
Course Information
Description
Introduction to PHP and MySQL. PHP is an open source C-like language for server-side web page programming, and MySQL is a full-featured open source database. We develop the basics of PHP programming, including variables, control, functions, arrays, classes and file I/O. Students develop a robust shopping cart application for an online bookstore, including initial database construction using web services, a web search engine, user authentication, payment handling through Paypal's sandbox and transaction storage. This course an elective for the Internet Developer Certificate.
Total Credits
3
Course Competencies
  1. Download and install PHP and MySQL.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.

  2. Write a PHP web application.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.

  3. Become familiar with and use PHP variables, flow, conditions, functions, and arrays.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.

  4. Send and receive HTTP parameters through PHP.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.

  5. Parse XML in PHP, including from external web services.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.

  6. Write a web search engine in PHP.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.

  7. Write a shopping cart in PHP.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.

  8. Use session variables in PHP.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.

  9. Write code to add support for user authentication in PHP.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.

  10. Use PHP to interface with external sites.
    Assessment Strategies
    by completing various projects and assignments
    through writing and interfacing various applications connected to weekly projects
    Criteria
    you perform tasks and assignments as designed and explained in the course handout.
    you successfully build a shopping cart and successfully apply course concepts.