Adv Web Development

CIS-1152 Advanced Web Development 3 Credits

This course teaches students how to implement, monitor, and deploy a complete website and integrate the website with a database. The emphasis is on the PHP language and server-side processing. JavaScript is used when it is suited to the desired task. Topics include authentication methods; form processing; form validation using HTML 5, JavaScript, and PHP; an overview of databases; PHP functions to interface with a database; and website security. Prerequisite: CIS-1151 Website Development. Recommended prior learning: CIS-2140 Programming for the Internet.

EO's - Essential Objectives for this course.

1. Describe the principles of PHP and relate how a server-side scripting language works.

2. Explain the basic syntax of PHP, including Variables, Constants, Datatypes, Operators and Control Structures, Looping Statements, Arrays and Foreach Loop.

3. Construct functions in PHP.

4. Employ PHP to manipulate files, work with arrays and handle form data.

5. Describe how MySQL works, including Datatypes, Constraints, Select, Order By, and Limit.

6. Examine the four basic actions that cover how we interact with the data and structures or CRUD.

7. Construct and run a MySQL query using phpMyAdmin.

8. Illustrate user authentication and session management with PHP.

9. Demonstrate basics of database management through phpMyAdmin.

10. Create dynamic interactive web pages and applications with PHP.

=================================================================================

If you need a refresher for CIS-1151 Web Development https://frontendmasters.com/bootcamp/

CIS-1152 is a Fast Track to Learning PHP & MySQL and how to incorporate the Server Side of a Web site

Previously students would have taken :

• CIS-2430 - Web Application Programming -JilMac refers to this class as the PHP class - because the emphasis is SERVER SIDE Development

• AND

• CIS 1360 Database Management Systems (Jane Adams-Fall2018-onLine)

  • or

• CIS 2340 SQL Database Administration (Jane Adams-Fall 2018 OnLine )

• Combined with WordPress -

STUDENT RESOURCES:

Canvas Support: https://vsc.zoom.us/my/canvassupport

HTML Refreshers

CodeAcademy: https://www.youtube.com/watch?v=47GaFnnex5w&feature=youtu.be

Jen Kramer & Front End Masters: https://frontendmasters.com/sale/trial/ Free - 3 classes for signing up

CCV Help Desk https://support.ccv.edu/general/ccv-it-staff-hours/

On Line Advisor: Ted Pappadopoulos, Academic Services Coordinator & Online Liaison for Workforce Development Center For Online Learning

660 Elm St, PO Box 489, Montpelier, VT 05601

802-828-0467

On Line Tutoring with http://Tutoring.com https://now.ccv.edu/talking-tutoring-ccv-launches-new-online-service/

CMS - https://www.risevision.com/ Used at Winowski

Teacher Text Book Resources https://hartness.vsc.edu/faculty/lim/

============Previous Text Book used for PHP class ===============

CIS-2430-VO01 - Web Application Programming

Location: Online, 3 Credits

Day/Times: Meets online

Instructor: Jil MacMenamin

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.