<html>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<body>
<div id="formbackground" style="position:absolute; width:100%; height:45%; z-index:-1"><img src="head.png" width="100%" height="45%" /></div>
<br><br><br>
                                    
                                    
                                    
                                    
                                    
                     
<?php
session_start();
echo $_SESSION['Student_Name'];
?>
<?php
header("Content-Type:text/html;charset=gbk");
$link0="链 接 :";
$link00=iconv("UTF-8","gbk",$link0);
echo "<br><br><br><br><br>    $link00";
$link1="综合考评细则";
$link11=iconv("UTF-8","gbk",$link1);
echo "         <a href='/school/studentA/detail/detail1.html' style='text-decoration:none'>$link11</a>";
$link2="德育考评细则";
$link22=iconv("UTF-8","gbk",$link2);
echo "        <a href='/school/studentA/detail/detail2.html' style='text-decoration:none'>$link22</a>";
$link3="额外加分细则";
$link33=iconv("UTF-8","gbk",$link2);
echo "        <a href='/school/studentA/detail/detail3.html' style='text-decoration:none'>$link33</a>";
?>
<div style="margin-left:0px; margin-top:20px; width:30px; height:30px;"><a href="/school/studentA/apply/apply.php"><img src="1.png"></a></div>
<div style="margin-left:0px; margin-top:75px; width:30px; height:30px;"><a href="/school/studentA/check/check.php"><img src="2.png"></a></div>
<div style="margin-left:0px; margin-top:70px; width:30px; height:30px;"><a href="/school/studentA/moral/moral.php"><img src="3.png"></a></div>
<div style="margin-left:0px; margin-top:70px; width:30px; height:30px;"><a href="/school/studentA/sum/sum.php"><img src="4.png"></a></div>
<div style="margin-left:0px; margin-top:70px; width:30px; height:30px;"><img src="5.png"></a></div>
<table style="margin-left:304px;margin-top:-480px;" border=1 bordercolor="#6E6E6E" cellpadding="10" frame="box" rules="all">
<br><br>
<?php
header("Content-Type: text/html;charset=gbk");
$con=mysql_connect("localhost","root","9277");
mysql_select_db("School",$con);
mysql_query("set names 'gbk'");
$login=$_SESSION['username'];
$i=0;
mysql_query("UPDATE `Sum` SET `Genera`= `Grade`+`Moral`+`Add`");
$result=mysql_query("select * from Exam left join Student on Exam.Class=Student.Class where Student.Username='$login'");//mysql_query 查询数据库的函数
$head=mysql_query("select * from Major left join Student on Major.Class=Student.Class where Student.Username='$login'");//mysql_query 查询数据库的函数,查询数据库的major获取第一行的内
if($heads=mysql_fetch_array($head)){
echo "<tr align=\"center\" bgcolor=\"#DCDCDC\">
<td>Class</td>
<td>Name</td>
<td>ID</td>
<td>$heads[1]</td><td>$heads[2]</td><td>$heads[3]</td><td>$heads[4]</td><td>$heads[5]</td>
<td>$heads[6]</td><td>$heads[7]</td><td>$heads[8]</td><td>$heads[9]</td><td>$heads[10]</td><td style=\"width:80px;\">$heads[11]</td>
<td style=\"width:100px;\">$heads[12]</td><td style=\"width:70px;\">$heads[13]</td ><td style=\"width:60px;\">$heads[14]</td>
</tr>";
}
while($row=mysql_fetch_array($result)){
$i=$i+1;
if($i%2==1){
echo "<tr align=\"center\">
<td>$row[0]</td><td>$row[1]</td><td>$row[2]</td>
<td>$row[3]</td><td>$row[4]</td><td>$row[5]</td><td>$row[6]</td><td>$row[7]</td>
<td>$row[8]</td><td>$row[9]</td><td>$row[10]</td><td>$row[11]</td><td>$row[12]</td>
<td>$row[13]</td><td>$row[14]</td><td>$row[15]</td><td>$row[16]</td>
</tr>";
$sum1="UPDATE `Sum` SET `Moral`=(select Sum from Moralfromteacher where ID=$row[2])+(select Sum from Moralfromstudent where ID=$row[2]) where ID=$row[2]";
$add1="UPDATE `Sum` SET `Add`=(SELECT `add` FROM `Add` WHERE ID=$row[2]) where ID=$row[2]";
mysql_query($sum1);
mysql_query($add1);
}else{
echo "<tr bgcolor=\"#DCDCDC\" align=\"center\">
<td>$row[0]</td><td>$row[1]</td><td>$row[2]</td>
<td>$row[3]</td><td>$row[4]</td><td>$row[5]</td><td>$row[6]</td><td>$row[7]</td>
<td>$row[8]</td><td>$row[9]</td><td>$row[10]</td><td>$row[11]</td><td>$row[12]</td>
<td>$row[13]</td><td>$row[14]</td><td>$row[15]</td><td>$row[16]</td>
</tr>";
$sum2="UPDATE `Sum` SET `Moral`=(select Sum from Moralfromteacher where ID=$row[2])+(select Sum from Moralfromstudent where ID=$row[2]) where ID=$row[2]";
$add2="UPDATE `Sum` SET `Add`=(SELECT `add` FROM `Add` WHERE ID=$row[2]) where ID=$row[2]";
mysql_query($sum2);
mysql_query($add2);
}
}
?>
</table>
</body>
</html>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<body>
<div id="formbackground" style="position:absolute; width:100%; height:45%; z-index:-1"><img src="head.png" width="100%" height="45%" /></div>
<br><br><br>
                                    
                                    
                                    
                                    
                                    
                     
<?php
session_start();
echo $_SESSION['Student_Name'];
?>
<?php
header("Content-Type:text/html;charset=gbk");
$link0="链 接 :";
$link00=iconv("UTF-8","gbk",$link0);
echo "<br><br><br><br><br>    $link00";
$link1="综合考评细则";
$link11=iconv("UTF-8","gbk",$link1);
echo "         <a href='/school/studentA/detail/detail1.html' style='text-decoration:none'>$link11</a>";
$link2="德育考评细则";
$link22=iconv("UTF-8","gbk",$link2);
echo "        <a href='/school/studentA/detail/detail2.html' style='text-decoration:none'>$link22</a>";
$link3="额外加分细则";
$link33=iconv("UTF-8","gbk",$link2);
echo "        <a href='/school/studentA/detail/detail3.html' style='text-decoration:none'>$link33</a>";
?>
<div style="margin-left:0px; margin-top:20px; width:30px; height:30px;"><a href="/school/studentA/apply/apply.php"><img src="1.png"></a></div>
<div style="margin-left:0px; margin-top:75px; width:30px; height:30px;"><a href="/school/studentA/check/check.php"><img src="2.png"></a></div>
<div style="margin-left:0px; margin-top:70px; width:30px; height:30px;"><a href="/school/studentA/moral/moral.php"><img src="3.png"></a></div>
<div style="margin-left:0px; margin-top:70px; width:30px; height:30px;"><a href="/school/studentA/sum/sum.php"><img src="4.png"></a></div>
<div style="margin-left:0px; margin-top:70px; width:30px; height:30px;"><img src="5.png"></a></div>
<table style="margin-left:304px;margin-top:-480px;" border=1 bordercolor="#6E6E6E" cellpadding="10" frame="box" rules="all">
<br><br>
<?php
header("Content-Type: text/html;charset=gbk");
$con=mysql_connect("localhost","root","9277");
mysql_select_db("School",$con);
mysql_query("set names 'gbk'");
$login=$_SESSION['username'];
$i=0;
mysql_query("UPDATE `Sum` SET `Genera`= `Grade`+`Moral`+`Add`");
$result=mysql_query("select * from Exam left join Student on Exam.Class=Student.Class where Student.Username='$login'");//mysql_query 查询数据库的函数
$head=mysql_query("select * from Major left join Student on Major.Class=Student.Class where Student.Username='$login'");//mysql_query 查询数据库的函数,查询数据库的major获取第一行的内
if($heads=mysql_fetch_array($head)){
echo "<tr align=\"center\" bgcolor=\"#DCDCDC\">
<td>Class</td>
<td>Name</td>
<td>ID</td>
<td>$heads[1]</td><td>$heads[2]</td><td>$heads[3]</td><td>$heads[4]</td><td>$heads[5]</td>
<td>$heads[6]</td><td>$heads[7]</td><td>$heads[8]</td><td>$heads[9]</td><td>$heads[10]</td><td style=\"width:80px;\">$heads[11]</td>
<td style=\"width:100px;\">$heads[12]</td><td style=\"width:70px;\">$heads[13]</td ><td style=\"width:60px;\">$heads[14]</td>
</tr>";
}
while($row=mysql_fetch_array($result)){
$i=$i+1;
if($i%2==1){
echo "<tr align=\"center\">
<td>$row[0]</td><td>$row[1]</td><td>$row[2]</td>
<td>$row[3]</td><td>$row[4]</td><td>$row[5]</td><td>$row[6]</td><td>$row[7]</td>
<td>$row[8]</td><td>$row[9]</td><td>$row[10]</td><td>$row[11]</td><td>$row[12]</td>
<td>$row[13]</td><td>$row[14]</td><td>$row[15]</td><td>$row[16]</td>
</tr>";
$sum1="UPDATE `Sum` SET `Moral`=(select Sum from Moralfromteacher where ID=$row[2])+(select Sum from Moralfromstudent where ID=$row[2]) where ID=$row[2]";
$add1="UPDATE `Sum` SET `Add`=(SELECT `add` FROM `Add` WHERE ID=$row[2]) where ID=$row[2]";
mysql_query($sum1);
mysql_query($add1);
}else{
echo "<tr bgcolor=\"#DCDCDC\" align=\"center\">
<td>$row[0]</td><td>$row[1]</td><td>$row[2]</td>
<td>$row[3]</td><td>$row[4]</td><td>$row[5]</td><td>$row[6]</td><td>$row[7]</td>
<td>$row[8]</td><td>$row[9]</td><td>$row[10]</td><td>$row[11]</td><td>$row[12]</td>
<td>$row[13]</td><td>$row[14]</td><td>$row[15]</td><td>$row[16]</td>
</tr>";
$sum2="UPDATE `Sum` SET `Moral`=(select Sum from Moralfromteacher where ID=$row[2])+(select Sum from Moralfromstudent where ID=$row[2]) where ID=$row[2]";
$add2="UPDATE `Sum` SET `Add`=(SELECT `add` FROM `Add` WHERE ID=$row[2]) where ID=$row[2]";
mysql_query($sum2);
mysql_query($add2);
}
}
?>
</table>
</body>
</html>