Index

A  B  C  D  E  F  G  H  I  L  M  N  O  P  R  S  T  U  V  W  

Symbols

  • __construct() method 1
  • $_GET superglobal array 1
  • $action parameter 1 , 2
  • $atfirstrow parameter 1
  • $bindvars parameter 1
  • $conn attribute 1
  • $firstrow parameter 1
  • $numrows parameter 1
  • $otherbindvars parameter 1
  • $rcname parameter 1
  • $res parameter 1
  • $sess->getSession() call 1
  • $sess parameter 1
  • $sql parameter 1 , 2
  • $startrow parameter 1

A

  • ac_cred.inc.php
    • creating 1
  • ac_db.inc.php
    • creating 1
  • AL32UTF8 character set 1
  • AnyCo sample application 1
  • Apache
    • testing installation on Windows 1
  • Apache HTTP Server
    • installation
      • manually on Linux 1
      • on Linux 1
      • on Windows 1
      • testing 1
    • installing on Linux 1
    • setting environment
      • on Linux 1
    • setting up user directory 1
    • testing the installation 1
  • application
    • calling locale specific functions 1
    • externalizing translatable strings 1
    • globalizing 1
    • translating HTML and GIF 1
    • translating the user interface 1
    • UTF-8 page encoding 1
  • array_push() function 1

B

  • bind parameters
    • rc 1
  • bind variables
    • id 1
    • rc 1

C

  • calcstartrow() function 1
  • calls
    • oci_bind_by_name() 1
  • character sets
    • AL32UTF8 1
    • globalization settings 1
    • UTF-8 1
  • charset parameter 1
  • connections
    • HR user 1
  • constants
    • NUMRECORDSPERPAGE 1 , 3
  • conventions
    • presenting data 1

D

  • database
    • dynamic information 1
    • installing 1
    • unlocking the HR user 1
  • database access class
    • creating 1
  • Database Resident Connection Pooling 1
  • date formats in Oracle 1
  • Db((colon))((colon))execFetchAll() method 1
  • Db((colon))((colon))execFetchPage() method 1
  • Db((colon))((colon))refcurExecFetchAll() method 1
  • Db class 1 , 2
  • DRCP
    • architecture 1
    • pool 1
    • starting the pool 1

E

  • environment variables
    • NLS_LANG 1
    • NLS_LANGUAGE 1 , 2
    • NLS_TERRITORY 1
  • errors
    • NLS_LANGUAGE 1

F

  • files
    • translating HTML and GIF 1
  • functions
    • array_push() 1
    • calcstartrow() 1
    • getempname() 1
    • htmlentities() 1
    • htmlspecialchars() 1
    • oci_connect() 1 , 4
    • oci_fetch_array() 1
    • oci_new_connect() 1 , 3
    • oci_pconnect() 1 , 2
    • oci_set_client_identifier() 1
    • printcontent() 1 , 3
    • printnextprev() 1
    • printnorecords() 1
    • printrecords() 1 , 2
    • var_dump() 1

G

  • getempname() function 1
  • globalizing
    • applications 1
    • calling locale specific functions 1
    • character sets 1
    • date formats 1
    • determining user locale 1
    • dynamic information 1
    • HTML page encoding 1
    • linguistic sorts 1
    • NLS_LANGUAGE 1
    • number formats 1
    • PHP and Oracle environment 1
    • presenting data 1
    • sorting data 1
    • translating the user interface 1

H

  • HR user 1
  • HTML
    • page encoding 1 , 2 , 3 , 4
    • page header 1
  • htmlentities() function 1
  • htmlspecialchars() function 1
  • HTTP header
    • page encoding 1

I

  • id bind variable 1
  • installation
    • Apache httpd package 1
    • Apache HTTP Server 1
    • Apache HTTP Server on Linux 1
    • Apache HTTP Server on Windows 1
    • Apache on Linux, manually 1
    • NetBeans 7.0 IDE 1
    • NetBeans IDE on Linux 1
    • NetBeans IDE on Windows 1
    • OCI8 1
    • Oracle Database 1 , 2
    • PHP 1
    • PHP and OCI8 on Oracle Linux 1
    • PHP on Linux 1
    • PHP on Windows 1

