0
<?php
$server="localhost";
$username="root";
$password="root";
$db_name="test";
$db=mysql_connect($server,$username,$password);
mysql_select_db($db_name,$db);

if(isset($_POST['btnsave']))
{


$quesid=$row['question_id'];
$question=$_POST['txtquestion'];

$ans=$_POST['choice'];


$mark=$_POST['mark'];



/*checking no of questions in question table
*/
$countcheck=mysql_query("select count (*) from question");
echo "no of questions in table are".$countcheck;
while($row = mysql_fetch_array($countcheck))
{
for(i=0;i<='$countcheck';i++)

echo $row[i];



}






$ab=mysql_query("SELECT * FROM question ");
while($row = mysql_fetch_array($ab))
{
$answr=trim($row['answers']);
echo $answr;

}




/*comparing values of strings*/


if(strcmp($ans,$answr)==0)
{

$mark=1;


}
else
{
$mark=0;

}





$a=mysql_query("INSERT INTO studans(studquest,answers,mark)
VALUES('$question','$ans','$mark')");


/*$a=mysql_query("INSERT INTO studans(studquest,answers)
VALUES('what is computer','electronic device')");*/



}

if(isset($_POST['btnnext']))
{

}


?>
<?php
$server="localhost";
$username="root";
$password="root";
$db_name="test";
$db=mysql_connect($server,$username,$password);
mysql_select_db($db_name,$db);


$results = mysql_query("SELECT * FROM question");



while($row = mysql_fetch_array($results))
{
$question=$row['questions'];
$choice1=$row['choice1'];
$choice2=$row['choice2'];
$choice3=$row['choice3'];

}

  
  echo $row['questions'] ;
  
  
  
  
  
  
  
  
 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>


<body>
<form name="frmstudquestn" method="post" action="stud_questnans1.php">
<input type="text" name="txtquestion" value="<?php echo $question; ?>"  /><br />
<input type="checkbox" name="choice" value="1" /><?php echo $choice1; ?><br />

<input type="checkbox" name="choice" value="2" /><?php echo $choice2; ?><br />
<input type="checkbox" name="choice" value="3" /><?php echo $choice3; ?><br />

<input type="submit" name="btnsave" value="save" />
<input type="submit" name="btnnext" value="next" />


</form>
</body>
</html>
1
Contributor
3
Replies
4
Views
6 Years
Discussion Span
Last Post by jonasjo
0

I m not able to save mark field nd access data s one by one on button click ie view question one at time on single button click.any help will b appreciable

0

i m not able to save marks nd increment it nd view questions one by one.any help will b aprreciable.thanks in advance

Attachments
<?php
$server="localhost";
$username="root";
$password="root";
$db_name="test";
$db=mysql_connect($server,$username,$password);
mysql_select_db($db_name,$db);


$results = mysql_query("SELECT * FROM question");



while($row = mysql_fetch_array($results))
{
$question=$row['questions'];
$choice1=$row['choice1'];
$choice2=$row['choice2'];
$choice3=$row['choice3'];

}

  
  echo $row['questions'] ;
  
  
  
  
  
  
  
  
 
?>












<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>


<body>
<form name="frmstudquestn" method="post" action="stud_questnans1.php">
<input type="text" name="txtquestion" value="<?php echo $question; ?>"  /><br />
<input type="checkbox" name="choice" value="1" /><?php echo $choice1; ?><br />

<input type="checkbox" name="choice" value="2" /><?php echo $choice2; ?><br />
<input type="checkbox" name="choice" value="3" /><?php echo $choice3; ?><br />

<input type="submit" name="btnsave" value="save" />
<input type="submit" name="btnnext" value="next" />


</form>
</body>
</html>
<?php
$server="localhost";
$username="root";
$password="root";
$db_name="test";
$db=mysql_connect($server,$username,$password);
mysql_select_db($db_name,$db);

if(isset($_POST['btnsave']))
{


$quesid=$row['question_id'];
$question=$_POST['txtquestion'];

$ans=$_POST['choice'];


$mark=$_POST['mark'];



/*checking no of questions in question table
*/
$countcheck=mysql_query("select count (*) from question");
echo "no of questions in table are".$countcheck;
while($row = mysql_fetch_array($countcheck))
{
for(i=0;i<='$countcheck';i++)

echo $row[i];



}






$ab=mysql_query("SELECT * FROM question ");
while($row = mysql_fetch_array($ab))
{
$answr=trim($row['answers']);
echo $answr;

}




/*comparing values of strings*/


if(strcmp($ans,$answr)==0)
{

$mark=1;


}
else
{
$mark=0;

}





$a=mysql_query("INSERT INTO studans(studquest,answers,mark)
VALUES('$question','$ans','$mark')");


/*$a=mysql_query("INSERT INTO studans(studquest,answers)
VALUES('what is computer','electronic device')");*/



}

if(isset($_POST['btnnext']))
{

}


?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
</body>
</html>
0

i m a fresher in php.any help will b appreciable.tanks in advance

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.