Category: Programming

Posted on

Web Scripting for Applications Week 7

In the lab

This lab is all about developing a CRUD system for the EMP database table set up in week 6 – the initial code required is in this zip file. Extract the file, ensuring that you maintain the directory structures given.

You will be shown how to wire this code up in class

Exercises

The exercises take you through setting up a small web site using folders, CSS and other techniques

Exercises: PHP exercises

Code for exercises: code

Posted on

Web Scripting for Applications Week 6

Materials for first week back ..

Lecture 6 on mysql and php/phpmyadmin

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

empform code empform.php

Here are some SQL insert statements that may be useful:

insert into emp (empno,ename,sal) values (120, “SMITH”, 22000);
insert into emp (empno,ename,sal) values (121, “JONES”, 23000);
insert into emp (empno,ename,sal) values (122, “AVERY”, 22500);
insert into emp (empno,ename,sal) values (124, “MITCHELL”, 26000);
insert into emp (empno,ename,sal) values (127, “WEBB”, 22000);
insert into emp (empno,ename,sal) values (129, “TENNENT”, 22000);
insert into emp (empno,ename,sal) values (130, “RUSSELL”, 25000);

Exercise for lab: PHP exercise

Code for lab: codeforlab1

Posted on

Web Scripting for Applications Assessment

The Web Scripting for Applications module has one assessment and one exam.

The assessment is collated from the exercises you have worked on every week, as detailed in Web Scripting for Applications Coursework

A word document containing all your work will be automatically generated for you – you do NOT have create this document yourself.

The final date for submission of work to the foliocube system will be December 21st @ 6:00pm. At this point no other work will be accepted by the system.