Last modified: Friday, May 9, 2025
js-object.js SimpleXML package JSON
extension 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 empl, 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 count_empl terminate_empl empl, dept, and
customer hum_conn_no_login
to make connection to Oracle more convenient footer
and the end tags for the body and
html from the end of html-template.html,
for more-convenient require_once use oci_commit, and how to call PL/SQL stored procedures
and PL/SQL stored functions from PHP using OCI
oci_commit
- (in tagged PDF) insert into an Oracle database (and then
committing that change!), and includes more use of
bind variables
add_dept add_dept_2 hum_conn_no_login
to make connection to Oracle more convenient footer and the end tags for the body
and html from the end of
html-template.html, for more-convenient
require_once use require_once to include that function as well as
HTML snippets in another PHP document, and writing a postback PHP
that uses a query to dynamically build a
select/drop-down form widget, and also uses a
bind variable to try to thwart SQL injection in
the dynamic query it builds to repond to its form
hum_conn_no_login built during class,
to make connection to Oracle more convenient footer and the end tags for the
body and html from the end of
html-template.html, for more-convenient
require_once use 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
select using OCI
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,
and 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), and starting our
discussion of trying to fight against cross-site scripting
on the application tier
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 328lect08-2-2-grid.css above;
here is the runnable version on nrs-projects: 328lect08-2-1-flex.css above;
here is the runnable version on nrs-projects: 328lab08-1.html328lab08-2.html328lect08-2.css above;
here is the runnable version on nrs-projects: footer element's
font-size
328lect08-1.css above;
here is the runnable version on nrs-projects: 328lect07-1.css above;
here is the runnable version on nrs-projects: normalize.css
empl_trig in files trigger1.sql through
trigger4.sqlempl_trig below
uses the empl table
created and initially populated by
set-up-ex-tbls.sql
empl_trig, and its spooled output empl_trig, omitting the for each
row from its header, and its spooled output
empl_trig, now demonstrating the
:old. and :new. syntax for
obtaining column values of the triggering change (and a bit more),
and its spooled output empl_trig, demonstrating use of
raise_application_error to PREVENT
a triggering action from being actually done 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
exceptionsreverse_play, which plays with for loops
with and without reverse dept 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_worldhello_world
hello_world input element attributes,
and two more input element types:
radio buttons and checkboxes
input
attributes and also form widget elements
input type="radio" (radio button) and
input type="checkbox" (checkbox);
here is the runnable version on nrs-projects: form element
form element;
here is the runnable version on nrs-projects: table element
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: