Homeworks and Handouts

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

Last modified: Friday, May 9, 2025

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)
    
    
  • CS 328 JavaScript Coding Standards so far
  • A Selection of JavaScript References
  
  
• Homework 11
  • Homework 11 handout (in tagged PDF)
    
    
  • "Designing for accessiblity is not that hard" - a good article on designing for accessibility
  • http://teachaccess.org/initiatives/tutorial/ - the Teach Access Initiative's short tutorial on accessibility, for inclusion in web and app design/development courses
    
    
  • hum_conn_no_login.php - syntax-colored display version of PHP function hum_conn_no_login to make connection to Oracle more convenient
  • 328footer-plus-end.html - syntax-colored display version of HTML snippet containing just the footer and the end tags for the body and html from the end of html-template.html, for more-convenient require_once use
    
    
  • 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
  • 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 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
  • 328footer-plus-end.html - syntax-colored display version of HTML snippet containing just the footer and the end tags for the body and html from the end of html-template.html, for more-convenient require_once use
    
    
  • 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)
  • 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
  • 328footer-plus-end.html - syntax-colored display version of HTML snippet containing just the footer and the end tags for the body and html from the end of html-template.html, for more-convenient require_once use
  
  
• 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
  • 328footer-plus-end.html - syntax-colored display version of HTML snippet containing just the footer and the end tags for the body and html from the end of html-template.html, for more-convenient require_once use
  
  
• Exam 2 Review Suggestions (in tagged PDF)
  
  
• Homework 9
  • Homework 9 handout (in tagged PDF)
    
    
  • try-oracle.php - original "short form" version
    • Runnable version on nrs-projects:
      https://nrs-projects.humboldt.edu/~st10/s25cs328/328lect10-2/try-oracle.php
    
    
  • try-oracle-explained.php - version with more comments included
    • Runnable version on nrs-projects:
      https://nrs-projects.humboldt.edu/~st10/s25cs328/328lect10-2/try-oracle-explained.php
    
    
  • hum_conn_no_login.php - syntax-colored display version of PHP function hum_conn_no_login to make connection to Oracle more convenient
  • 328footer-plus-end.html - syntax-colored display version of HTML snippet containing just the footer and the end tags for the body and html from the end of html-template.html, for more-convenient require_once use
    
    
  • empl-ex.php - an example querying multiple rows and displaying the results in a table element
    • uses: hum_conn_no_login.php , 328footer-plus-end.html , and try-oracle.css
    • Runnable version on nrs-projects:
      https://nrs-projects.humboldt.edu/~st10/s25cs328/empl-ex.php
    
    
  • Basics of Oracle/PHP Bind Variables - (in tagged PDF)
  • 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)
    
    
  • 328lab10-start.php - syntax-colored display version
  
  
• Homework 8
  • Homework 8 handout (in tagged PDF)
    
    
  • 328lect09-2.php - trying out some PHP 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
  • Runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s25cs328/328lect09-2/328lect09-2.php
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 9 Lab Exercise
  • Week 9 Lab Exercise (in tagged PDF)
    
    
  • 328lab09-form.txt - syntax-colored display version
    
    
  • 328lect09-2.php - trying out some PHP 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
  • Runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s25cs328/328lect09-2/328lect09-2.php
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Homework 7
  • Homework 7 handout (in tagged PDF)
    
    
  • hw7-2.html - syntax-colored display version
  • hw7-3.html - syntax-colored display version
  • hw7-4.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)
    
    
  • 328lab08-1-start.html - syntax-colored display version
  • Desired goal for styled 328lab08-1.html
    
    
  • 328lab08-2-start.html - syntax-colored display version
  • Desired goal for styled 328lab08-2.html
    
    
  • 328lect08-2.html - which is styled by:
  • 328lect08-2.css
  • Runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s25cs328/328lect08-2/328lect08-2.html
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Homework 6
  • Homework 6 handout (in tagged PDF)
    
    
  • init-sal-history.sql - creates and populates a table salary_history for use in Problem 2
    
    
  • In-class Examples - look in the Week 6 Lecture 1 examples at the different versions of PL/SQL trigger empl_trig in files trigger1.sql through trigger4.sql
    
    
  • 328lect07-1.html - which is styled by:
  • 328lect07-1.css - our first external CSS stylesheet
  • Runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s25cs328/328lect07-1/328lect07-1.html
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 7 Lab Exercise
  • Week 7 Lab Exercise (in tagged PDF)
    
    
  • lab7-start.html - syntax-colored display version
    
    
  • 328lect07-1.html - which is styled by:
  • 328lect07-1.css - our first external CSS stylesheet
  • Runnable version on nrs-projects:
    https://nrs-projects.humboldt.edu/~st10/s25cs328/328lect07-1/328lect07-1.html
    
    
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 6 Lab Exercise
  • Week 6 Lab Exercise (in tagged PDF)
    
    
  • In-class Examples - look in the Week 6 Lecture 1 examples at the different versions of PL/SQL trigger empl_trig in files trigger1.sql through trigger4.sql
  • set-up-ex-tbls.sql - for reference
  
  
• 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 procedures loopy and reverse_play
  • 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
  • hello.sql - includes PL/SQL stored procedure hello_world
    
    
  • 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)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
    
    
  • hello.sql - includes PL/SQL stored procedure hello_world
  • 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.txt - 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)
    
    
  • bks-play-out.txt - an example results file for Problem 4, for comparison purposes
    
    
  • create-bks.sql - creates the tables for the bookstore database
  • pop-bks.sql - initially populates the bookstore database
  
  
• 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