Jump to content

Help Help!


Terza22

Recommended Posts

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

UCScreenshot20170526033554.thumb.jpg.70c09b864ba26c18b8a09ceb6415c1d0.jpg


<?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">&nbsp;</td>
</tr>
 </table>
 </div>
 </div>

I WANT TO KNOW MY MISTAKE THE CODE

Edited by Terza22
clearification
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...