php - Program not displaying correct data -
i program post highest scoring student in corresponding year, meaning in place "topper 2012: " should post student highest score in year only, along students scores rest of years(does not matter if did not highest score in other years, should based on specific year). in last row "overall topper: ", should display best student overall.
note: post "topper 2011: " section, not based on highest score. not posting rest of years after 2011.
code:
<body> <form> <?php $username = "amar"; $password = "amar"; $hostname = "localhost"; $database = "study"; $set = array('2011' => 0, '2012' => 0, '2013' => 0, '2014' => 0, 'final' => 0, 'final_grade' => 0); $mysqli = new mysqli($hostname, $username, $password, $database) or die("unable connect mysql"); $query = "select name, year_1, year_2, year_3, year_4, final, final_grade toppers"; $result = mysqli_query($mysqli, $query); if (!$result) { $message = 'invalid query: ' . mysqli_error() . "\n"; $message .= 'whole query: ' . $query; die($message); } echo "<table border=1 cellpadding=5>"; echo "<tr><td>student name</td>"; echo "<td>2011</td>"; echo "<td>2012</td>"; echo "<td>2013</td>"; echo "<td>2014</td>"; echo "<td>final exam</td>"; echo "<td>grade</td></tr>"; while ($row = mysqli_fetch_array($result)) { $grader = $_post['result']; $x = $row['year_1'] + $row['year_2'] + $row['year_3'] + $row['year_4'] + $row['final']; $grader = $x / 5; if ($grader <= 100 , $grader >= 89) { $grade = "a"; } elseif ($grader <= 90 , $grader >= 79) { $grade = "b"; } elseif ($grader <= 80 , $grader >= 69) { $grade = "c"; } elseif ($grader <= 70 , $grader >= 59) { $grade = "d"; } else { $grade = "f"; } if ($row['final'] > $set['2011']) { $year2011 = $row; $set['2011'] = $row['final']; } if ($row['final'] < $set['2012']) { $year2011 = $row; $set['2011'] = $row['final']; } if ($row['final'] < $set['2013']) { $year2011 = $row; $set['2011'] = $row['final']; } if ($row['final'] < $set['2014']) { $year2011 = $row; $set['2011'] = $row['final']; } if ($row['final'] < $set['final']) { $finalscore = $row; $set['final'] = $row['final']; } if ($row['final_grade'] < $set['final_grade']) { $overall = $row; $set['final_grade'] = $row['final_grade']; } echo "<tr><td>"; echo "$row[name]"; echo "</td><td>"; echo "$row[year_1]"; echo "</td><td>"; echo "$row[year_2]"; echo "</td><td>"; echo "$row[year_3]"; echo "</td><td>"; echo "$row[year_4]"; echo "</td><td>"; echo "$row[final]"; echo "</td><td>"; echo "$grade"; echo "</td></tr>"; } echo "<tr><td colspan=7>topper 2011: </td></tr>"; echo "<tr><td> $year2011[name] </td>"; echo "<td>"; echo $year2011['year_1']; echo "</td><td>"; echo $year2011['year_2']; echo "</td><td>"; echo $year2011['year_3']; echo "</td><td>"; echo $year2011['year_4']; echo "</td><td>"; echo $year2011['final']; echo "</td><td>"; echo "$grade"; echo "</td></tr>"; echo "<br>"; echo "<tr><td colspan=7>topper 2012: </td></tr>"; echo "<tr><td>"; echo $year2012['name']; echo "</td><td>"; echo $year2012['year_1']; echo "</td><td>"; echo $year2012['year_2']; echo "</td><td>"; echo $year2012['year_3']; echo "</td><td>"; echo $year2012['year_4']; echo "</td><td>"; echo $year2012['final']; echo "</td><td>"; echo "$grade"; echo "</td></tr>"; echo "<br>"; echo "<tr><td colspan=7>topper 2013: </td></tr>"; echo "<tr><td>"; echo $year2013['name']; echo "</td><td>"; echo $year2013['year_1']; echo "</td><td>"; echo $year2013['year_2']; echo "</td><td>"; echo $year2013['year_3']; echo "</td><td>"; echo $year2013['year_4']; echo "</td><td>"; echo $year2013['final']; echo "</td><td>"; echo "$grade"; echo "</td></tr>"; echo "<br>"; echo "<tr><td colspan=7>topper 2014: </td></tr>"; echo "<tr><td>"; echo $year2014['name']; echo "</td><td>"; echo $year2014['year_1']; echo "</td><td>"; echo $year2014['year_2']; echo "</td><td>"; echo $year2014['year_3']; echo "</td><td>"; echo $year2014['year_4']; echo "</td><td>"; echo $year2014['final']; echo "</td><td>"; echo "$grade"; echo "</td></tr>"; echo "<tr><td colspan=7>overall topper: </td></tr>"; echo "<tr><td>"; echo $overall['name']; echo "</td><td>"; echo $overall['year_1']; echo "</td><td>"; echo $overall['year_2']; echo "</td><td>"; echo $overall['year_3']; echo "</td><td>"; echo $overall['year_4']; echo "</td><td>"; echo $overall['final']; echo "</td><td>"; echo "$grade"; echo "</td></tr>"; echo "</table>";
Comments
Post a Comment