Prac

Prac is available for download.

This is a dump of the database structure that you can use to create the 'registration' db on your localhost, using phpMyAdmin.

Creat the db in phpMyAdmin
Click on the db in the left columf drop-down
click on SQL
Cop and paste the dump here below the --------- (excluding the -----------) in the textarea and Go.

--------------------------------------------------

-- phpMyAdmin SQL Dump
-- version 2.6.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 05, 2006 at 10:46 AM
-- Server version: 4.1.10
-- PHP Version: 4.3.9
--
-- Database: `registration`
--

-- --------------------------------------------------------

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
`cname` varchar(50) NOT NULL default '',
`cid` int(6) NOT NULL auto_increment,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `course`
--


-- --------------------------------------------------------

--
-- Table structure for table `course_student`
--

CREATE TABLE `course_student` (
`sno` int(6) NOT NULL default '0',
`cid` int(6) NOT NULL default '0',
`year` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_student`
--


-- --------------------------------------------------------

--
-- Table structure for table `student`
--

CREATE TABLE `student` (
`sno` int(6) NOT NULL auto_increment,
`sname` varchar(40) NOT NULL default '',
`init` varchar(5) NOT NULL default '',
`fname` varchar(40) NOT NULL default '',
`title` varchar(4) NOT NULL default '',
`msname` varchar(40) NOT NULL default '',
`dob` varchar(8) NOT NULL default '',
`sex` char(2) NOT NULL default '',
`lang` varchar(10) NOT NULL default '',
`idno` varchar(13) NOT NULL default '',
`telh` varchar(12) NOT NULL default '',
`telw` varchar(12) NOT NULL default '',
`cel` varchar(12) NOT NULL default '',
`fax` varchar(12) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`address` tinytext NOT NULL,
PRIMARY KEY (`sno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `student`
--

just a question, will we also be marked on the look and feel such as how user friendly the website (i.e. does it conform to the human computer interaction principals) and how cool it looks.

Or will we only be marked according to the code?

Code only.

Sorry Mac, two more questions:

Can we host this on our own servers? I'd just be happier building and testing this in the environment it'll be used.

And, is there any requirement for authentication for the administrator/students?

Thanks,
barry

(enjoying getting stuck in to this)

when does this need to b completed by?

Own server if you wish by all means.

No authentication required - you can if you want, - but remember, the students must be able to regisiter without having to authenticate.

We feel that this will keep you busy long enough. Stated otherwise, we expect you to spend 3 days searching with something that should take you 5 minutes just the way it is...!

Complete by 17 June.

Just for information:

I have create the DB and Tables, but have to remove the following before created the tables: ENGINE=MyISAM DEFAULT CHARSET=latin1. SQL gave a syntax error if I include it. A search on the internet advice one to remove it to complete the SQL query.

Hi there!

I tried to create the tables too, and got the same error as Miekie. I deleted the row too.. ENGINE .. and still had no luck.

I'm pretty darn new to creating tables in MySQL but. I created them manually with number of fields etc etc. I just hope I did this ok.

does anyone know how to handle the auto increment field when adding a record via a form?

If I ignore the cid field then the record is not added to the database. If I make it an manually updated field then the record is added.