Help with Quiz Application

[eluser]raindahl[/eluser]
Hi there I am looking for some help for my Quiz Application that I have begun creating for a University project

here


It basically is a CMS for creating Quiz content I have everything working such as updating the Database questions etc

But my problem is that when I create a new user and they login it still shows the same Data for every new user I create how would I sort this so each user has their own seperate questions and answers ?

My Database tables are this :



CREATE TABLE IF NOT EXISTS `user` (
`id` int(50) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`email` varchar(100) NOT NULL,
`password` varchar(255) NOT NULL,
'quiz_no' int(3) NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

The user table is for users to create their accounts etc

CREATE TABLE IF NOT EXISTS `quiz` (
`no` int(3) NOT NULL AUTO_INCREMENT,
`writing` varchar(100) NOT NULL,
`opt1` varchar(50) NOT NULL,
`opt2` varchar(50) NOT NULL,
`opt3` varchar(50) NOT NULL,
`opt4` varchar(50) NOT NULL,
`answer` varchar(4) NOT NULL,
PRIMARY KEY (`no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

quiz is for each individual question

CREATE TABLE IF NOT EXISTS `student` (
`id_user` int(3) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`id_question_type` int(3) NOT NULL,
`grade` int(3) NOT NULL,
`date_test` varchar(40) NOT NULL,
`minutes` int(10) NOT NULL,
`seconds` int(10) NOT NULL,
PRIMARY KEY (`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=287 ;

student is for the people taking the quizzes

I was then told to have a connecting table which is :

CREATE TABLE IF NOT EXISTS 'pairs'
('id' int(50) NOT NULL AUTO_INCREMENT, 'user_id' int(50), 'quiz_no' int(3),PRIMARY KEY ('id'))
ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

I now have added the SQL code that the guys below have mentioned but I am not sure which PHP code to put in to get it all connected? It will be for these models :


Here is the Main_Model :


[code] class Main_model extends CI_Model
{
function __construct()
{
parent::__construct();
}



function entry_student($xname,)
{
$query="insert into student (name,) values ('$xname','$xgrade_id_max')";
$run_query=$this->db->query("$query");
return $run_query;
}

function show_quiz()
{
$query="select * from quiz order by no";
$outcome=$this->db->query($query);
return $outcome;
}

function record_entry_quiz()
{
$make_quiz="Select * from quiz";
$outcome=$this->db->query("$make_quiz");
$jml_quiz=$outcome->num_rows();

if ($jml_quiz==0)
{ $jml_quizs=1; }
else
{ $jml_quizs=$jml_quiz+1; }

$xquiz=$this->input->post('vquiz');
$xansweran1=$this->input->post('vansweran1');
$xansweran2=$this->input->post('vansweran2');
$xansweran3=$this->input->post('vansweran3');
$xansweran4=$this->input->post('vansweran4');
$xradio=$this->input->post('vradio');
$query="insert into quiz (no,writing,opt1,opt2,opt3,opt4,answer) values ('$jml_quizs','$xquiz','$xansweran1','$xansweran2','$xansweran3','$xansweran4','$xradio')";
$outcome_query=$this->db->query("$query");
return $outcome_query;
}

function edit_quiz()
{
$pressed=$this->uri->segment(3);
$xquiz=$this->input->post('vquiz');
$xansweran1=$this->input->post('vansweran1');
$xansweran2=$this->input->post('vansweran2');
$xansweran3=$this->input->post('vansweran3');
$xansweran4=$this->input->post('vansweran4');
$xradio=$this->input->post('vradio');
$query="update quiz set writing='$xquiz',opt1='$xansweran1',opt2='$xansweran2',opt3='$xansweran3',opt4='$xansweran4',
answer='$xradio' where no='$pressed'";
$outcome_query=$this->db->query("$query");
return $outcome_query;
}

function delete_quiz()
{
$pressed=$this->uri->segment(3);
$scriptdel="delete from quiz where no='$pressed' ";
$outcome_edit=$this->db->query("$scriptdel");
return $outcome_edit;
}

function view_data()
{
$pressed=$this->uri->segment(3);
$scriptview="select * from quiz where no='$pressed'";
$outcome=$this->db->query("$scriptview");
return $outcome;
}

function edit_data()
{
$pressed=$this->uri->segment(3);
$scriptedit="select * from quiz where no='$pressed'";
$outcome=$this->db->query("$scriptedit");
return $outcome;
}
This is the only piece of the application I have to complete and I am a little bit of a noob but if someone could help with this bit it would be much appreciated I can post other bits of code up but I figured that these bits would be where i make changes?

Thanks

[eluser]TheFuzzy0ne[/eluser]
When you add a quiz, it if it belongs to a specific user, you need to insert that user ID into the quiz table when the quizes are added. When you pull the quizes out of the database, you only pull quizes depending on the ID of the currently logged in user.