Index

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

Symbols

$bindargs array, 4.2
$bindargs parameter, 5.1
$bindvars parameter, 4.2, 4.2, 7.1
$conn parameter, 3.2
$current variable, 4.3
$date parameter, 3.1
$DID variable, 4.2
$e parameter, 5.4, 5.4, 5.4
$emp variable, 5.3
$file parameter, 4.1
$line parameter, 4.1
$posturl parameter, 4.3, 4.3
$q1 parameter, 4.3
$query parameter, 5.2
$r parameter, 4.1
$refcur variable, 6.2
$results parameter, 4.1
$resulttype parameter, 5.2
$rowsperpage parameter, 4.3
$stid parameter, 4.1, 4.2
$title parameter, 3.1
@ preventing error display, 5.4
__FILE__ variable, 4.1, 5.4
__LINE__ variable, 4.1, 5.4

A

AL32UTF8 character set, 8.1
AnyCo Corp
tutorial application, 1.3
anyco_cn.inc
creating, 4.1
description, 1.3
anyco_db.inc
calling bind variable, 4.2
calling PL/SQL packaged procedure, 6.2
changing the bind variable, 7.1
choosing output type, 5.2, 5.2
creating, 4.1
creating a thumbnail image, 7.2
description, 1.3
executing data manipulation statements, 5.2
including in anyco.php, 4.1
inserting thumbnail image, 7.1
passing error parameter, 5.4
preventing error display, 5.4
return error variable, 5.4
returning errors, 5.4
returning errors from all functions, 5.4
subset query, 4.3
testing, 4.2
anyco_im.php
creating, 7.1
description, 1.3
employee image display, 7.1
anyco_ui.inc
add employee remuneration column, 6.1
adding an employee image column, 7.1
adding navigation, 4.3
creating, 3.1, 3.1
description, 1.3
employee data in HTML table, 5.1
error printing, 5.4
extending, 4.4
formatting results, 4.1
functions, 3.1
generating an employee img tag, 7.1
generating employee data HTML form, 5.2
HTML form for employee data, 5.2
including, 3.1
including in anyco.php, 4.1
testing changes, 5.1
updating an employee record, 5.2
uploading employee image, 7.1
anyco.php
adding db connection, 3.2
bind variables, 4.2
building employee records, 5.2
calling a PL/SQL function, 6.1
creating, 3.1
data manipulation logic, 5.2
deleting employee records, 5.2
departments instead of employees, 5.1
description, 1.3
employees and departments pages, 5.3
employees page, 5.1
error handling, 5.4, 5.5
executing the query, 3.2
fetching all rows, 3.2
include files, 4.1
inserting an image, 7.1
inserting employee records, 5.2
navigation, 4.3
obtaining the default department, 5.3
printing page titles, 5.3
query to execute, 3.2
replace query, 4.4
testing, 3.1, 3.2, 4.1, 4.2, 4.3, 4.4, 5.1, 5.2, 5.3, 5.4, 5.5, 6.1, 6.2, 7.1, 7.2
updating employee records, 5.2
usable database connection, 3.2
using a bind variable, 4.2
Apache
creating public_html, 2.3.2
httpd.conf configuration file, 2.3.2
obtaining and installing, 2.3
public_html, 2.3.2
restarting, 2.3.2
testing installation on Linux, 2.3.2
testing installation on Windows, 2.3.1
application, 5.4
adding an employee image, 7.1
adding employee remuneration column, 6.1
building employee records, 5.2
calling departments instead of employees, 5.1
calling locale specific functions, 8.4
centralizing database logic, 4.1
choosing output type, 5.2, 5.2
combining departments and employees, 5.3
connection functions, 4.1
constants for database connection, 4.1
creating employees page, 5.1
deleting employee records, 5.2
employee image display, 7.1
employee images in BLOBs, 7.1
error recovery, 5.4
executing data manipulation statements, 5.2
executing the query, 3.2
extending departments page, 4.4
extending employees page, 5.2
externalizing translatable strings, 8.6.1
fetching all rows, 3.2
file naming convention, 1.3
files directory, 2.6, 3.1
generating an employee img tag, 7.1
globalizing, 8
implementing subset query, 4.3
inserting employee records, 5.2
inserting employee thumbnail, 7.1
Next and Previous buttons, 4.3
obtaining the default department, 5.3
Oracle errors, 5.5
PL/SQL procedures and functions, 6.1
printing errors, 5.4
printing page titles, 5.3
query to execute, 3.2
report page, 3
return error variable, 5.4
thumbnail images, 7.2
translating HTML and GIF, 8.6.2
translating the user interface, 8.6
updating employee records, 5.2
uploading employee image, 7.1
user interface, 3.1
UTF-8 page encoding, 8.5
array_push() function, 7.1

