Web App-PHP&SQL

CIS-2430-VO01 - Web Application Programming

Location: Online, 3 Credits

Day/Times: Meets online

Materials/Lab Fees: $0

Textbook: https://sites.google.com/site/jilmactraining/web-app-programming/php-textbook

and free sites like: Code Academy for Ruby and PHP training

Course Description:

This course provides an introduction to server-side scripting technologies for web development. These include CGI/Perl, PHP and at least one of the following: Active Server Pages, and/or Java Server Pages. Following an introduction to the selected scripting language, students will create scripts to generate dynamic web pages and to perform common server-side processing functions such as HTML forms and database processing.

Prerequisite: Programming for the Internet or written approval by the Instructor

Essential Objectives:

1. Explain the role and function of the various components of a web based application including the web browser, client-side scripting, web server, server-side scripting, and database and/or application servers.

2. Briefly describe the common gateway interface (CGI) specification and how it works.

3. Discuss the relative advantages and disadvantages of CGI as a server-side solution for web based applications.

4. Discuss the syntax and structure of the Perl language.

5. Discuss the syntax and structure of the PHP language.

6. Explain what CGI environment variables are and how they are used in CGI/Perl scripts.

7. Create CGI/Perl scripts that extract, process and store HTML form data in a database provided by the instructor.

8. Explain how HTML embedded technologies such as PHP, Active Server Pages/VBScript, and Java Server Pages differ from CGI/Perl.

9. Discuss the syntax and structure of an HTML embedded scripting language selected by the instructor which may include PHP, VBScript, or Java.

10. Using an HTML embedded technology, create web pages that extract, process and store HTML form data in a database provided by the instructor.

11. Develop and demonstrate a simple three tier web based application using an HTML embedded server-side technology selected by the instructor.