Homeworks and Handouts

CS 328 - Web Apps Using Databases
Section 20 - CRN 21355 - MW 3:00-4:20pm
Spring 2024

Last modified: Wednesday, May 1, 2024

Important Announcements:

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

• Final Exam Review Suggestions (in tagged PDF)
  
  
• Week 14 Lab Exercise
  • Week 14 Lab Exercise (in tagged PDF)
  
  
• 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
    
    
  • Steve Friedl's Unixwiz.net Tech Tips - SQL Injection Attacks by Example
  • "How security flaws work: SQL injection"
  
  
• Week 13 Lab Exercise
  • Week 13 Lab Exercise (in tagged PDF)
    
    
  • CS 328 JavaScript Coding Standards so far
  • A Selection of JavaScript References
  
  
• Homework 10
  • Homework 10 handout (in tagged PDF)
  
  
• (Week 12 Lab Exercise was answering lab exercise questions during the Week 12 lab sesson.)
  
  
• Week 11 Lab Exercise
  • Week 11 Lab Exercise (in tagged PDF)
    
    
  • 328oci-commit.pdf - (in tagged PDF) - PHP - OCI function oci_commit
  • 328calling-stored-sub-intro.pdf - (in tagged PDF) - Basics of Calling PL/SQL Subroutines from PHP using OCI
    
    
  • php-form-handling.php - one PHP document building BOTH a form and its response (postback)
  • hum_conn_no_login.php - contains PHP function hum_conn_no_login
    • uses 328footer-plus-end.html
  • 328lect10-2-query-empls.php - queries multiple rows of employee info from Humboldt's Oracle database in a no-end-user-login fashion
    • uses hum_conn_no_login.php, try-oracle.css and 328footer-plus-end.html
  • 328bind-variable-intro.pdf - (in tagged PDF) - Basics of PHP/Oracle Bind Variables
    
    
  • php-strict-validation.pdf - (in tagged PDF) - one way to strict-validate a PHP document that dynamically generates different pages (such as either a form or a response to that form)
    
    
  • CS 328 PHP Coding Standards so far
  • www.php.net - "home page" for PHP
  • PHP manual , from www.php.net
  
  
• Exam 2 Review Suggestions (in tagged PDF)
  
  
• Homework 9
  • Homework 9 handout (in tagged PDF)
    
    
  • php-form-handling.php - one PHP document building BOTH a form and its response (postback)
  • 328lect10-2-query-empls.php - queries multiple rows of employee info from Humboldt's Oracle database in a no-end-user-login fashion
    
    
  • hum_conn_no_login.php - contains PHP function hum_conn_no_login
  • 328bind-variable-intro.pdf - (in tagged PDF) - Basics of PHP/Oracle Bind Variables
  • 328footer-plus-end.html - version of class-required footer that includes end tags for body and html elements
    
    
  • php-strict-validation.pdf - (in tagged PDF) - one way to strict-validate a PHP document that dynamically generates different pages (such as either a form or a response to that form)
    
    
  • CS 328 PHP Coding Standards so far
  • www.php.net - "home page" for PHP
  • PHP manual , from www.php.net
  
  
• Week 10 Lab Exercise
  • Week 10 Lab Exercise (in tagged PDF)
    
    
  • 328bind-variable-intro.pdf - (in tagged PDF) - Basics of PHP/Oracle Bind Variables
    
    
  • php-form-handling.php - one PHP document building BOTH a form and its response (postback)
  • hum_conn_no_login.php - contains PHP function hum_conn_no_login
    • uses 328footer-plus-end.html
  • 328lect10-2-query-empls.php - queries multiple rows of employee info from Humboldt's Oracle database in a no-end-user-login fashion
    • uses hum_conn_no_login.php, try-oracle.css and 328footer-plus-end.html
    
    
  • php-strict-validation.pdf - (in tagged PDF) - one way to strict-validate a PHP document that dynamically generates different pages (such as either a form or a response to that form)
    
    
  • CS 328 PHP Coding Standards so far
  • www.php.net - "home page" for PHP
  • PHP manual , from www.php.net
  
  
• Homework 8
  • Homework 8 handout (in tagged PDF)
    
    
  • php-form-handling.php - one PHP document building BOTH a form and its response (postback)
    
    
  • php-strict-validation.pdf - (in tagged PDF) - one way to strict-validate a PHP document that dynamically generates different pages (such as either a form or a response to that form)
    
    
  • CS 328 PHP Coding Standards so far
  • www.php.net - "home page" for PHP
  • PHP manual , from www.php.net
  
  
• Week 9 Lab Exercise
  • Week 9 Lab Exercise (in tagged PDF)
  • 328lab09-form.txt
    
    
  • php-form-handling.php - one PHP document building BOTH a form and its response (postback)
    
    
  • php-strict-validation.pdf - (in tagged PDF) - one way to strict-validate a PHP document that dynamically generates different pages (such as either a form or a response to that form)
    
    
  • CS 328 PHP Coding Standards so far
  • www.php.net - "home page" for PHP
  • PHP manual , from www.php.net
  
  
• Homework 7
  • Homework 7 handout (in tagged PDF)
    
    
  • hw7-2.html
  • hw7-3.html
    
    
  • 328lect08-1-play.html - which is styled by:
  • 328lect08-1.css - which has examples of using CSS to format a table element
  • Runnable version on nrs-projects:
    http://nrs-projects.humboldt.edu/~st10/s24cs328/328lect08-1/328lect08-1-play.html
    
    
  • 328lect08-2-play.html - which is styled by:
  • 328lect08-2.css - which has examples using flexbox and grid layouts
  • Runnable version on nrs-projects:
    http://nrs-projects.humboldt.edu/~st10/s24cs328/328lect08-2/328lect08-2-play.html
    
    
  • A selection of CSS references
  • CS 328 CSS Coding Standards so far
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
  
  
• Week 8 Lab Exercise
  • Week 8 Lab Exercise (in tagged PDF)
  • lab8-1.html
  • lab8-2.html
    
    
  • 328lect08-2-play.html - which is styled by:
  • 328lect08-2.css - which has examples using flexbox and grid layouts
  • Runnable version on nrs-projects:
    http://nrs-projects.humboldt.edu/~st10/s24cs328/328lect08-2/328lect08-2-play.html
    
    
  • A selection of CSS references
  • CS 328 CSS Coding Standards so far
  • 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
  • 328lect06-1.sql - includes PL/SQL trigger empl_trig
    
    
  • A selection of PL/SQL references
  • CS 328 SQL and PL/SQL Coding Standards so far
    
    
  • 328lect07-1-play.html - which is styled by:
  • 328lect07-1.css - our first external CSS stylesheet
  • Runnable version on nrs-projects:
    http://nrs-projects.humboldt.edu/~st10/s24cs328/328lect07-1/328lect07-1-play.html
    
    
  • A selection of CSS references
  • CS 328 CSS Coding Standards so far
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
    
    
  • https://developer.mozilla.org/en-US/docs/Web/CSS/Reference - direct link to MDN Web Docs' CSS Reference page, which includes "...an alphabetical index of all of the standard CSS properties, pseudo-classes, pseudo-elements, data types, and at-rules."
  
  
• Week 7 Lab Exercise
  • Week 7 Lab Exercise (in tagged PDF)
    
    
  • 328lect07-1-play.html - which is styled by:
  • 328lect07-1.css - our first external CSS stylesheet
  • Runnable version on nrs-projects:
    http://nrs-projects.humboldt.edu/~st10/s24cs328/328lect07-1/328lect07-1-play.html
    
    
  • A selection of CSS references
  • CS 328 CSS Coding Standards so far
  • https://jigsaw.w3.org/css-validator/ - W3C CSS Validator
    
    
  • https://developer.mozilla.org/en-US/docs/Web/CSS/Reference - direct link to MDN Web Docs' CSS Reference page, which includes "...an alphabetical index of all of the standard CSS properties, pseudo-classes, pseudo-elements, data types, and at-rules."
  
  
• Week 6 Lab Exercise
  • Week 6 Lab Exercise (in tagged PDF)
    
    
  • set-up-ex-tbls.sql - for reference
  • 328lect06-1.sql - includes PL/SQL trigger empl_trig
    
    
  • A selection of PL/SQL references
  • CS 328 SQL and PL/SQL Coding Standards so far
  
  
• 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 functionjob_count
  • 328lect05-2.sql - includes refactored version of PL/SQL stored procedure job_overview and 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!
    
    
  • A selection of PL/SQL references
  • CS 328 SQL and PL/SQL Coding Standards so far
    
    
  • create-bks.sql
  • pop-bks.sql
  
  
• 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 refactored version of PL/SQL stored procedure job_overview and PL/SQL stored procedure loopy
    
    
  • A selection of PL/SQL references
  • CS 328 SQL and PL/SQL Coding Standards so far
  
  
• Homework 4
  • Homework 4 handout (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  • A selection of HTML references
  • CS 328 HTML Coding Standards so far
    
    
  • hello.sql - includes PL/SQL stored procedure hello_world
  • A selection of PL/SQL references
  • CS 328 SQL and PL/SQL Coding Standards so far
    
    
  • create-bks.sql
  • pop-bks.sql
  
  
• Week 4 Lab Exercise
  • Week 4 Lab Exercise (in tagged PDF)
    
    
  • html-template.html
  • A selection of HTML references
  • CS 328 HTML Coding Standards so far
    
    
  • hello.sql - includes PL/SQL stored procedure hello_world
  • set-up-ex-tbls.sql - for reference
  • A selection of PL/SQL references
  • CS 328 SQL and PL/SQL Coding Standards so far
  
  
• Homework 3
  • Homework 3 handout (in tagged PDF)
    
    
  • html-template.html - required class HTML template page, including required validation link at the bottom
  • A selection of HTML references
  • CS 328 HTML Coding Standards so far
    
    
  • create-bks.sql
  • pop-bks.sql
  
  
• Week 3 Lab Exercise
  • Week 3 Lab Exercise (in tagged PDF)
    
    
  • html-template.html
  • A selection of HTML references
  • CS 328 HTML Coding Standards so far
  
  
• 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)
    
    
  • A selection of HTML references
  • CS 328 HTML Coding Standards so far
  
  
• 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.txt - an example results file for Problem 4, for comparison purposes
  
  
• 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