B

bind variables, 4.2, 4.2
anyco.php, 4.2
calling in anyco_db.inc, 4.2
DID, 4.2, 4.2, 5.3
FIRST, 4.3
LAST, 4.3
modify query, 4.2
NEWEID, 7.1
OUT, 7.1
returning from database, 7.1
BLOBs
storing employee images, 7.1

C

calc_remuneration() function, 6.1
character sets
AL32UTF8, 8.1
globalization settings, 8.2
UTF-8, 8.1
charset parameter, 8.5.1.1
configuring
Apache httpd.conf, 2.3.2
Zend Core for Oracle, 2.5
Zend Core for Oracle configuration tab, 2.5
connections
disconnecting, 3.3
Easy Connect syntax, 3.2.1
HR user, 2.2.1, 6.1
Oracle Database, 3
persistent, 3.2.2
settings, 3.2.2
construct_departments() function, 4.3, 4.3, 4.3, 4.4, 5.1
construct_employees() function, 5.1, 5.1, 5.3, 6.1
construct_image() function, 7.1
construct_insert_emp() function, 5.2, 5.3
construct_modify_emp() function, 5.2
Content-type, 7.1
conventions
presenting data, 8.7
COUNTRIES table, 4.4
creating
anyco_ui.inc application user interface, 3.1
directory for application files, 2.6, 3.1
PHP files, 3
public_html, 2.3.2
cv_types.et_employees() procedure, 6.2

D

database
centralizing logic, 4.1
connection functions, 4.1
constants for connection, 4.1
disconnection, 3.3
dynamic information, 8.6.3
Easy Connect syntax, 3.2.1
executing the query, 3.2
fetching all rows, 3.2
navigating records, 4.3
storing employee images, 7.1
tnsnames.ora, 3.2.1
validating connection, 3.2
date formats in Oracle, 8.7.1
date() function, 5.2
db_do_query() function, 4.1, 4.2, 4.2, 5.1, 5.1, 5.2, 5.2, 5.2, 5.4
db_error () function, 4.1
db_error() function, 4.1, 5.4, 5.4
db_execute_statement() function, 5.2, 5.2, 7.1
db_get_employees_rc() function, 6.2
db_get_page_data() function, 4.3, 4.3, 4.3, 5.2, 5.4
db_insert_thumbnail() function, 7.1, 7.2, 7.2
debugging, 4.1
delete_emp() function, 5.2
department_id variable, 5.3
departments page
combining with employees, 5.3
extending, 4.4
DEPARTMENTS table, 1.3, 3.2, 4.3, 4.4
deptid parameter, 5.3
DID bind variable, 4.2, 4.2, 5.3
directives
display_errors, 3.2.1
error_reporting, 3.2.1
disconnection, 3.3
display_errors directive, 3.2.1
do_query() function, 3.2

E

Easy Connect syntax, 3.2.1
EMPLOYEE_PHOTOS table, 7.1, 7.1
employees page, 5.1
combining with departments, 5.3
creating, 5.1
extending, 5.2
EMPLOYEES table, 1.3, 3.2, 4.4, 5.2, 5.2, 5.2, 7.1
enctype attribute, 7.1
environment variables
NLS_LANG, 8.1
NLS_LANGUAGE, 8.4, 8.7.4
NLS_TERRITORY, 8.4
error_reporting directive, 3.2.1
errors
assigning to variable, 5.4
handling, 5.4
NLS_LANGUAGE, 8.7.4
Oracle, 5.5
passing parameter, 5.4
preventing display, 5.4
recovery, 5.4
returning, 5.4
returning from all functions, 5.4

