This course will be conducted in a hybrid mode for Summer 2015 (June 13 – July 26, 2015). The class will meet on June 13, 2015, from 8:00 AM - 5:00 PM in 4431 Klehm Hall. The rest of the course will be conducted via D2L (EIU Online).

Please make sure to bring your textbook and laptop to our first class meeting.

4032 (304D) Klehm Hall
11:00 AM- 12:00 PM, Monday through Friday

(217)581-6267 (with voice mail)

Skype ID: cfpl@eiu.edu

During my office hour, I may be available on Skype to chat with students who do not reside in Charleston. If you live in Charleston, please see me in my office.

Study of principles and practices in PHP programming with Oracle database. Student will gain the knowledge and skills to use PHP script language, and to design  and develop dynamic web applications connected with Oracle database.   This process is also referred to front end database development.

2-2-3

Official:

1. TEC 5323 Advanced Database Technology, or equivalent (basic understanding on Oracle SQL and SQL script).
2. You need a computer that can run Oracle database either Enterprise Edition (9i, 10g or 11g, 12) or Oracle 10g, 11gExpress Edition.
   
   Oracle 10g Express Edition can be used in older computer (for example, Windows XP, 256 MB RAM).

Unofficial: Willingness to have fun and contribute to the class.

This course helps students develop skills to design a dynamic web page that is connected with an Oracle database.  So far, in our program, the two database-related courses (TEC 5323 Advanced Database Technology and TEC 5363 Database Security and Reliability) mainly deal with the backend (or server-side).  The PHP/Oracle Development course will enable you to develop a front end web application, a valuable skill in job market.

1. Be able to install and configure Zend Server Developers Edition (which includes Apache web server and PHP engine).
2. Be able to establish communication between PHP program and Oracle database using OCI8.
3. Understand the basic concepts of PHP programming, including varibles, control structure, arrays, functions and basic file I/O.
4. Know how to communicate between HTML file and PHP program for basic web programming.
5. Know how to perform database query and transaction using PHP/Oracle.
6. Understand the way to use Oracle bind variable to develop web applications.
7. Gain some basic knowledge of mobile development and application using PHP/Oracle.
   
   

Readings:

Text: You are required to read the entire textbook assigned for this course, as follows:

McLaughlin, M. (2007) Oracle Database 10g Express Edition, PHP Web Programming: Create Dynamic, Data-Driven Web Applications, Oracle Press, McGraw-Hill: New York.

Note: There are a lot of update or changes happened in the field since the release of the textbook.

• Overview of PHP and Oracle Web Programming
• Installing and Configuring Zend Server and Oracle database
• Variables, Operators, Data Types and File Inclusion
• Control Structure
• Arrays
• Functions
• Basic Web Programming (HTML Form and PHP)
• Oracle Connection and Query by PHP
• Oacle Bind Variables and Application
  

Student achievement will be assessed and grades will be given according to class participation and contribution (including weekly discussion, and weekly "Geeks Corner"), PHP projects, test and final project. Grades will be determined upon the following distribution:

If you are a student with a documented disability in need of accommodations to fully participate in this class, please contact the Office of Student Disability Services (OSDS). All accommodations must be approved through OSDS. Please stop by Ninth Street Hall, Room 2006, or call 217-581-6583 to make an appointment.