WDV 341 - Intro PHP

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.