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, 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, 2.2
installing, 2, 2.2
obtaining and installing, 2.2
prerequisites, 2.1

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