php表单显示

<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>
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
<?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>&nbsp&nbsp&nbsp&nbsp$link00";
  $link1="综合考评细则";
  $link11=iconv("UTF-8","gbk",$link1);
  echo "&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<a href='/school/studentA/detail/detail1.html' style='text-decoration:none'>$link11</a>";
  $link2="德育考评细则";
  $link22=iconv("UTF-8","gbk",$link2);
  echo "&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<a href='/school/studentA/detail/detail2.html' style='text-decoration:none'>$link22</a>";
  $link3="额外加分细则";
  $link33=iconv("UTF-8","gbk",$link2);
  echo "&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<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>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值