<?php
/*function convertgrade($grade)
{
if($grade >=95)
$finalgrade='A+';
elseif ($grade >=90)
$finalgrade='A' ;
elseif($grade >=85)
$finalgrade='B+';
elseif($grade >=80)
$finalgrade='B' ;
elseif ($grade >=75)
$finalgrade='C+';
elseif ($grade >=70)
$finalgrade='C';
elseif($grade >=65)
$finalgrade='D+';
elseif($grade >=60)
$finalgrade='D' ;
else $finalgrade='F';
return $finalgrade;
}*/
extract ($_POST);
$query[0]="UPDATE studentgrade SET Grade =$s1 WHERE ID=101";
$query[1]="UPDATE studentgrade SET Grade =$s2 WHERE ID=102";
$query[2]="UPDATE studentgrade SET Grade =$s3 WHERE ID=103";
$query[3]="UPDATE studentgrade SET Grade =$s4 WHERE ID=104";
$query[4]="UPDATE studentgrade SET Grade =$s5 WHERE ID=105"
;$query[5]="UPDATE studentgrade SET Grade =$s6 WHERE ID=106";
$query[6]="UPDATE studentgrade SET Grade =$s7 WHERE ID=107";
$query[7]="UPDATE studentgrade SET Grade =$s8 WHERE ID=108";
$query[8]="UPDATE studentgrade SET Grade =$s9 WHERE ID=109";
$query[9]="UPDATE studentgrade SET Grade =$st WHERE ID=110";
$query[10]="UPDATE studentgrade SET Grade =$sa WHERE ID=111";
$query[11]="UPDATE studentgrade SET Grade =$sb WHERE ID=112";
$query[12]="UPDATE studentgrade SET Grade =$sc WHERE ID=113";
$query[13]="UPDATE studentgrade SET Grade =$sd WHERE ID=114";
$query[14]="UPDATE studentgrade SET Grade =$se WHERE ID=115";
$query[15]="UPDATE studentgrade SET Finalgrade =convertgrade($s1) WHERE ID=101";
$query[16]="UPDATE studentgrade SET Finalgrade =convertgrade($s2) WHERE ID=102";
$query[17]="UPDATE studentgrade SET Finalgrade=convertgrade($s3) WHERE ID=103";
$query[18]="UPDATE studentgrade SET Finalgrade=convertgrade($s4) WHERE ID=104";
$query[19]="UPDATE studentgrade SET Finalgrade=convertgrade($s5) WHERE ID=105"
;$query[20]="UPDATE studentgrade SET Finalgrade=convertgrade($s6) WHERE ID=106";
$query[21]="UPDATE studentgrade SET Finalgrade=convertgrade($s7) WHERE ID=107";
$query[22]="UPDATE studentgrade SET Finalgrade=convertgrade($s8) WHERE ID=108";
$query[23]="UPDATE studentgrade SET Finalgrade=convertgrade($s9) WHERE ID=109";
$query[24]="UPDATE studentgrade SET Finalgrade=convertgrade($st) WHERE ID=110";
$query[25]="UPDATE studentgrade SET Finalgrade=convertgrade($sa) WHERE ID=111";
$query[26]="UPDATE studentgrade SET Finalgrade=convertgrade($sb) WHERE ID=112";
$query[27]="UPDATE studentgrade SET Finalgrade=convertgrade($sc) WHERE ID=113";
$query[28]="UPDATE studentgrade SET Finalgrade=convertgrade($sd) WHERE ID=114";
$query[29]="UPDATE studentgrade SET Finalgrade=convertgrade($se) WHERE ID=115";
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if(!$database=mysql_select_db("ACCT",$con))
die("could not open ACCT database");
for($i=0;$i<count($query); $i++)
{
if(!($result=mysql_query($query[$i],$con)))
{
print("could not execute query! <br />");
die(mysql_error() );
}
}
mysql_close($con);
?>
everything in yellow in the code block above WILL NOT run as it is inside a comment block.
remove the /* and the */
Your code is also prone to sql injection, hopefully you won’t use it somewhere online without cleaning your input first.