Oracle Database Ajax & PHP Web Application Development

Table of contents

1. Cover Page
2. Oracle Database AJAX & PHP Web Application Development
3. Copyright Page
4. Dedication
5. Contents
6. Introduction
7. PART I Building a Foundation
   1. 1 JavaScript and PHP Scalability
      1. Scalability
      2. Reducing CPU Cycles and RAM Size
      3. Scaling Control Structures
      4. Scaling String Manipulation
      5. Scaling Simple Mathematic
      6. Scaling Impacts of Objects and Their Methods
      7. Scalability Impacts of Multiple Print Calls
      8. Reducing Network Load
      9. Using AJAX to Reduce Network Load
      10. Using Compression to Reduce Load
      11. Summary
   2. 2 PHP and JavaScript Modularity
      1. Modularity
      2. Design for the Real World
      3. The Main Module and Controllers
      4. The Application Controller and Reflection
      5. JavaScript Modularity with Controllers and Reflection
      6. Summary
   3. 3 JavaScript and PHP Objects
      1. Class Definition and Creation
      2. Inheritance
      3. Constructors
      4. Public, Protected, and Private
      5. JavaScript Attributes and Methods
      6. PHP Model, Controller, and Control Objects
      7. JavaScript Model, Controller, and Control Objects
      8. Summary
8. PART II Dynamic Presentation: Communication Between User Interface and the Server
   1. 4 The XMLHttpRequest Object
      1. Creating a Request and Handling the Result
      2. Creating a Server Access Object Module
      3. Summary
   2. 5 AJAX, Advanced HTML, and HTTP Communication
      1. Creating HTML Drill-Down Tables
      2. HTTP Headers, Errors, and Server Communication
      3. Summary
   3. 6 Manipulating the DOM with JavaScript
      1. The Document Object Model
      2. Drag and Drop
      3. The Drag-and-Drop Library
      4. The PHP Control Objects
      5. The JavaScript Control Objects
      6. Storing Drag-and-Drop Information in the Database
      7. Summary
9. PART III Advanced Dynamic Presentation and Communication
   1. 7 Remoting with PHP Data Access Objects
      1. Remoting Using PHP and HTTP-RPC
      2. Remoting Using Pear XML-RPC Clients and Services
      3. Summary
   2. 8 AJAX, Charting, and Simple Data Transfer
      1. Using the SimplePlot Library
      2. Generating Chart Data on the Server
      3. Retrieving the Data Using AJAX
      4. Summary
   3. 9 Enabling Back Buttons in AJAX
      1. Adding History Tracking
      2. Using the History iframe
      3. Client-Side Sessions
      4. Summary
10. PART IV Creating Highly Flexible, Scalable Applications
    1. 10 Client and Server-Side Sessions
       1. Tracking and Using Login State on the Client
       2. Tracking and Using Login State on the Server
       3. Defining and Storing User Preferences Between Sessions
       4. Using Stored User Preferences
       5. JSON
       6. Summary
    2. 11 Creating User-Defined Mashups
       1. Creating a Simple Mashup Page
       2. Embedding Mashups in the Medical Data System
       3. How It Is Done
       4. Summary
    3. 12 Multimodal Communication: VOIP, IM, and Stored Reports
       1. Making VOIP and IM Accessible
       2. Distributed, Targeted, Reporting
       3. Summary
11. PART V Appendixes
    1. A HTML Tag Index
    2. B PHP Primer
       1. History and Background
          1. What Is PHP?
          2. What Is Zend?
       2. Developing Web Programming Solutions
          1. What Goes Where and Why?
          2. What Does Oracle Contribute to PHP?
          3. Why Is PHP 5 Important?
          4. How Do You Use PHP?
          5. How Do You Use PHP and OCI8 to Access the Oracle Database?
       3. Summary
    3. C Oracle Database Administration Primer
       1. Oracle Database Architecture
       2. Starting and Stopping the Oracle Database
          1. Unix or Linux Operations
          2. Microsoft Windows Operations
       3. Starting and Stopping the Oracle Listener
       4. Accessing and Using SQL*Plus Interface
          1. SQL Command-Line Interface
          2. Bind Variables
       5. Summary
    4. D Oracle Database SQL Primer
       1. Oracle SQL Data Types
       2. Data Definition Language (DDL)
          1. Managing Tables and Constraints
          2. Managing Views
          3. Managing Stored Programs
          4. Managing Sequences
          5. Managing User-Defined Types
       3. Data Query Language (DQL)
          1. Queries
       4. Data Manipulation Language (DML)
          1. INSERT Statements
          2. UPDATE Statements
          3. DELETE Statements
       5. Data Control Language (DCL)
       6. Summary
    5. E PL/SQL Primer
       1. Oracle PL/SQL Block Structure
       2. Variables, Assignments, and Operators
       3. Control Structures
          1. Conditional Structures
          2. Iterative Structures
       4. Stored Functions, Procedures, and Packages
          1. Stored Functions
          2. Procedures
          3. Packages
       5. Database Triggers
          1. DDL Triggers
          2. DML Triggers
          3. INSTEAD OF Triggers
          4. System or Database Event Triggers
       6. Collections
          1. VARRAY Data Type
          2. NESTED TABLE Data Type
          3. Associative Array Data Type
          4. Collection API
       7. Using the DBMS_LOB Package
          1. Verifying or Configuring the LOB Environment
          2. Writing and Reading a CLOB Data Type
       8. Summary
12. Index