Last modified: Wednesday, May 1, 2024
js-object.js SimpleXML package JSON
extension window.onload to a function that
inserts today's date into a particular
p element's content
with the help of JavaScript's Date objectwindow.onload AND contains the
function checkFieldsthree-value.js's function
checkFields
as an event handler build_dept_form show_dept_details
build_dept_form show_dept_details
choose_widget build_dept_drop_down build_dept_radio
hum_conn_sess destroy_then_exit that
destroys the current session,
creates a slightly-customized complaint page,
and exits request_name that
builds 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 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 hsu_conn_sess
which also destroys the current session and whose output includes
a "try again" link back to the containing PHPrequest_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,
how to call PL/SQL stored procedures and PL/SQL stored functions
from PHP using OCI, review clicker questions, and a lab exercise
oci_commit hum_conn_no_login
hum_conn_no_login
hum_conn_no_login,
included below, that you are WELCOME to use!
And used it in our second example connecting
PHP to Oracle using OCI (Oracle Call Interface):
example requesting a SQL select using OCI that
returns multiple rows
hum_conn_no_login, abstracting
out the common code we've been using to connect to the
Humboldt Oracle student database in a no-end-user-login fashion
select using OCI
footer that
now includes end tags for body and
html elements, for more convenient use
in "error" situations (bad usernames/passwords, for example!)
gettype
and a few of its is_type functions for a
few expressions; also demos a PHP variable
square squarehtml-template.htmlrequire_once to
include the contents of file
square.php, and then calls function square,
and also to include the contents of
328footer.html328lect08-2.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: normalize.css
empl_trigempl_trig
empl and customer tables created and
initially populated by
set-up-ex-tbls.sql job_overview and
PL/SQL stored functionjob_countjob_overview and PL/SQL stored procedure loopyjob_overview, which
now calls 328lect05-1.sql's stored function
job_count loopy, 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_overview, which
has a parameter and includes an if statementjob_count, which also has a
parameterdept table created and initially populated by
set-up-ex-tbls.sql hello_worldhello_world
hello_world textarea element, and the select
element (used for drop-downs)
input type="radio" (radio button),
input type="checkbox" (checkbox),
input type="password" (password field),
textarea, and select (drop-down);
here is the runnable version on nrs-projects: table element; started intro to HTML forms (to the
HTML form element)
table
and form elements;
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: