📄 prtlist.php
字号:
<html>
<title>分系浏览、打印报名名单</title>
<body bgcolor=#99cccc>
<?
mysql_connect("localhost","jsjdj","jsjdj.2004") or die ("Problem connecting to DataBase");
$query="select xhid,name,grade,class,sfid,depart,dj,bj from cet where depart='$pdepart' order by depart,bj,dj,grade,xhid";
$result=mysql_db_query("jsjdj",$query);
if ($result) {
echo "<h2 align=center>".$pdepart."报名信息如下:</h2><br><p></p>";
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#6699cc>学号</td>
<td align=center bgcolor=#6699cc>姓名</td>
<td align=center bgcolor=#6699cc>班级</td>
<td align=center bgcolor=#6699cc>入学年份</td>
<td align=center bgcolor=#6699cc>学制</td>
<td align=center bgcolor=#6699cc>身份证号</td>
<td align=center bgcolor=#6699cc>级别</td>
</tr>";
$count=0;
while($r=mysql_fetch_array($result))
{
$count=$count+1;
$vxh=$r["xhid"];
$vname=$r["name"];
$vbj=$r["bj"];
$vgrade=$r["grade"];
$vclass=$r["class"];
$vsfid=$r["sfid"];
$vdj=$r["dj"];
$vbj=$r["bj"];
echo "<tr>
<td>$vxh</td>
<td>$vname</td>
<td>$vbj</td>
<td>$vgrade</td>
<td>$vclass</td>
<td>$vsfid</td>
<td>$vdj</td>
</tr>";
}
echo "</table>";
$money=$count*20;
echo "<p align=center>".$pdepart."共报名<font size=6 color=#FF0000>".$count."</font>人,应交费<font size=6 color=#FF0000>￥".$money."</font>元";
}
else
{
echo "<h2 align=center>暂无人报名.</h2>";
}
mysql_free_result($result);
mysql_close();
?> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -