Mar 29, 2024  
2018-2019 Course Catalog 
    
2018-2019 Course Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

WDV 341 - Intro PHP

Credits: 3
Lecture Hours: 2
Lab Hours: 2
Practicum Hours: 0
Work Experience: 0
Course Type: Voc/Tech
This course will introduce PHP as a server-side scripting language. It will introduce the MySQL database and the SQL language for use with PHP. Students will embed PHP and SQL code into HTML pages and publish them to a PHP-enabled server. Students will create a web application that will allow for user login pages, as well as add, delete and update database content to web pages.
Prerequisite: WDV 101  and WDV 221  
Competencies
  1. Discuss server side scripting within a website application.
    1. Define server side scripting.
    2. Explain the role of server side scripting languages.
    3. Identify server side scripting languages in the industry.
    4. Review the strengths and weaknesses of the various server side scripting languages.
    5. Discuss how server side scripting is used to provide dynamic content to a website application using databases.
  2. Demonstrate PHP as a server side scripting language for website development.
    1. Define PHP.
    2. Explain the strengths and weaknesses of PHP.
    3. Identify the system requirements to run PHP scripting code.
    4. Explain the interaction of PHP and HTML within a website application.
    5. Explain the syntax structure of PHP.
    6. Write decision logic in PHP.
    7. Write for and while loops in PHP.
  3. Discuss the MySQL database.
    1. Define an SQL relational database.
    2. Discuss the role of the database.
    3. Explain the primary parts of a database.
  4. Discuss SQL.
    1. Define SQL.
    2. Identify the role of SQL.
    3. Explain the primary commands of SQL.
  5. Demonstrate the use of MySQL.
    1. Discuss the use of the PHPAdmin tool for use with MySQL.
    2. Create a database using PHPAdmin.
    3. Create tables in a database using PHPAdmin.
    4. Update tables in a database using PHPAdmin.
    5. Delete tables in a database using PHPAdmin.
  6. Demonstrate the use of SQL within PHP.
    1. Write SQL to add rows to a table.
    2. Write SQL to modify rows in a table.
    3. Write SQL to delete rows from a table.
    4. Write SQL to access data from the database .
    5. Write SQL to modify data within a table of a database.
  7. Use PHP, MySQL and SQL to implement the following functionality in a website application.
    1. Write a user signon script that will validate the username and password.
    2. Write a script that will access data from the database and format it for delivery to the client web page.
    3. Write a script that will allow the user to modify data on the database .
    4. Write a script that will allow the user to delete data from the database.
  8. Create a multi page commercially oriented website application.
    1. Analyze the purpose and requirements of the business.
    2. Identify appropriate functionality for the application.
    3. Investigate the required tools and techniques to implement the functionality.
    4. Use the concepts and techniques from the course to write the application.
    5. Implement the website application on an Internet server or a commercial web server.



Add to Portfolio (opens a new window)