Bishop's coat of arms Valid HTML 4.01
        Transitional

Interactive web page design, & Database

The web page for CS 203 & CS 207

Fall 2017 class

Class list with link to pages

See your Marks and remarks

Class list (Winter 2017) with link to pages

Class list (Fall 2016) with link to pages

Class list (Fall 2015) with link to pages

Class list (Winter 2015) with link to pages

Class pictures

CS 203 Course Outline

CS 207 Course Outline

Links to the on-line material:

Course pack Contents

Advanced material and student pages at Osiris
Documentation refrences

203 Quizzes

20 minutes, in class, open book
  1. Friday, October 6, covering HTML and CSS
  2. Friday; October 27, PHP

CS 203 Lab Assignments

  1. September 11, A first HTML page
  2. September 18, a Table, and transfer files to Osiris
  3. September 25, A second page, CSS styles, and images
  4. October 2, A form
  5. October 16, PHP to process your form data
  6. October 24, add write to file to the above
  7. October 30, first steps in JavaScript
  8. November 6, use Javascript to check your form
  9. November 13, complete form check using Javascript
  10. November 20, cookie, positioning, private folder
  11. November 27 do some more improvements,  Finish up your pages, clean up. Your final page content will be assigned a grade right after the final exam, which is Wednesday December 6 at 9:00. Delete anything obsolete or ugly. There is a final scheduled lab period on Thursday, November 30.

CS 207 Midterm

Wednesday, 15 February 2017

CS 207 Assignments

  1. January 16, 2017 An organization, and a form
  2. January 23, 2017 Use database for form request
  3. January 30, 2017 A second table, and php to modify
  4. February 6, 2017
  5. February 13, 2017 Do more, validate a page
  6. February 20, 2017
    (Reading Week)
  7. March 6, 2017
  8. March 13, 2017
  9. March 20, 2017
  10. March 27, 2017 Improve!
  11. April 3, 2017
  12. Wednesday, April 8 Last lab period. I will be there, use it to finish up your semester's work. Yes, back up your work! pg_dump, tar... :

Database backup instructions



Images: slideshow examples

Registration demonstration Sign in (password required)


Documentation

Cautionary tales

PHP:  www.php.net  especially useful is the Function Reference, by categories

PostgreSQL, Find at www.postgresql.org

Finding help while using psql, etc.

Other language documentation

(subject to upgrades, my links will go out of date whenever a version changes)

Anatomy of an HTML page

Web pages are written in HTML format, which is a "plain text" file that uses "markup tags" to control the appearance of the displayed text. Tags come in pairs that are nested, and define sections, paragraphs, lists, in-line enhancements, etc. The whole page , for instance, is bracketed by <html> ... </html>

Author will be very useful if I print the source of your page, so I can give you credit!

<!DOCTYPE HTML>
<html>
<head>
<title>Hello Page</title>
<meta name="author" content="Lin Jensen">
</head>
<body>
<h1>
Hello
World!
</h1>
How are you?
How's the weather in <em>Lennoxville?</em>
<p>
This is a paragraph.
blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah
blah, blah <strong>blah, blah</strong> blah, blah
</p>
</body>
</html>

This source looks like:

Hello World!

How are you? How's the weather in Lennoxville?

This is a paragraph. blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah blah, blah


Go to Course notes Contents
Home page of Lin Jensen