Homeworks and Handouts

CS 328 - Web Apps Using Databases
Section 10 - CRN 22226 - MW 3:00-4:20pm
Spring 2026

Last modified: Thursday, May 7, 2026

Important Announcements:

• (...may appear here as/if needed!)

• Week 15 Lab Exercise
  • Week 15 Lab Exercise (in tagged PDF)
  
  
• Final Exam Review Suggestions (in tagged PDF)
  
  
• Small-Homework-Bonus JavaScript Problem
  • Small-Homework-Bonus JavaScript Problem handout (in tagged PDF)
    
    
  • CS 328 JavaScript Coding Standards so far
  • A Selection of JavaScript References
  
  
• Week 14 Lab Exercise
  • Week 14 Lab Exercise (in tagged PDF)
    
    
  • 328lab14-1-start.html - syntax-colored display version of an HTML starting-document for Week 14 Lab Exercise's Problem 1
    
    
  • 328lab14-2.php - syntax-colored display version of a PHP starting-document for Week 14 Lab Exercise's Problem 2
  • 328lab14-functs.php - syntax-colored display version of some helper-PHP-functions for Week 14 Lab Exercise's Problem 2
  • 328lab14.css - syntax-colored display version of a little styling for Week 14 Lab Exercise's Problem 2
    
    
  • CS 328 JavaScript Coding Standards so far
  • A Selection of JavaScript References
  
  
• Homework 11
  • Homework 11 handout (in tagged PDF)
    
    
  • hum_conn_sess.php - syntax-colored display version of PHP function hum_conn_sess, which also destroys the current session if the database connection to Oracle fails
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• Week 13 Lab Exercise
  • Week 13 Lab Exercise (in tagged PDF)
  • Week 13 Lab Exercise Finite State Diagram
    
    
  • hum_conn_sess.php - syntax-colored display version of PHP function hum_conn_sess, which also destroys the current session if the database connection to Oracle fails
    
    
  • 328lab13.css - a little styling for 328lab13.php
    
    
  • build_depts.php - contains PHP function build_depts that builds a form with a dynamically-built select/drop-down form widget of current departments
  • build_choice.php - contains PHP function build_choice that builds a form with radio buttons to choose whether you want more info about a selected department itself or about its employees
    
    
  • set-up-ex-tbls.sql - creates and initially populates the example tables empl, dept, and customer
  
  
• Homework 10
  • Homework 10 handout (in tagged PDF)
    
    
  • Basics of Oracle/PHP Bind Variables - (in tagged PDF)
  • Basics of Calling PL/SQL Subroutines from PHP using OCI - (in tagged PDF)
  • Basics of PHP - OCI function oci_commit - (in tagged PDF)
  • A selection of PHP references
    
    
  • hum_conn_no_login.php - syntax-colored display version of PHP function hum_conn_no_login to make connection to Oracle more convenient
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• Week 12 Lab Exercise
  • Week 12 Lab Exercise (in tagged PDF)
    
    
  • Basics of Calling PL/SQL Subroutines from PHP using OCI - (in tagged PDF)
  • Basics of PHP - OCI function oci_commit - (in tagged PDF)
    
    
  • count_empl.sql - creates and tests PL/SQL stored function count_empl
  • terminate_empl.sql - creates and tests PL/SQL stored procedure terminate_empl
    
    
  • set-up-ex-tbls.sql - creates and initially populates the example tables empl, dept, and customer
  • hum_conn_no_login.php - syntax-colored display version of PHP function hum_conn_no_login to make connection to Oracle more convenient
  
  
• Week 11 Lab Exercise
  • Week 11 Lab Exercise (in tagged PDF)
    
    
  • Basics of Oracle/PHP Bind Variables - (in tagged PDF)
  • hum_conn_no_login.php - syntax-colored display version of PHP function hum_conn_no_login to make connection to Oracle more convenient
  
  
