Archive for January, 2012

Relational Databases – mySQL and projection

January 30th, 2012 No comments

The lecture slides used for the first session on databases relational database handout slides

SQL file required to set up the EMP database in mySQL empDB

SQL notes on using mySQL and the projection statement SQL Session 1

Notes on setting up your own version of MAMP (mac) Installing and using MAMP

Notes on setting up your own version of XAMPP (Windows 7) Installing and using XAMPP

Categories: BIS, BIT Tags: ,

ITB results 11/12

January 16th, 2012 No comments

This PDF file has the results for the first HTML test (10%) and the second multiple choice test (20%). Grades for the coursework will follow in a week or so. BB1753 ITB.pdf

Here are the feedback sheets for the major piece of coursework on ITB. To find yours, download the PDF and search for your K number (it can be lower or upper case k) BB1753 ITB ALL

This grid shows all the marks in one column (again – by k number only) BB1753 ITB Marks 1112

Please note that grades have not been moderated or passed through an exam board yet, so it is possible that they may change (this is unusual but can happen).

If you see any glaring issues then please email me

Web Scripting coursework results 11/12

January 16th, 2012 No comments

The (unmoderated) coursework results are available. As they are unmoderated it is possible (but unlikely) that they may be changed slightly either by the moderator or by the exam board. This rarely happens but it is possible…

This grid has the coursework results by kuid number BB2006 Web Scripting – CSWK Marks 1112

This (large) PDF file has the feedback sheets for the coursework – open the file in your PDF reader and search for your ku ID number (some of them are kxxxxx whilst some are Kxxxxx) – no names are included in the sheet BB2006 Web Scripting ALL

Categories: Programming Tags: ,

Using the SMARTY system for MVC

January 6th, 2012 No comments

Lecture Slides

MVC lecture

Lab Exercise

SMARTY is a templating system that allows for the separation of a PHP project into Model, View and Controller subparts. This exercise takes you through the steps required to create a small SMARTY application.

PHP exercise – MVC

These are the base zip files required to get the SMARTY application started lab11

These are the supplementary files needed for the second half of the exercise lab 11 more files

These are the final versions of the files, should you not manage to get the versions/exercises working (note that you would still need to edit the class.EmpDB.php file to include your database server, database name, username and password) lab11 final

Categories: Programming Tags: