Course Overview
Learn how to leverage the PHP language and the Oracle database to generate dynamic and interactive web applications. This course is a four-day course which presents a wide array of useful tools for PHP-Oracle developer. These tools are all native to PHP and include quick data retrieval, easy forms and reports, and dynamic code. It covers the fundamentals of PHP programming, introduction to Oracle database, some advanced features of the Oracle such as Store Proc, Tidal Job, Cron Job, and creation of database driven applications using PHP and Oracle. Exercises are used to demonstrate the many features of PHP with Oracle, including the installation and use of Zend Server, Oracle Express Edition, Oracle SQL Developer, and Adobe Dreamweaver CS5.5.
Pre-requisites
Previous experience with relational database management and SQL is helpful, but this class is self-contained and has no formal prerequisites
PHP & Oracle – Schedule
|
Day 1
|
|
09.00am – 10.00am
|
Installation of Needed Software
- PHP
- Apache server
- Oracle server
- Oracle Client DLL
- Oracle Client Tool
- Configure Oracle server and Oracle client Tool
|
| 10.00am – 10.30am |
Breakfast
|
|
10.30am – 12.45pm
|
PHP Fundamentals
- Language fundamentals
- PHP Basics
- PHP Data types
- Storing & retrieving information in variables
- Basic operations with variables
- Variable rules
- Decision making in PHP
- Comparison operators
- The if construct
- The while construct
- The for construct
|
|
12.45pm – 02.15pm
|
Lunch
|
|
02.15pm – 05.00pm
|
- Arrays and PHP
- Working with arrays
- Sorting arrays
- Other array related functions
- Multi-dimensional arrays
- Re-using PHP code
- Functions
- Declaring functions
- Passing data by reference
- Including code in scripts
- Variable scope in PHP
- PHP and the WWW server
- Working with web forms
- PHP POST & GET form elements
- Embedding forms with PHP code
- Validating form data
- Preventing spoofed submissions
- Guidelines for secure PHP
- Understanding magic quotes
- Setting default values in forms
- Processing uploaded files
- Retrieving & sorting uploaded files
|
|
Day 2
|
|
09.00am – 10.00am
|
PHP in Web
- Managing web sessions
- Using PHP session handling
- PHP cookie handling
- Handling date & time in PHP
- Displaying dates & times
- Parsing a date or time
- Generating relative times
- Working with files in PHP
- Reading & writing files with PHP
- File permissions
- Handling errors
|
|
10.00am – 10.30am
|
Breakfast
|
|
10.30am – 12.45pm
|
- Sending email using PHP
- PHP Email settings
- Sending text messages using PHP
- Sending HTML formatted email messages using PHP
- Debugging PHP Code
- PHP Error handling
- PHP debugging tools
- Suppressing errors
|
|
12.45pm – 02.15pm
|
Lunch
|
|
02.15pm – 05.00pm
|
How to Use Oracle Client Tools
- Create user (Normal & Admin)
- Create Schema
- Assign user to schema
- How to create schema and table via tool
Oracle Table: Column and Data Type
- Create tables
- Create column
- Column naming convention and restriction
- Column data type: Number and Characters
- Modify/Alter column: name and data type
- Microsoft Visio: Design data model
- Microsoft Visio: Generate script
|
|
Day 3
|
|
09.00am – 10.00am
|
How to Program In Oracle: SQL & PL/SQL
- Manipulating data in SQL
- SQL: The SELECT statement
- SQL: Overall SELECT syntax
- SQL: Selecting values to display
- SQL: Restricting selections using the WHERE clause
- SQL: Using ORDER BY to sort query results
- SQL: Using LIMIT to limit result sets
- SQL: INSERT statement
- SQL: UPDATE Statement
- SQL: DELETE Statement
- SQL: TRUNCATE TABLE statements
|
|
10.00am – 10.30am
|
Breakfast
|
|
10.30am – 12.45pm
|
- SQL: create trigger, constraint, dependencies
- PL/SQL: create function, store proc, view
- Indexing
|
|
12.45pm – 02.15pm
|
Lunch
|
|
02.15pm – 05.00pm
|
Accessing Oracle Databases Using PHP
- Download and Install ADODB
- Create Data Source Name (DSN)
- Setting connection to the database via PHP
- Executing SQL statements
- Executing prepared statements
- Multiple statement execution
- Retrieving information about queries (metadata)
- Transactions and queries
- Retrieving data from a database
- Single-step queries
|
|
Day 4
|
|
09.00am – 10.00am
|
Bootcamp: User Registration
- How to connect to Oracle via PHP component
- Create signup page
- Insert: SQL Query from PHP
- Update: SQL Query from PHP
- Delete: SQL Query from PHP
- Select: SQL Query from PHP
- Dataset, DataReader, DataSource
|
|
10.00am – 10.30am
|
Breakfast
|
|
10.30am – 12.45pm
|
PHP and Oracle Store Proc
- Insert via Store Proc
- Update via Store Proc
- Delete via Store Proc
- Select via Store Proc
- View
|
|
12.45pm – 02.15pm
|
Lunch
|
|
02.15pm – 05.00pm
|
PHP Backend Application with Oracle Database
- Tidal Job
- Cron Job
- Calling PHP class using shell script
Oracle DBA
- Table security
- User account setting, expires, block, unblock
- Tuning
|