F

files
adding data manipulation logic to anyco.php, 5.2
adding db connection to anyco.php, 3.2
adding navigation to anyco.php, 4.3
anyco_cn.inc description, 1.3
anyco_db.inc description, 1.3
anyco_im.php description, 1.3
anyco_ui.inc description, 1.3
anyco.php description, 1.3
application, 2.6, 3.1
application naming convention, 1.3
creating anyco_cn.inc, 4.1
creating anyco_db.inc, 4.1
creating anyco_im.php, 7.1
creating anyco_ui.inc, 3.1
creating anyco.php, 3.1
employees and departments pages, 5.3
employees page in anyco.php, 5.1
error handling in anyco.php, 5.4, 5.5
extending anyco_ui.inc, 4.4
include file in anyco_ui.inc, 3.1
include files in anyco.php, 4.1
JPEG, 7.2
style.css description, 1.3
testing anyco_ui.inc, 5.1
testing anyco.php, 3.1, 3.2, 4.1, 4.2, 4.3, 4.4, 5.1, 5.2, 5.3, 5.4, 5.5, 6.1, 6.2, 7.1, 7.2
translating HTML and GIF, 8.6.2
FIRST bind variable, 4.3
format
function in anyco_ui.inc, 4.1
functions
anyco_ui.inc, 3.1
array_push(), 7.1
calc_remuneration(), 6.1
construct_departments(), 4.3, 4.3, 4.3, 4.4, 5.1
construct_employees(), 5.1, 5.1, 5.3, 6.1
construct_image(, 7.1
construct_insert_emp(), 5.2, 5.3
construct_modify_emp(), 5.2
date(), 5.2
db_do_query(), 4.1, 4.2, 4.2, 5.1, 5.1, 5.2, 5.2, 5.2, 5.4
db_error (), 4.1
db_error(), 4.1, 5.4, 5.4
db_execute_statement(), 5.2, 5.2, 7.1
db_get_employees_rc(), 6.2
db_get_page_data(), 4.3, 4.3, 4.3, 5.2, 5.4
db_insert_thumbnail(), 7.1, 7.2, 7.2
delete_emp(), 5.2
do_query(), 3.2
get_dept_name(), 5.3
header(), 7.1
htmlentities(), 3.1
imagecopyresampled(), 7.2
imagecreatefromjpeg(), 7.2
imagecreatetruecolor(), 7.2
insert_new_emp(), 5.2, 5.5, 7.1
isset(), 4.1
modify_emp(), 5.2
oci_bind_by_name(), 4.2, 4.2
oci_close(), 3.3
oci_connect(), 3.2, 3.2.1, 3.3
oci_error(), 4.1
oci_execute(), 4.2
oci_fetch_all(), 4.1, 5.2
oci_fetch_array(), 3.2
oci_parse(), 3.2
OCI8 oci_pconnect(), 3.2.2
OCI8 oci_pconnect() function, 3.2.2
OCI-Lob->load(), 7.1
session_start(), 4.3
SYSDATE, 5.2
ui_print_department(), 4.3, 4.3, 4.4
ui_print_employees(), 5.1, 5.1, 5.2, 6.1, 7.1, 7.1
ui_print_error(), 5.4
ui_print_footer(), 3.1
ui_print_header(), 3.1
ui_print_insert_employee(), 5.2, 5.3, 7.1
ui_print_modify_employee(), 5.2
var_dump(), 3.2.1, 4.1

G

GD graphicsextension, 7.2
get_dept_name() function, 5.3
globalizing
applications, 8
calling locale specific functions, 8.4
character sets, 8.2
date formats, 8.7.1
determining user locale, 8.3
dynamic information, 8.6.3
HTML page encoding, 8.5
linguistic sorts, 8.7.3
NLS_LANGUAGE, 8.7.4
number formats, 8.7.2
PHP and Oracle environment, 8.1
presenting data, 8.7
sorting data, 8.7
translating the user interface, 8.6
GUI password
Zend Core for Oracle, 2.4.2

H

header() function, 7.1
hello.php
testing Zend Core for Oracle installation, 2.6
HTML
cascading style sheet, 3.1
employee data output, 5.1
form containing employee data, 5.2
generating employee data form, 5.2
page encoding, 8.5, 8.5.1.1, 8.5.1.2, 8.5.2
page header, 8.5.1.2
htmlentities() function, 3.1
HTTP header
page encoding, 8.5.1.1
httpd.conf Apache configuration file, 2.3.2
Human Resources (HR) application, 1.3

I

imagecopyresampled() function, 7.2
imagecreatefromjpeg() function, 7.2
imagecreatetruecolor() function, 7.2
images
creating a thumbnail, 7.2
creating thumbnails, 7.2
inserting employee thumbnail, 7.1
inserting in anyco.php, 7.1
storing in BLOBs, 7.1
include files
anyco_ui.inc, 3.1
anyco.php, 4.1
in anyco.php, 4.1, 4.1
insert_new_emp() function, 5.2, 5.5, 7.1
installation, 2.4.1, 2.4.2
Apache, 2.3
Oracle Database, 2, 2.2
root user, 2.4.2
Zend Core for Oracle, 2.4
Zend Core for Oracle install directory, 2.4.1, 2.4.2
Zend Core for Oracle on Linux, 2.4.2
Zend Core for Oracle on Windows, 2.4.1
isset() function, 4.1

J

JOBS table, 5.2
JPEG file, 7.2

L

LAST bind variable, 4.3
linguistic sorts, 8.7.3
locale, 8.3
location
Zend Core for Oracle, 2.4.1, 2.4.2
LOCATIONS table, 4.4

M

modify_emp() function, 5.2

N

navigating database records, 4.3, 4.3
NEWEID bind variable, 7.1
NLS_LANG environment variable, 8.1
NLS_LANGUAGE environment variable, 8.4, 8.7.4
NLS_TERRITORY environment variable, 8.4
NULL values, 3.2
number formats in Oracle, 8.7.2

O

obtaining
Apache, 2.3
Oracle Database, 2.2
Zend Core for Oracle, 2.4
OCI_B_CURSOR ref cursor, 6.2
oci_bind_by_name() function, 4.2, 4.2
oci_close() function, 3.3
OCI_COMMIT_ON_SUCCESS parameter, 3.2
oci_connect() function, 3.2, 3.2.1, 3.3
OCI_DEFAULT parameter, 3.2
oci_error() function, 4.1
oci_execute() function, 4.2
oci_fetch_all() function, 4.1, 5.2
oci_fetch_array() function, 3.2
OCI_FETCHSTATEMENT_BY_COLUMN parameter, 5.2
OCI_FETCHSTATEMENT_BY_ROW parameter, 4.1, 5.2, 5.2
oci_parse() function, 3.2
OCI_RETURN_NULLS parameter, 3.2
OCI8 oci_pconnect(), 3.2.2
OCI8 oci_pconnect() function, 3.2.2
oci8.max_persistent setting, 3.2.2
oci8.persistent_timeout setting, 3.2.2
oci8.ping_interval setting, 3.2.2
OCI-Lob->load() function, 7.1
Oracle
date formats, 8.7.1
establishing environment, 8.1
number formats, 8.7.2
tnsnames.ora, 3.2.1
Oracle Database
connecting, 3
installing, 2
obtaining and installing, 2.2
prerequisites, 2.1
OUT bind variable, 7.1

P

parameters
$bindargs, 5.1
$bindvars, 4.2, 4.2, 7.1
$conn, 3.2
$date, 3.1
$e, 5.4, 5.4, 5.4
$file, 4.1
$line, 4.1
$posturl, 4.3, 4.3
$q1, 4.3
$query, 5.2
$r, 4.1
$results, 4.1
$resulttype, 5.2
$rowsperpage, 4.3
$stid, 4.1, 4.2
$title, 3.1
charset, 8.5.1.1
deptid, 5.3
OCI_COMMIT_ON_SUCCESS, 3.2
OCI_DEFAULT, 3.2
OCI_FETCHSTATEMENT_BY_COLUMN, 5.2
OCI_FETCHSTATEMENT_BY_ROW, 4.1, 5.2, 5.2
OCI_RETURN_NULLS, 3.2
PHP, 1
application logic, 4.1
cascading style sheet, 3.1
character sets, 8.2
creating files, 3
determining user locale, 8.3
display_errors directive, 3.2.1
error_reporting directive, 3.2.1
establishing environment, 8.1
externalizing translatable strings, 8.6.1
GD graphicsextension, 7.2, 7.2
globalizing your application, 8
here document, 3.1
HTML page encoding, 8.5.2
NULL values, 3.2
oci8.max_persistent, 3.2.2
oci8.persistent_timeout, 3.2.2
oci8.ping_interval, 3.2.2
translating HTML and GIF files, 8.6.2
PHP functions
ui_print_footer(), 3.1
ui_print_header(), 3.1
PL/SQL
application procedures and functions, 6.1
calling function in anyco.php, 6.1
calling packaged procedure, 6.2
cv_types.et_employees() packaged procedure, 6.2
UTL_I18N package, 8.4
prerequisites for Oracle Database, 2.1
public virtual directory in Apache, 2.3.2
public_html
Apache, 2.3.2
creating, 2.3.2

Q

queries with bind variables, 4.2

R

ref cursors
OCI_B_CURSOR, 6.2
reporting in the application, 3
restarting Apache, 2.3.2
returning errors, 5.4
returning false statements, 5.4

S

session_start() function, 4.3
sorting, 8.7, 8.7.3
statements, returning false, 5.4
style.css
HTML presentation, 3.1
style.css description, 1.3
SYSDATE function, 5.2

T

tables
COUNTRIES, 4.4
DEPARTMENTS, 1.3, 3.2, 4.3, 4.4
EMPLOYEE_PHOTOS, 7.1, 7.1
EMPLOYEES, 1.3, 3.2, 4.4, 5.2, 5.2, 5.2, 7.1
JOBS, 5.2
LOCATIONS, 4.4
testing
anyco_db.inc, 4.2
anyco_ui.inc, 5.1
Apache installation on Linux, 2.3.2
Apache installation on Windows, 2.3.1
thumbnail images, 7.2
tnsnames.ora, 3.2.1
tutorial AnyCo Corp, 1.3

U

ui_print_department() function, 4.3, 4.3, 4.4
ui_print_employees() function, 5.1, 5.1, 5.2, 6.1, 7.1, 7.1
ui_print_error() function, 5.4
ui_print_footer() function, 3.1
ui_print_header() function, 3.1
ui_print_insert_employee() function, 5.2, 5.3, 7.1
ui_print_modify_employee() function, 5.2
unlocking HR account, 2.2.1, 6.1
user interface
externalizing translatable strings, 8.6.1
translating, 8.6
UTF-8
character set, 8.1
HTML page encoding, 8.5
UTL_I18N package, 8.4

V

var_dump() function, 3.2.1, 4.1
variables
$current, 4.3
$DID, 4.2
$emp, 5.3
$refcur, 6.2
__FILE__, 4.1, 5.4
__LINE__, 4.1, 5.4
department_id, 5.3

W

Web browser
testing Apache installation on Linux, 2.3.2
testing Apache installation on Windows, 2.3.1
Web server
Zend Core for Oracle, 2.4.1, 2.4.2

Z

Zend Core for Oracle, 1
configuration tab, 2.5
configuring, 2.5
GUI password, 2.4.2
hello.php, 2.6
installing on Linux, 2.4.2
installing on Windows, 2.4.1
obtaining and installing, 2.4
Web server, 2.4.1, 2.4.2