Code: Select all
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="server2go"; // Database name
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$quesid= $_POST['quesid'];
$question= $_POST['question'];
$answer= $_POST['answer'];
$ranswer = $_POST['ranswer'];
$ranswer1= $_POST['ranswer1'];
$ranswer2= $_POST['ranswer2'];
$qzid= $_POST['qzid'];
$next_id=$_REQUEST['next_id'];
if(($quesid=="")||($quesid==0))
{
$quesid=1;
}
else
{
$quesid=$quesid+1;
}
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$query = "INSERT INTO questiona (quesid,question,answer,ranswer,ranswer1,ranswer2,qzid)
VALUES
('$quesid','$question','$answer','$ranswer','$ranswer1','$ranswer2','$qzid')";
mysql_query($query) or die('Error1, insert query failed');
$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error2, insert query failed');
$result = @mysql_query($query);
if ($result)
{
header("location: addquizquestion.php?quesid='$quesid'");
exit();
}
?>This page has the fields ..... that allow the user to enter in the data
Code: Select all
<table width="400" border="0" cellspacing="1" cellpadding="2">
<form method=post name=form action="createquizcheck1.php?quesid='.$quesid.'" onSubmit="return validate_form ( );">
<input type=hidden name=todo value=post>
<tr>
<td width="100">Question</td>
<td><input name="question" type="text" id="question"></td>
</tr>
<tr>
<td width="100">Right answer</td>
<td><input name="answer" type="text" id="answer"></td>
</tr>
<tr>
<td width="100">Wrong Answer</td>
<td><input name="ranswer" type="text" id="ranswer"></td>
</tr>
<tr>
<td width="100">Wrong Answer</td>
<td><input name="ranswer1" type="text" id="ranswer1"></td>
</tr>
<tr>
<td width="100">Wrong Answer</td>
<td><input name="ranswer2" type="text" id="ranswer2"></td>
</tr>
</select>
</td>
</tr>
<tr>
<td width="100"> </td>
<td><input name="add" type="submit" id="add" value="add quiz"></td>