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