Sourcecode : here

This project is also a part of my COP (Computer Oriented Project). This project aims to have a simple web interface which will authenticate the user then a number of multipe choice questions appears on the page with the "Next" and "Finish" option. Once the person has given the test his account will be locked and he will not be able to appear test again. And on the very first page (/index.php) you can have a new account registeration . And also this can have an admin view , on which an admin (with attrib=2) can be able to view the status of this. In the admin page he can see the status (if the student has finished the exam or not) and the score (if finished) along with the user-name of the student. Again I am telling that this is one of my first codes so this may not be helpful in learning , but look through it to know how it works .(P.S : The design is very simple and not attractive). As this is very simple sql structure you can make a database named "objective" and import this code into that using phpmyadmin.If you need information about the installation of the servers please refer to my first post .

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `objective`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE IF NOT EXISTS `accounts` (
  `username` varchar(64) NOT NULL,
  `password` varchar(64) NOT NULL,
  `attrib` int(11) NOT NULL,
  `answered` varchar(1) NOT NULL,
  `correct` int(11) NOT NULL,
  `locked` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `questions`
--

CREATE TABLE IF NOT EXISTS `questions` (
  `auto_ID` int(10) unsigned NOT NULL auto_increment,
  `ques` varchar(64) NOT NULL,
  `opt_1` varchar(64) NOT NULL,
  `opt_2` varchar(64) NOT NULL,
  `opt_3` varchar(64) NOT NULL,
  `opt_4` varchar(64) NOT NULL,
  `opt_ans` int(11) NOT NULL,
  PRIMARY KEY  (`auto_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

Also me and my friends are planning to do this from scratch using PHP .We are thinking of having a server with admin module and we will be having specific time for each exam. Also i am planning to design it well so that it does not look boring ( :P ) .This will be using AJAX .So again a new area to learn . We will try to make it interactive . Also we are planning to do have a page for the admin , in which he can upload the question (may be in .csv or .sql format not yet decided). Once it is ready i will be posting about that .

Comments awaited :)