Order By Display Density
Note! Payment is due at time of registration.

Web Development Web Design

XCWW 1001 - pHp and MySQL for Dynamic Web Sites

When static HTML pages no longer cut it, you need to step up to dynamic, database-driven sites that represent the future of the Web. Explore the way users work with pHp and MySQL to build dynamic sites using Open Source tools. Work with pHp and MySQL separately before going on to cover security, sessions and cookies, and using additional Web tools. Finish the class by creating sample applicationsThis class is also part of the Web Developer Smart Package. Take all of the classes in this package at a 30% discount off the full price. For details visit the Smart Package store.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: HTML and CSS Advanced, Programming Fundamentals, Access Intermediate or comparable knowledge.

CEU Hours: 2.8

Contact Hours: 28

Course Outline

Introduction to PHP
1.	Basic Syntax
2.	Sending data to a Web browser
3.	Writing Comments
4.	What are variables, stings, numbers, and constants

Programming with PHP
1.	Creating an HTML form
2.	Managing magic quotes
3.	Conditionals and operators
4.	Validating form data
5.	Arrays and Loops

Creating Dynamic Web Sites
1.	Using external files
2.	Sending Email
3.	Date and time functions

Introduction to SQL and MySQL
1.	Designing tables
2.	Inserting records
3.	Selecting data
4.	Using Like and Not Like
5.	Queries

Advanced SQL and MySQL
1.	Performing joins
2.	Using Functions

Using PHP and MySQL
1.	Making the template
2.	Connecting to MySQL
3.	Error handling
4.	Executing and retrieving queries
5.	Updating records with PHP

Cookies and Sessions

Security
1.	HTTP authentication
2.	Form validation with JavaScript
3.	Regular expressions

Web Application Development
1.	PHP debugging techniques
2.	SQL and MySQL debugging techniques

Extend Topics
1.	Output buffering
2.	Page caching
3.	Web Browser detection
 
CRN Days Time Date Location Instructor Seats Open
53645 005 MT----- 06:00-09:29 PM 11/24/14-11/25/14 RC 238 Stublen N 6 of 14
MTW---- 06:00-09:29 PM 12/01/14-12/10/14 RC 238    
53646 006 MT----- 08:00-03:59 PM 12/01/14-12/09/14 RC 252 Peterson B 10 of 10

Web Development Web Design

XCWW 1001 - pHp and MySQL for Dynamic Web Sites

When static HTML pages no longer cut it, you need to step up to dynamic, database-driven sites that represent the future of the Web. Explore the way users work with pHp and MySQL to build dynamic sites using Open Source tools. Work with pHp and MySQL separately before going on to cover security, sessions and cookies, and using additional Web tools. Finish the class by creating sample applicationsThis class is also part of the Web Developer Smart Package. Take all of the classes in this package at a 30% discount off the full price. For details visit the Smart Package store.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: HTML and CSS Advanced, Programming Fundamentals, Access Intermediate or comparable knowledge.

CEU Hours: 2.8

Contact Hours: 28

Course Outline

Introduction to PHP
1.	Basic Syntax
2.	Sending data to a Web browser
3.	Writing Comments
4.	What are variables, stings, numbers, and constants

Programming with PHP
1.	Creating an HTML form
2.	Managing magic quotes
3.	Conditionals and operators
4.	Validating form data
5.	Arrays and Loops

Creating Dynamic Web Sites
1.	Using external files
2.	Sending Email
3.	Date and time functions

Introduction to SQL and MySQL
1.	Designing tables
2.	Inserting records
3.	Selecting data
4.	Using Like and Not Like
5.	Queries

Advanced SQL and MySQL
1.	Performing joins
2.	Using Functions

Using PHP and MySQL
1.	Making the template
2.	Connecting to MySQL
3.	Error handling
4.	Executing and retrieving queries
5.	Updating records with PHP

Cookies and Sessions

Security
1.	HTTP authentication
2.	Form validation with JavaScript
3.	Regular expressions

Web Application Development
1.	PHP debugging techniques
2.	SQL and MySQL debugging techniques

Extend Topics
1.	Output buffering
2.	Page caching
3.	Web Browser detection
 
CRN Days Time Date Location Instructor Seats Open
90614 001 MT----- 08:00-03:59 PM 04/20/15-04/28/15 RC 252 Faculty 10 of 10
Clinic Courses (CLI) provide practical application and are offered on or off campus. Instructors supervise/direct student in a simulated or on-site setting.
Face-to-Face Courses (F2F) take place in a classroom. Based on JCCC's Statement of General Education. Students in all classes, including face-to-face classes, are expected to use technology appropriate to the course content and as needed to access web-based course materials. Face-to-face classes typically require access to computer equipment (either at home or in college labs provided for student use) and computing skills utilizing standard office, business and web browsing applications.
Hybrid Courses (HYB) combine face-to-face classroom instruction and the convenience of online web-based learning, resulting in a reduction of the amount of time spent in the face-to-face classroom and a significant increase of time spent studying online materials. Students registered in hybrid courses must attend class meetings as listed in the JCCC Schedule of Classes.
Internships (INT) provide experience to students for on-the-job training with cooperating businesses, agencies, and organizations. The number of hours for each internship varies.
Lab Courses (LAB) are face-to-face classes where students perform tasks as directed by faculty. Faculty members monitor the activity and provide individual and/or group instruction/assistance
Media Courses (MED) deliver all or a portion of instruction through either cable broadcast or pre-recorded video lessons. The videos are available in DVD format from the Billington Library.
Online Courses (ONLNE) use the Internet and a Learning Management System (D2L) to deliver course materials and to facilitate student-instructor, student-content, and student to student interaction. To participate in online courses, the student should have a good understanding of computer hardware and software applications and the Internet.
Continuing Education Online Courses (CEONL) and materials are delivered via the Internet. To participate in online courses, the student should have a good understanding of computer applications and Internet navigation. For more information about this course and other online learning options visit CE Online.
Private (PLV) lessons for credit are available from beginning to advanced in voice, piano, guitar, brass, woodwind and percussion. Lessons are scheduled by arrangement with private music instructors.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Travel Courses (TRV) may require in-class activities as well as traveling to a destination. Students will be responsible for the cost of the travel as well as the course costs.
Seats Open is an approximation of the number of seats available and may not represent the actual number of seats open at the time of registration.
This course is approved by the Kansas Board of Regents for guaranteed transfer among all Kansas public postsecondary institutions. Additional courses may also be eligible for transfer. Please visit the JCCC Registrar to learn more.