L

  • linguistic sorts 1
  • locale 1

M

  • methods
    • __construct() 1
    • Db((colon))((colon))execFetchAll() 1
    • Db((colon))((colon))execFetchPage() 1
    • Db((colon))((colon))refcurExecFetchAll() 1
    • refcurExecFetchAll() 1

N

  • NetBeans
    • configuration 1
    • installation
      • on Linux 1
      • on Windows 1
    • using 1
  • NLS_LANG environment variable 1
  • NLS_LANGUAGE environment variable 1 , 2
  • NLS_TERRITORY environment variable 1
  • number formats in Oracle 1
  • NUMRECORDSPERPAGE constant 1 , 3

O

  • obtaining
    • Oracle Database 1
  • oci_bind_by_name() call 1
  • oci_connect() function 1 , 4
  • oci_fetch_array() function 1
  • OCI_FETCHSTATEMENT_BY_ROW constant 1
  • oci_new_connect() function 1 , 3
  • oci_pconnect() function 1 , 2
  • oci_set_client_identifier() function 1
  • Oracle
    • date formats 1
    • establishing environment 1
    • number formats 1
  • Oracle Database
    • installing 1 , 2
    • obtaining and installing 1
    • prerequisites 1

P

  • package body 1
  • PACKAGE BODY type 1
  • package specification 1
  • PACKAGE type 1
  • parameters
    • $action 1 , 2
    • $atfirstrow 1
    • $bindvars 1
    • $firstrow 1
    • $numrows 1
    • $otherbindvars 1
    • $rcname 1
    • $res 1
    • $sess 1
    • $sql 1 , 2
    • $startrow 1
    • charset 1
  • PHP
    • active process 1
    • adding OCI8 extension 1
    • character sets 1
    • determining user locale 1
    • establishing environment 1
    • externalizing translatable strings 1
    • globalizing your application 1
    • HTML page encoding 1
    • idle process 1
    • installation
      • on Linux 1
      • on Windows 1
    • installing on Linux 1
    • installing on Windows 1
    • OCI8 extension 1
    • PHPDocumentor 1
    • post-installationtasks 1
    • testing 1
    • testing installation 1
    • translating HTML and GIF files 1
  • PHP calls
    • oci_bind_by_name() 1
  • PHP command
    • define() 1
    • include_once() 1
    • include() 1
    • require_once() 1
    • require() 1 , 2
  • PHP functions
    • array_push() 1
    • calcstartrow() 1
    • getempname() 1
    • htmlentities() 1
    • htmlspecialchars() 1
    • oci_connect() 1 , 4
    • oci_fetch_array() 1
    • oci_new_connect() 1 , 3
    • oci_pconnect() 1 , 2
    • oci_set_client_identifier() 1
    • printcontent() 1 , 3
    • printnextprev() 1
    • printnorecords() 1
    • printrecords() 1 , 2
    • var_dump() 1
  • PHP OCI8 1
  • PHP - PHP Hypertext Preprocessor 1
  • PL/SQL
    • UTL_I18N package 1
  • PL/SQL data types
    • REF CURSOR 1
  • prerequisites for Oracle Database 1
  • printcontent() function 1 , 3
  • printnextprev() function 1
  • printnorecords() function 1
  • printrecords() function 1 , 2

R

  • rc bind parameter 1
  • rc bind variable 1
  • refcurExecFetchAll() method 1
  • REF CURSOR 1

S

  • ShowEquipment package 1
  • sorting 1 , 2

T

  • testing
    • Apache installation on Windows 1
    • PHP connection to Oracle 1
  • types
    • PACKAGE 1
    • PACKAGE BODY 1

U

  • unlocking HR account 1
  • user interface
    • externalizing translatable strings 1
    • translating 1
  • UTF-8
    • character set 1
    • HTML page encoding 1
  • UTL_I18N package 1

V

  • V$CPOOL_CC_STATS 1
  • var_dump() function 1

W

  • Web browser
    • testing Apache installation on Windows 1