How to submit multiple values to the database with a single submit button?

[impin]

i have questions and answers for users to submit.
i have stored questions in questions table. qid, qtext.
answers in answers table. aid,atext,cans (correct ans)

i have displayed the questions and multiple answers from database. like this..

What is capital of India
1.Chennai
2.Bangalore
3.Delhi

What is capital of England
1.London
2.Paris
3.Madrid

now the user can select one answer for each question..

<?php
$sql="SELECT * FROM questions, answers WHERE answers.qid = questions.qid";
$result=mysql_query($sql);
 
while ($row = mysql_fetch_array($result)) {
  if ($row['qtext'] != $lastQuestion) {
    echo "<p>" . $row['qtext'] . "</p><br />";
    $lastQuestion = $row['qtext'];
          }
  echo "<input type='radio' name='".$row['qid']."' value='".$row['aid']."' />".$row['atext'];
 
  }
 
?>
 
 

after answering the question clicks the submit button. how can i store the users answers in the database..??

[Rabbit]

Well, they would fill out the form by selecting their answers. They would then submit their form to another page. That page would use INSERT statements to save their selections to the database.

[impin]

when user clicks the submit button, in the next page how can i retrieve the values to store in the database?
how can i pass the values in the submit button to the next page? there are 3 questions and 3 answers...
for each user i have to to store question id and his ans id in the database? how can i do it.

[Rabbit]

That depends on how you're passing the form. If you're using POST then you use the $_POST array to retrieve the values submitted. If you're using GET, then you use the $_GET array.

[impin]

How can add the php code inside the html form. after the user selecting the answers, he clicks the submit button the page must go to checkresult.php.

<form id="questionBox" method="post" action="checkresult.php" >
<input type="submit" id="submit" name="submit" value="Submit Answer" /></p>
</form>

$sql="SELECT * FROM questions";
$result=mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo "<p>" . $row['qtext'] . "</p>";
$sql2="SELECT * FROM answers where qid=".$row['qid'];
$result2=mysql_query($sql2);
while($row2=mysql_fetch_assoc($result2)){
echo "<input type='radio' name='".$row['qid']."' value='".$row2['cans']."' />".$row2['atext']; }
}

where should i add the submit button in the php code???

[impin]

This is the form.
how to pass the values to the checkresultpage.php and how to retrieve the values in the checkresultpage.php?

echo "<form method='post' id='submit' action='checkresult.php'>";
$sql="SELECT * FROM cquestions";
$result=mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo "<p>" . $row['cqtext'] . "</p>";
$sql2="SELECT * FROM canswers where cqid=".$row['cqid'];
$result2=mysql_query($sql2);
while($row2=mysql_fetch_assoc($result2)){
echo "<input type='radio' name='".$row['cqid']."' value='".$row2['ccans']."' />".$row2['aatext']; }
/*echo "<input type='hidden' name='email' value='email' />";*/
}
echo"<input type='submit' id='submit' name='submit' value='Submit Answers' />";
echo "</form>" ?>

[Rabbit]

You already have your submit button in there so when they click that it will submit their answers. So I don't know why you're asking how to submit it, you already have the code in there to do that.

As for retrieving the values submitted, I answered that already in post #4. Since you're using post to submit your data, you will use the $_POST array to retrieve your data.

[impin]

okay. but i am not sure the above code is working or not? when i click the submit button it goes to checkresult.php, but nothing happens...

checkresults.php

<?php
include("config.php");
include("lock.php");
 
$login_session = $_POST['email'];
/*$aaid =$_POST['aaid'];*/
 
 
$login_session=$_POST['email'];
$marks=0;
$sql="SELECT * FROM cquestions";
$result=mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$qid=$row['cqid'];
$marks+=$_POST['$cqid'];
}
$insert="insert into result(email,marks)values('$email',$marks)";
mysql_query($insert);
?>
 

[Rabbit]

That's because you have a few errors in your php that you have only now shown us for the first time.

1. You have no submitted variable named email because you commented it out in the page prior.

2. You have no variable $cqid, it's $qid.

3. You have no variable $email, it's $login_session.

You really need to double check your variables and be consistent. You use one variable name in one place and then you use a completely different variable name in another.

On a side note, you have left yourself open to injection attacks. At the least you should escape your SQL.

[impin]

these are the tables i used.
Database Tables

CQuestions
CQid, CQText
CAnswers
Aaid, AaText, CQid, CQAns
CResults
Rid, Email, Marks

test.php

<?php 
include("config.php");
session_start();
include("lock.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="style1.css" type="text/css" />
<title>QContest</title>
</head>
<body>
<div id="wrapper">
<div id="intro">
<h1>Take the test </h1>
<p>Each Questions 4 possible answers. Choose the answer you think is correct and click <strong>'Submit Answer'</strong>.
</div><!--intro-->
<div id="quiz">
<h2>Questions : <?php echo $login_session;?> </h2>
<?php
echo "<form method='post' id='submit' action='checkresult.php'>";
$sql="SELECT * FROM cquestions";
$result=mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo "<p>" . $row['cqtext'] . "</p>";
$sql2="SELECT * FROM canswers where cqid=".$row['cqid'];
$result2=mysql_query($sql2);
while($row2=mysql_fetch_assoc($result2)){
echo "<input type='radio' name='".$row['cqid']."' value='".$row2['ccans']."' />".$row2['aatext']; }
/*echo "<input type='hidden' name='email' value='email' />";*/
}
echo"<input type='submit' id='submit' name='submit' value='Submit Answers' />";
echo "</form>" ?>
 

test.php screen shot

checkresult.php

<?php
include("config.php");
include("lock.php");
 
$login_session = $_POST['email'];
/*$aaid =$_POST['aaid'];*/
 
 
$login_session=$_POST['email'];
$marks=0;
$sql="SELECT * FROM cquestions";
$result=mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$qid=$row['cqid'];
$marks+=$_POST['$cqid'];
}
$insert="insert into result(email,marks)values('$email',$marks)";
mysql_query($insert);
?>

how to pass the user's answers to checkresult.php page and store the marks in database?

[Rabbit]

You just repeated what you said before. I've already answered the questions that you just asked.

[impin]

just tell me whether the test.php code is correct or not? is there any mistake in the test.php? please tell what are the mistakes in test.php?

[Rabbit]

test.php looks fine. It's checkresult.php that looks wrong. And I already told you what's wrong with it above.

[impin]

okay. thank you. i fixed it.

[Rabbit]

Glad you solved your problem. Can you post your solution in case someone else runs into the same problem?