21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
for($i=1;$i<$pages;$i++){
if($page == $i) echo $i;
else {
$stus = empty($page)?$StuNumber: $StuNu;
$stunas = empty($page)?$StuName: $StuNa;
$pros = empty($page)?$Project: $Pro;
?>
<a href="StuSearch.php?page=<?php echo "$i"; ?>&StuNu=<?php echo $stus;?>&StuNa=<?php echo $stunas;?>&Pro=<?php echo $pros;?>" ><?php echo $i?></a>
<?php
}
}
if($page<$pages){
?>
<a href="StuSearch.php?page=<?php echo ($page+1); ?>&StuNu=<?php echo $stus;?>&StuNa=<?php echo $stunas;?>&Pro=<?php echo $pros;?>"><?php echo $i;?>下一页</a>
<?php
}
echo "共(".$pages.")页</div>";
?>
<?
$pagesize=5;
if(empty($_POST['page'])){
$StuNu=$StuNumber;
$StuNa=$StuName;
$Pro=$Project;
$sql=getSql($StuNu,$StuNa,$Pro);
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$num=mysql_num_rows($result);
$pages=ceil($num/$pagesize);
$page=1;
}
else{
$StuNu=$_POST["StuNumber"];
$StuNa=$_PST["StuName"];
$Pro=$_POST["Project"];
$sql=getSql($StuNu,$StuNa,$Pro);
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$num=mysql_num_rows($result);
$page=$_POST["page"];
$pages=ceil($num/$pagesize);
if($page<1) $page=1;
if($page>=$pages) $page=$pages;
}
$exec=$sql."limit".($page-1)*$pagesize.",".$pagesize;
$result=mysql_query($exec);
if(@mysql_num_rows($result)==0)
{
echo "<scritp type=\"javascript\"> alert('无此人记录!');location.href='StuSearch.php';</script>";
}
else
{
echo <<<HTML
<div align="center" class="STYLE3"><font color=#0000FF>学生信息查询结果</font></div>
<table width=860 border=1 align="center">
<tr><td class="STYLE4" bgcolor=#CCCCCC>学号</td>
"<tr><td class="STYLE4" bgcolor=#CCCCCC>姓名</td>
"<tr><td class="STYLE4" bgcolor=#CCCCCC>专业名</td>
"<tr><td class="STYLE4" bgcolor=#CCCCCC>性别</td>
"<tr><td class="STYLE4" bgcolor=#CCCCCC>出生日期</td>
"<tr><td class="STYLE4" bgcolor=#CCCCCC>总学分</td>
"<tr><td class="STYLE4" bgcolor=#CCCCCC>照片</td>
"<tr><td class="STYLE4" bgcolor=#CCCCCC>备注</td></tr>
HTML;
}
?>