Last modified: Thursday, May 7, 2026
js-object.js SimpleXML package JSON
extension window.onload AND contains the
function checkFieldsthree-value.js's function
checkFields
as an event handler hum_conn_sess,
review clicker questions,
and a lab exercise
hum_conn_sess, which also
destroys the current session
if the database connection to Oracle fails
build_depts
that builds a form with a dynamically-built select/drop-down
form widget of current departmentsbuild_choice that
builds a form with radio buttons to choose whether you want more info
about a selected department itself or about its employeesempl, dept, and
customer request_name that
build a name-request form request_quest that
responds to request_name's
form with a quest-request form request_color that
responds to request_quest's form
with a color-request form show_farewell that
responds to request_color's
form with
a farewell and a link back to the calling PHP document
build_mini_form that
creates a small form with a textfield of a specified
name and a submit button with a specified label complain_and_exit that
creates a slightly-customized complaint page
and exits request_name that will eventually
build a name-request form request_quest that will eventually
respond to request_name's
form with a quest-request form request_color that will eventually
respond to request_quest's form
with a color-request form show_farewell that will eventually
respond to request_color's
form with
a farewell and a tiny return-to-beginning form
build_mini_form that
creates a small form with a textfield of a specified
name and a submit button with a specified label complain_and_exit that
creates a slightly-customized complaint page
and exits oci_commit
- (in tagged PDF) count_empl terminate_empl empl, dept, and
customer hum_conn_no_login
to make connection to Oracle more convenient oci_commit, and how to call PL/SQL stored functions
and PL/SQL stored procedures from PHP using OCI
oci_commit
- (in tagged PDF) get_manager from the Week 5 Lab Exercise
insert into an Oracle database (and then
committing that change!), and includes more use of
bind variables
add_dept hum_conn_no_login
to make connection to Oracle more convenient select/drop-down
form widget based on a SQL SELECT statement's
results, and intro to OCI bind variables to help
thwart SQL injection in a dynamic query built to
respond to a form
select/drop-down form widget
of employee numbers and last names, or uses a bind variable to try to
thwart SQL injection in the dynamic query it builds to display
information about the selected employee
hum_conn_no_login built during class,
to make connection to Oracle more convenient squarerequire_once in its
head element to include the contents of file
square.php, and then calls function square in
its body element if statement,
a couple of PHP superglobal associative arrays,
our first example of a PHP postback document (with code to
both create a form and respond to it), starting our
discussion of trying to fight against cross-site scripting
on the application tier, and briefly mentioning one of PHP's
server-side include functions, require_once
if statements, and also demonstrating
using one PHP document that builds both a form
AND its response (postback-style!), also demonstrating
attempts to sanitize the data from the client-tier justify-content
property (with thanks to Alex Coney for
suggesting!)justify-content
property (with thanks to Alex Coney for
suggesting!)328lect08-2-flex.css above;
here is the runnable version on nrs-projects: 328lect08-2-grid.css above;
here is the runnable version on nrs-projects: 328lect08-1.css above;
here is the runnable version on nrs-projects: 328lect07-1.css above;
here is the runnable version on nrs-projects: 328lect06-1.css above;
here is the runnable version on nrs-projects: normalize.css
job_overview and
PL/SQL stored functionjob_countloopyloopy, which demos three of PL/SQL's loop types
as well as handling no_data_found and too_many_rows
exceptionsdept table created and initially populated by
set-up-ex-tbls.sql if statement
job_count, which also has a
parameterjob_overview, which
has a parameter, calls job_count,
and includes an if statementdept table created and initially populated by
set-up-ex-tbls.sql hello_world and goofballhello_world
hello_world and goofballinput
attributes and also form widget elements
input type="radio" (radio button),
input type="checkbox" (checkbox),
textarea, and select (drop-down
box);
here is the runnable version on nrs-projects: form element
form element;
here is the runnable version on nrs-projects: table element; just started discussion
of HTML forms
table
element;
here is the runnable version on nrs-projects: 
title and p element added
so SOMETHING will display!);
here is the runnable version on nrs-projects: