Index

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

---

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.2

anyco_cn.inc

creating, 4.1

description, 1.2

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.2

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.2

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.2

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.2

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.6

httpd.conf configuration file, 2.3.6

public_html, 2.3.6

restarting, 2.3.6

testing installation on Linux, 2.3.6

testing installation on Windows, 2.3.3

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.2

files directory, 2.5, 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.6

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.5, 3.1

PHP files, 3

public_html, 2.3.6

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.2, 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.2, 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.2

anyco_db.inc description, 1.2

anyco_im.php description, 1.2

anyco_ui.inc description, 1.2

anyco.php description, 1.2

application, 2.5, 3.1

application naming convention, 1.2

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.2

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

---

H

header() function, 7.1

hello.php

testing PHP installation, 2.5

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.6

Human Resources (HR) application, 1.2

---

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

Oracle Database, 2, 2.2

PHP on Linux, 2.4.2

PHP on Windows, 2.3.1, 2.3.4, 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

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

Oracle Database, 2.2

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

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

hello.php, 2.5

here document, 3.1

HTML page encoding, 8.5.2

installing on Linux, 2.4.2

installing on Windows, 2.3.1, 2.3.4, 2.4.1

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 - PHP Hypertext Preprocessor, 1

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.6

public_html

Apache, 2.3.6

creating, 2.3.6

---

Q

queries with bind variables, 4.2

---

R

ref cursors

OCI_B_CURSOR, 6.2

reporting in the application, 3

restarting Apache, 2.3.6

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.2

SYSDATE function, 5.2

---

T

tables

COUNTRIES, 4.4

DEPARTMENTS, 1.2, 3.2, 4.3, 4.4

EMPLOYEE_PHOTOS, 7.1, 7.1

EMPLOYEES, 1.2, 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.6

Apache installation on Windows, 2.3.3

thumbnail images, 7.2

tnsnames.ora, 3.2.1

tutorial AnyCo Corp, 1.2

---

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.6

testing Apache installation on Windows, 2.3.3