Description:

This course covers the commands and techniques required to connect a Web page to a relational database using PHP (Hypertext Preprocessor) and MySQL (database management system). Students define and build a relational database using MySQL, then use PHP scripts as well as SQL in a Web page to connect to the database to edit, delete, and enter records. 1 hr. integrated lecture lab/wk.

Associated Costs: These are additional (out-of-pocket) expense considerations that students should expect in addition to the course tuition, fees, and textbooks. $10 to $20.

Supplies: Refer to the instructor's course syllabus for details about any supplies that may be required.

Textbook(s): For information see - http://bookstore.jccc.net

Course Fees: NONE

Course Objectives:

Upon successful completion of this course the student should be able to:

1. Model data by designing the tables, fields, data types, and joins needed for a small relational database.
2. Use MySQL to create the relational database.
3. Use SQL to edit, enter, delete, and query data in a MySQL database.
4. Connect to a MySQL database using PHP scripts in a Web page.
5. Write a PHP script to display, enter, edit, and delete data from a MySQL database.
6. Describe the use and application of cookies and session variables.

Content Outline & Competencies:

I. Introduction to Relational Databases
   A. Explain the benefits of a properly designed relational database.
   B. State proper field and object naming conventions.
   C. Demonstrate the use of proper field data types.
   D. Build a diagram to model the data using tables, fields, primary key
fields, foreign key fields, and one-to-many relationships.

II. Introduction to MySQL
   A. Use MySQL to create and define the tables, fields, field types, and
joins necessary to create a small relational database.
   B. Use MySQL to enter, edit, delete, and query data.

III. Introduction to SQL (Structured Query Language)
   A. Define SQL terminology and demonstrate proper SQL syntax.
   B. Create a table with field names using the CREATE statement.
   C. Select data to the database using the SELECT statement.
   D. Add data to the database using the INSERT statement.
   E. Change data in the database using the UPDATE statement.
   F. Delete data in the database using the DELETE statement.
   G. Write WHERE conditions to select certain records.
   H. Use the simple and left JOIN operations.

IV. PHP, Web page, MySQL database Connections
   A. Define the name of the DBMS software, driver, database location, and
server permissions needed.
   B. Write a connection PHP script to link the Web page to the database.
   C. Write a PHP script to insert data in the MySQL database.
   D. Write a PHP script to display the contents of the MySQL database.
   E. Write a PHP script to delete the contents of the MySQL database.
   F. Write a PHP script to update the contents of the MySQL database.
   G. Write a PHP script to select data with queries involving more than
one table.
   H. Debug PHP scripts and SQL.

V. Files, Cookies, and Session Variables
   A. Read and write text files with PHP
   B. Upload a file using PHP
   C. Explain the nature of a stateless protocol, and the need for cookies
and session variables
   D. Write PHP scripts to set cookies
   E. Write PHP scripts to set session variables.

Methods of Evaluation of Competencies:

Evaluation of student mastery of course competencies will be accomplished using the following methods:

Evaluation of student mastery of course competencies will be
accomplished using the following methods:

A minimum of one quiz	        50%
A minimum of five projects	50%
			       100%

Grade Criteria:

   90 - 100%   A
   80 -  89%   B
   70 -  79%   C
   60 -  69%   D
    0 -  59%   F

Caveats: NONE

Disabilities:

If you are a student with a disability, and if you will be requesting accommodations, it is your responsibility to contact Access Services. Access Services will recommend any appropriate accommodations to your professor and his/her director. The professor and director will identify for you which accommodations will be arranged.

JCCC provides a range of services to allow persons with disabilities to participate in educational programs and activities. If you desire support services, contact the office of Access Services for Students With Disabilities (913) 469-8500, ext. 3521 or TDD (913) 469-3885. The Access Services office is located in the Success Center on the second floor of the Student Center.