Develop Web Applications with PHP & Oracle

Introduction to PHP

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

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

• A brief history of Oracle
• Relational database concepts
• Database tables

Using the CREATE TABLE statement
SQL Data types

• Integer data types
• Floating point data types
• Character data types
• SQL column modifiers

Manipulating data in SQL

• The SELECT statement
  • Overall SELECT syntax
  • Selecting values to display
  • Restricting selections using the WHERE clause
  • Using ORDER BY to sort query results
  • Using LIMIT to limit result sets
• The INSERT statement
• The UPDATE Statement
• The DELETE and TRUNCATE TABLE statements

 Accessing databases using PHP

• Downloading & Installing ADODB
• Creating a Data Source Name (DSN)
• Setting connection options & connecting to the database
• 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

Managing web sessions

• Using PHP session handling
• PHP cookie handling

Handling date & time in PHP

• Diplaying dates & times
• Parsing a date or time
• Generating relative times

Working with files in PHP

• Reading & writing files with PHP
• File permissions
• Handling errors

Sending email using PHP

• PHP Email settings
• Sending text messages using PHP
• Sending HTML formatted email messages using PHP

Creating a Database Driven PHP Application with Oracle db at the backend.

Debugging PHP Code

• PHP Error handling
• PHP debugging tools
• Suppressing errors