CO3041 Databases and the Web

Introduction and announcements

Welcome to Databases and the Web 2012/13!
This page is intended to hold a few resources that are awkward to host on StudySpace ... everything else will be on StudySpace! Material from the last 2011/12 module run is here.

This module teaches you how to develop database-driven web pages/sites/applications using (X)HTML, PHP and MySQL. See the module guide for a tentative schedule, reading list and further information. (Also available on StudySpace.)

Important information:

Backup your work!

Always remember to backup your work from your network drive! Ideally you should have copies on the network H: drive and on USB/CD but if you use on StudentNet secure it with a login of some sort of login (PHP/MySQL/sesssions/.htaccess etc.)

Please use valid mark-up & a DOCTYPE!

<!DOCTYPE html>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

Remember to validate your pages and if you're using the HTML5 DOCTYPE, justify it in your report!

Character encoding & META tags

META tags are used to provide information about a web page (i.e. information about information). The following META tag is needed in many XHTML web pages when validating as it identifies the character encoding used in the page (ISO-8859-1 is `Western European' whereas Unicode UTF-8 is supposed to be a catch-all encoding):

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

About this page

I've tried to practice a little of what I preach: This page validates as Strict XHTML and CSS, uses mainly semantic markup and CSS for layout. In addition it should be served as application/xhtml+xml to standards-compliant browsers that understand the proper media type for XHTML ... and text/html otherwise ;-)

Send any comments to me at:

Dr James Denholm-Price

Principal Lecturer
Kingston University
Faculty of SEC
Kingston University
Penrhyn Road
Kingston upon Thames
KT1 2EE
work: 02084172670
hcard

Files:

Weekly slides

Exercises

Weekly audio

NB audio may not correspond 1-to-1 with numbered lecture slides and may contain waffle, occasional swearing, etc, so beware ;-)

(Un)related

Links

W3C

Strict HTML

Browsers

Validation

Valid XHTML 1.0!

License

Creative Commons License This work is licenced under a Creative Commons License. Kingston University Home Page