Introduction and announcements
Databases and the Web 2011/12 is over!
This page was used to hold a few resources that are awkward to host on Blackboard and is retained purely to link to past resources.
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.)
Project groups
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 ;-)
There's also an RSS feed containing available lecture audio.
(Be warned! The tracks are essentially unedited so contain lots of "ummm" and other inconsequential content together with occasional profanity ... sorry!)
Send any comments to me at:
Dr James Denholm-Pricej.denholm-price@kingston.ac.uk
Principal Lecturer
Kingston University
Faculty of SEC
Kingston University
Penrhyn Road
Kingston upon Thames
KT1 2EE
work: 02084172670
