Web Application Development w/ PHP & MySQL


Web Application Development w/ PHP & MySQL

Pace University's Continuing and Professional Education offers some of the most comprehensive and cutting edge web and digital graphic design programs in the Metropolitan New York area and even the US. This course will focus on building web applications using open source technologies PHP and MySQL.

For career changers or entry level students all the way through advanced and experienced web designers, Pace has a program to support your career and advance your job skills for today's job market and employment needs.
Web Application Development w/ PHP & MySQL

Date: October 6th, 2014- January 28th, 2015

Sessions: 24 Monday & Wednesday evenings 6pm-9pm

Fee: $2,950.00

Location: 551 Fifth Avenue 8th Floor New York, NY

Course Number: 90731


Course Description


Click for Detailed Course Description


You Will Learn To

Students will extend their knowledge of HTML, CSS (Web Design) to build Web Applications using open source technologies such as PHP and mySQL. Students will work on building one to two web applications throughout the class and will be required to build a separate web application as part of their final project.

Students will also learn how to use the latest technologies such as HTML5 and CSS3 to create web apps that can be consumed by smart phones and other digital devices .


Who Should Enroll

Students who have completed the Certificate in Adobe Web Design program (see course description) or equivalent experience or knowledge should enroll in this program. You should have enough time outside of class to complete assignments and projects.

Intermediate to strong skills in Adobe Dreamweaver or HTML required. PHP knowledge is useful and knowledge and use of other Adobe tools such as Photoshop, Illustrator and / or Flash may be helpful.  Students must have some programming experience or background.


Course Format

This dynamic hands-on course delivers 72 hours of classroom instruction supplemented with outside class assignments The Certificate in Web Application Development class meets twice per week on Monday and Wednesday evenings at our Midtown Center (New York, NY ). This is an instructor-led course taught by Adobe Certified Expert instructors.

COST: $2950

Evening class hours are from 6:00 pm to 9:00 pm (3 hours per class) Six hours per week for 12 weeks. Total Web Application Development classroom hours - 72 hours.

Location: 551 5th Ave (at 45th Street), 8th Floor, New York, NY 10176

View Larger Map



Please contact us at (888) 561-7223 or continuinged@pace.edu


Chapter 1
What is a Dynamic Driven Web Site?
Defining a PHP site
Starting the first project (apartment finder)
A first PHP Web page

Chapter 3
PHP conditional logic (IF)
Importing CSV data into MySQL
Using MySQL through the phpMyAdmin screen
Using Dreamweaver’s Database panel to connect to MySQL using SQL
SQL basics

Chapter 5
Master Detail page sets
Creating Search box capabilities (keyword search)

Chapter 7
Starting the second project (art gallery)
Importing data into MySQL
Review of Master Detail page sets
PHP User-defined functions

Chapter 9
Conditional Concatenation (Multiple criteria in SQL using PHP)
Create a multi-criteria search page

Chapter 11
Create a database Content management System (CMS)
Advanced SQL (Insert, delete, update records)

Chapter 2
PHP variables and formulas
Creating a CSS3 style sheet
Passing a value from one Web page to another

Chapter 4
Server behaviors
PHP loops and repeating regions
Record set paging
Dynamic lists and dynamic hyperlinks
Details pages
Passing multiple values to another Web page

Chapter 6
Relational databases
Data types
Primary keys
Foreign keys
Intermediate SQL

Chapter 8
Review relational database design
Searches using a drop-down list
Multi-table SQL

Chapter 10

Dynamic list menus
Multi-criteria search amongst multiple tables
Advanced filters using conditional concatenation

Chapter 12
User authentication and password protection
Session variables
** additonal information to be posted soon (by 8/15/2014)