Index

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

---

Symbols

$_GET superglobal array, 6.5

$action parameter, 5.1, 6.5

$atfirstrow parameter, 5.1, 5.1

$bindvars parameter, 5.1

$conn attribute, 3.2

$firstrow parameter, 5.1

$numrows parameter, 5.1, 5.1

$otherbindvars parameter, 6.5

$rcname parameter, 6.5

$res parameter, 5.1

$sess parameter, 5.1, 5.1

$sess->getSession() call, 5.1

$sql parameter, 5.1, 6.5

$startrow parameter, 5.1

__construct() method, 3.2

---

A

ac_cred.inc.php, 3.1

creating, 3.1

ac_db.inc.php, 3.2

creating, 3.2

AL32UTF8 character set, 14.1

AnyCo sample application, 2.2.2

Apache

testing installation on Windows, 2.4

Apache HTTP Server

installation, 2.3

manually on Linux, 2.3.2.2

on Linux, 2.3.2

on Windows, 2.3.1

testing, 2.4

installing on Linux, 2.3.2

setting environment

on Linux, 2.3.2.3

setting up user directory, 2.3.2.4

testing the installation, 2.4

application

calling locale specific functions, 14.4

externalizing translatable strings, 14.6.1

globalizing, 14

translating HTML and GIF, 14.6.2

translating the user interface, 14.6

UTF-8 page encoding, 14.5

array_push() function, 5.1

---

B

bind parameters

rc, 6.5

bind variables

id, 6.4

rc, 6.4

---

C

calcstartrow() function, 5.1

calls

oci_bind_by_name(), 3.3

character sets

AL32UTF8, 14.1

globalization settings, 14.2

UTF-8, 14.1

charset parameter, 14.5.1.1

connections

HR user, 2.2.1

constants

NUMRECORDSPERPAGE, 5.1, 5.1, 5.2

conventions

presenting data, 14.7

---

D

database, 2.2

dynamic information, 14.6.3

installing, 2.2

unlocking the HR user, 2.2.1

database access class, 3.2

creating, 3.2

Database Resident Connection Pooling, 2.2.2

date formats in Oracle, 14.7.1

Db class, 5.1, 6.5

Db::execFetchAll() method, 5.1

Db::execFetchPage() method, 5.1, 5.1

Db::refcurExecFetchAll() method, 6.5

DRCP

architecture, 2.2.2

pool, 2.2.2

starting the pool, 2.2.3

---

E

environment variables

NLS_LANG, 14.1

NLS_LANGUAGE, 14.4, 14.7.4

NLS_TERRITORY, 14.4

errors

NLS_LANGUAGE, 14.7.4

---

F

files

translating HTML and GIF, 14.6.2

functions

array_push(), 5.1

calcstartrow(), 5.1

getempname(), 6.5

htmlentities(), 3.5

htmlspecialchars(), 3.5

oci_connect(), 2.2.2, 2.2.2, 2.2.2, 3.4

oci_fetch_array(), 3.3

oci_new_connect(), 2.2.2, 2.2.2, 3.4

oci_pconnect(), 2.2.2, 3.2

oci_set_client_identifier(), 3.2

printcontent(), 5.1, 5.1, 6.5

printnextprev(), 5.1, 5.1

printnorecords(), 5.1, 5.1

printrecords(), 5.1, 6.5

var_dump(), 3.5

---

G

getempname() function, 6.5

globalizing

applications, 14

calling locale specific functions, 14.4

character sets, 14.2

date formats, 14.7.1

determining user locale, 14.3

dynamic information, 14.6.3

HTML page encoding, 14.5

linguistic sorts, 14.7.3

NLS_LANGUAGE, 14.7.4

number formats, 14.7.2

PHP and Oracle environment, 14.1

presenting data, 14.7

sorting data, 14.7

translating the user interface, 14.6

---

H

HR user, 2.2.1

HTML

page encoding, 14.5, 14.5.1.1, 14.5.1.2, 14.5.2

page header, 14.5.1.2

htmlentities() function, 3.5

htmlspecialchars() function, 3.5

HTTP header

page encoding, 14.5.1.1

---

I

id bind variable, 6.4

installation

Apache HTTP Server, 2.3

Apache HTTP Server on Linux, 2.3.2

Apache HTTP Server on Windows, 2.3.1

Apache httpd package, 2.3.2.1

Apache on Linux, manually, 2.3.2.2

NetBeans 7.0 IDE, 2.7

NetBeans IDE on Linux, 2.7.2

NetBeans IDE on Windows, 2.7.1

OCI8, 2.5.2.2

Oracle Database, 2, 2.2

Oracle Database Express Edition, 2.2

PHP, 2.5

PHP and OCI8 on Oracle Linux, 2.5.2.1