• Exam 2 Review Suggestions (in tagged PDF)
  
  
• Basics of Oracle/PHP Bind Variables - (in tagged PDF)
  
  
• Homework 9
  • Homework 9 handout (in tagged PDF)
    
    
  • hum_conn_no_login.php - syntax-colored display version of PHP function hum_conn_no_login to make connection to Oracle more convenient
    
    
  • Steve Friedl's Unixwiz.net Tech Tips - SQL Injection Attacks by Example
  • "How security flaws work: SQL injection"
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• Week 10 Lab Exercise
  • Week 10 Lab Exercise (in tagged PDF)
    
    
  
  
• Homework 8
  • Homework 8 handout (in tagged PDF)
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 9 Lab Exercise
  • Week 9 Lab Exercise (in tagged PDF)
  
  
• Homework 7
  • Homework 7 handout (in tagged PDF)
    
    
  • 328hw07-1-start.html - syntax-colored display version
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 8 Lab Exercise
  • Week 8 Lab Exercise (in tagged PDF)
  
  
• Homework 6
  • Homework 6 handout (in tagged PDF)
    
    
  • Some string- and date- and time-related SQL functions (in tagged PDF)
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 7 Lab Exercise
  • Week 7 Lab Exercise (in tagged PDF)
  
  
• Week 6 Lab Exercise
  • Week 6 Lab Exercise (in tagged PDF)
    
    
  • lab6-start.html - syntax-colored display version
    
    
  • 328lect06-1.html - which is styled by:
  • 328lect06-1.css - our first external CSS stylesheet
  • Runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s26cs328/328lect06-1/328lect06-1.html
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Exam 1 Review Suggestions (in tagged PDF)
  
  
• Homework 5
  • Homework 5 handout (in tagged PDF)
    
    
  • 328lect05-1.sql - includes PL/SQL stored procedure job_overview and PL/SQL stored function job_count
  • 328lect05-2.sql - includes PL/SQL stored procedure loopy
  • Some string- and date- and time-related SQL functions - because these can be called in PL/SQL statements as well!
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• Week 5 Lab Exercise
  • Week 5 Lab Exercise (in tagged PDF)
    
    
  • set-up-ex-tbls.sql - for reference
  • 328lect05-1.sql - includes PL/SQL stored procedure job_overview and PL/SQL stored functionjob_count
  • 328lect05-2.sql - includes PL/SQL stored procedure loopy
  
  
• Homework 4
  • Homework 4 handout (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  • 328lect04-2.sql - includes PL/SQL stored procedures hello_world and goofball
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• Week 4 Lab Exercise
  • Week 4 Lab Exercise (in tagged PDF)
    
    
  • Some Additional Form Widgets - (in tagged PDF)
  • html-template.html - required class HTML template page, including required validation link at the bottom
    
    
  • 328lect04-2.sql - includes PL/SQL stored procedures hello_world and goofball
  • set-up-ex-tbls.sql - for reference
  
  
• Homework 3
  • Homework 3 handout (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  • prob5-out.pdf - an example results file for Problem 5, for comparison purposes
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• Week 3 Lab Exercise
  • Week 3 Lab Exercise (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  
  
• Homework 2
  • Homework 2 handout (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  • html-style-play-before.html - for Problem 2
  
  
• Week 2 Lab Exercise
  • Week 2 Lab Exercise (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  
  
• Homework 1
  • Homework 1 handout (in tagged PDF)
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
    
    
  • bks-play-out.pdf - an example results file for Problem 4, for comparison purposes
    
    
  • Useful details: ssh and sftp - (in tagged PDF)
  • Useful details: ~st10/328submit - (in tagged PDF)
  
  
• Week 1 Lab Exercise
  • Week 1 Lab Exercise (in tagged PDF)
    
    
  • Connecting to nrs-projects and sqlplus - (in tagged PDF)
  • Useful details: ssh and sftp - (in tagged PDF)
  • Useful Linux commands - (in tagged PDF)
  • Useful details: ~st10/328submit - (in tagged PDF)
  • Setting up your nrs-projects web directory - (in tagged PDF)
  
  
• CS 328 Course Syllabus (in tagged PDF)

Back to course home page