Terza22 Posted May 25, 2017 Share Posted May 25, 2017 (edited) Guys I'm trying to display the result from question page to the user then put this result in result table database and I'm getting error like undefined grade. see it below in the pic help help <?php if (!isset($_SESSION)) { session_start(); } IF(isset($_SESSION['username'])) ECHO "WELL COME ".$_SESSION['username']."<BR>"; else IF(isset($_SESSION['Name'])) if(isset($_POST['button'])) { $correct=0; $wrong=0; $sum=0; $grade=''; $total_q=@$_POST['total']; for($i=1;$i<=$total_q;$i++) { $con = mysql_connect("localhost","root"); mysql_select_db("oes", $con); $sql = "SELECT * from question_page where question='".@$_POST['q'.$i]."' and Answer='".@$_POST['ans'.$i]."'";// where schedule.status='active' $result = mysql_query($sql,$con); $result1 = mysql_fetch_array($result); if(mysql_num_rows($result)) $correct++; $wrong=$_POST['total']-$correct; $sum=($correct*10)/$_POST['total']; //echo "question of page:".@$_POST['q'.$i]." <br>answer of user ".@$_POST['ans'.$i]."<br>"; //echo "question of db:".$result1['question']." <br>answer of db ".$result1['Answer']."<br><br>"; if($sum>=9 && $sum<=10) { $grade="A+"; } else if($sum>=8.5 && $sum<9) { $grade="A"; } else if($sum>=8 && $sum<8.5) { $grade="A-"; } else if($sum>=7.5 && $sum<8) { $grade="B+"; } else if($sum>=7 && $sum<7.5) { $grade="B"; } else if($sum>=6.5 && $sum<7) { $grade="B-"; } else if($sum>=6 && $sum<6.5) { $grade="C+"; } else if($sum>=5 && $sum<6) { $grade="C"; } else if($sum>=4.5 && $sum<5) { $grade="C-"; } else if($sum>=4 && $sum<4.5) { $grade="D"; } else if($sum>=3.5 && $sum<4) { $grade="Fx"; } else if($sum>=0 && $sum<3.5) { $grade="F"; } } echo "total number of question ".$_POST['total']."<br>"; echo "total number of correct answer".$correct."<br>"; echo "total number of wrong answer".$wrong."<br>"; echo "total number of Marks:".$sum."<br>"; echo "your grade is:".$grade."<br>"; } else { header('location:Exam.php'); } ?> <script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script> <link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css"> <style type="text/css"> </style> <div id="right"> <?php $cnct=mysql_connect("localhost","root","")or die("not connected"); $qry=mysql_select_db("oes") or die("not connected"); $crsnm=mysql_query("select course_name from schedule where schedule_id='".$_GET['Id']."'"); $data=mysql_fetch_array($crsnm); $a=$_SESSION['ID']; $b=$_SESSION['Name']; $c=$_POST['total']; $g=$_POST['grade']; $con=mysql_connect("localhost","root","")or die("not connected"); $query=mysql_select_db("oes") or die("note selected"); $res="insert into result values('$a','$b','$correct','$wrong','$sum','$c', '$g' ,'yes','".$data['course_name']."')"; $sql=mysql_query($res) or die(mysql_error()); if(!$sql) { echo"not inserted ".mysql_error()."<br>"; } else { echo"inserted"."<br>"."<br>"; } ?> <?php $a=$_SESSION['ID']; $b=$_SESSION['Name']; $c=$_POST['total']; $d=$_POST['grade']; $con=mysql_connect("localhost","root","")or die("not connected"); $query=mysql_select_db("oes") or die("note selected"); $sql=mysql_query("insert into result values('$a','$b','$correct','$wrong','$sum','$c','$d')") or die(mysql_error()); if(!$sql) { echo"not inserted ".mysql_error()."<br>"; } else { echo"inserted"."<br>"."<br>"; } mysql_close($con); ?> <br/--> <div align="center"> </div> <td bgcolor="#c24122"> </td> </tr> </table> </div> </div> I WANT TO KNOW MY MISTAKE THE CODE Edited May 25, 2017 by Terza22 clearification Link to comment Share on other sites More sharing options...
justsomeguy Posted May 25, 2017 Share Posted May 25, 2017 Please do not create duplicate topics. Link to comment Share on other sites More sharing options...
Recommended Posts