PHP on Linux, 2.5.2

PHP on Windows, 2.5.1, 2.5.1

---

L

linguistic sorts, 14.7.3

locale, 14.3

---

M

methods

__construct(), 3.2

Db::execFetchAll(), 5.1

Db::execFetchPage(), 5.1

Db::refcurExecFetchAll(), 6.5

refcurExecFetchAll(), 6.5

---

N

NetBeans

configuration, 2.7.3

installation, 2.7

on Linux, 2.7.2

on Windows, 2.7.1

using, 2.7.4

NLS_LANG environment variable, 14.1

NLS_LANGUAGE environment variable, 14.4, 14.7.4

NLS_TERRITORY environment variable, 14.4

number formats in Oracle, 14.7.2

NUMRECORDSPERPAGE constant, 5.1, 5.1, 5.2

---

O

obtaining

Oracle Database, 2.2

oci_bind_by_name() call, 3.3

oci_connect() function, 2.2.2, 2.2.2, 2.2.2, 3.4

oci_fetch_array() function, 3.3

OCI_FETCHSTATEMENT_BY_ROW constant, 3.3

oci_new_connect() function, 2.2.2, 2.2.2, 3.4

oci_pconnect() function, 2.2.2, 3.2

oci_set_client_identifier() function, 3.2

Oracle

date formats, 14.7.1

establishing environment, 14.1

number formats, 14.7.2

Oracle Database

installing, 2

obtaining and installing, 2.2

prerequisites, 2.1

Oracle Database Express Edition, 2.2

installing, 2.2

---

P

package body, 6.1

PACKAGE BODY type, 6.1

package specification, 6.1

PACKAGE type, 6.1

parameters

$action, 5.1, 6.5

$atfirstrow, 5.1, 5.1

$bindvars, 5.1

$firstrow, 5.1

$numrows, 5.1, 5.1

$otherbindvars, 6.5

$rcname, 6.5

$res, 5.1

$sess, 5.1, 5.1

$sql, 5.1, 6.5

$startrow, 5.1

charset, 14.5.1.1

PHP

active process, 2.2.2

adding OCI8 extension, 2.5.2.2

character sets, 14.2

determining user locale, 14.3

establishing environment, 14.1

externalizing translatable strings, 14.6.1

globalizing your application, 14

HTML page encoding, 14.5.2

idle process, 2.2.2

installation, 2.5

on Linux, 2.5.2

on Windows, 2.5.1

installing on Linux, 2.5.2

installing on Windows, 2.5.1

OCI8 extension, 1.2

PHPDocumentor, 3.2

post-installationtasks, 2.5.3

testing, 2.6.2

testing installation, 2.6

translating HTML and GIF files, 14.6.2

PHP - PHP Hypertext Preprocessor, 1

PHP calls

oci_bind_by_name(), 3.3

PHP command

define(), 3.1

include(), 3.2

include_once(), 3.2

require(), 3.1, 3.2

require_once(), 3.2

PHP functions

array_push(), 5.1

calcstartrow(), 5.1

getempname(), 6.5

htmlentities(), 3.5

htmlspecialchars(), 3.5

oci_connect(), 2.2.2, 2.2.2, 2.2.2, 3.4

oci_fetch_array(), 3.3

oci_new_connect(), 2.2.2, 2.2.2, 3.4

oci_pconnect(), 2.2.2, 3.2

oci_set_client_identifier(), 3.2

printcontent(), 5.1, 5.1, 6.5

printnextprev(), 5.1, 5.1

printnorecords(), 5.1, 5.1

printrecords(), 5.1, 6.5

var_dump(), 3.5

PHP OCI8, 2.5.2.2

PL/SQL

UTL_I18N package, 14.4

PL/SQL data types

REF CURSOR, 6.3

prerequisites for Oracle Database, 2.1

printcontent() function, 5.1, 5.1, 6.5

printnextprev() function, 5.1, 5.1

printnorecords() function, 5.1, 5.1

printrecords() function, 5.1, 6.5

---

R

rc bind parameter, 6.5

rc bind variable, 6.4

REF CURSOR, 6.3

refcurExecFetchAll() method, 6.5

---

S

ShowEquipment package, 6.5

sorting, 14.7, 14.7.3

---

T

testing

Apache installation on Windows, 2.4

PHP connection to Oracle, 2.6.2

types

PACKAGE, 6.1

PACKAGE BODY, 6.1

---

U

unlocking HR account, 2.2.1

user interface

externalizing translatable strings, 14.6.1

translating, 14.6

UTF-8

character set, 14.1

HTML page encoding, 14.5

UTL_I18N package, 14.4

---

V

V$CPOOL_CC_STATS, 2.2.3

var_dump() function, 3.5

---

W

Web browser

testing Apache installation on Windows, 2.4