<?phpinclude_once 'stuService.class.php';session_start();$name = $_SESSION['student_name'];if($name == ""){header("Location: stu_login.php?error=1");exit();}$pagesize = 20;$pagenow = 1;$pagecount = 0;$service = new stuservice();$pagecount = $service->getpagecount($pagesize);if(!empty($_GET['pagenow'])){$pagenow=$_GET['pagenow'];}$stulist = $service->getstulist($pagesize, $pagenow);?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ""><html xmlns=""><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>学生成绩管理系统</title></head><body background="pic/bg.gif"> <form action="studentlist.php" method="get"><table width="767" height="644" border="0" align="center"><tr><td height="228" colspan="5" background="pic/top.gif" /></tr><tr><td height="22" colspan="5" background="pic/in_01.gif" /></tr><tr><td height="28" background="pic/in_20.gif" /><td background="pic/in_20.gif">学生ID号</td><td background="pic/in_20.gif">学生姓名</td><td background="pic/in_20.gif">学生密码</td><td background="pic/in_20.gif"></td></tr><?phpfor($i = 0; $i < count($stulist); ++$i){$row=$stulist[$i]; //取出第i行数据,显示出来$passwd = md5($row['stu_password']); //学生进来不能看到密码?><tr><td background="pic/in_20.gif"></td><td background="pic/in_20.gif"><?php echo stripslashes($row['stu_id']);?></td><td background="pic/in_20.gif"><?php echo stripslashes($row['stu_name']);?></td><td background="pic/in_20.gif"><?php echo stripslashes($passwd); ?></td><td background="pic/in_20.gif"></td></tr><?php}echo "<tr>";echo "<td background='pic/in_20.gif' />";echo "<td background='pic/in_20.gif'>";//显示上一页和下一页if($pagenow > 1){$prePage=$pagenow – 1;echo "<a href='studentlist.php?pagenow=$prePage'>上一页</a> ";echo "<a href='studentlist.php?pagenow=$prePage'>《《</a> ";}echo "</td>";echo "<td background='pic/in_20.gif'>";//中间打印10页选择for($i=$pagenow; $i < $pagenow+10; ++$i){if($i <= $pagecount){echo "<a href='studentlist.php?pagenow=$i'>$i</a> ";}}echo "</td>";echo "<td background='pic/in_20.gif'>";//下一页if($pagenow < $pagecount){$nextPage=$pagenow+1;echo "<a href='studentlist.php?pagenow=$nextPage'>》》</a> ";echo "<a href='studentlist.php?pagenow=$nextPage'>下一页</a> ";}echo "</td>";echo "<td background='pic/in_20.gif'>";echo "当前页$pagenow/共{$pagecount}页面";echo "</td>";echo "</tr>";?><tr><td background="pic/in_20.gif"></td><td background='pic/in_20.gif'> 跳转到:<input type="text" name="pagenow" /></td><td background='pic/in_20.gif'><input type="submit" value="GO" /></td><td background="pic/in_20.gif"></td><td background="pic/in_20.gif"></td></tr></table></form></body></html>
stuservice类
<?php//这个是对数据库中表student的操作include_once 'mysql.class.php';include_once 'student.class.php';include_once 'confing.php';class stuservice{//根据用户名和密码，查看个数public function checkstunum($name, $password){$mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);$num=0;$sql = "select count(*) from student where stu_name = '".$name."' and stu_password = '".$password."'";//执行命令$res = $mysql->execute_dql($sql);$row=mysqli_fetch_row($res);if($row){$num=$row[0];}mysqli_free_result($res);$mysql->close_connect();return $num;}//根据每页的大小，和当前的页面查询出所有的学生public function getstulist($pagesize,$pagenow){$mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);$sql="select * from student limit ".($pagenow-1)*$pagesize.",$pagesize";$res=$mysql->execute_dql($sql);$arr=array();$i=0;while($row = mysqli_fetch_assoc($res)){$arr[$i++]=$row;}mysqli_free_result($res);$mysql->close_connect();return $arr;}//得到总页数public function getpagecount($pagesize){$mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);$sql="select count(stu_id) from student";$res=$mysql->execute_dql($sql);$i=0;$row = mysqli_fetch_row($res);if($row){$rowcount=$row[0];}$pagecount=ceil($rowcount/$pagesize); //返回不小于 value 的下一个整数，value 如果有小数部分则进一位。mysqli_free_result($res);$mysql->close_connect();return $pagecount;}//根据学生姓名得到相应数据public function getstu($name){$stu = new student();$mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);$sql="select * from student where stu_name='".$name."'";$res=$mysql->execute_dql($sql);if($row = mysqli_fetch_assoc($res)){$stu->setStu_id($row['stu_id']);$stu->setStu_name($row['stu_name']);$stu->setStu_password($row['stu_password']);}mysqli_free_result($res);$mysql->close_connect();return $stu;}//根据id号获取userpublic function getstubyid($id){$stu = new student();$mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);$sql="select * from student where stu_id='".$id."'";$res=$mysql->execute_dql($sql);if($row = mysqli_fetch_assoc($res)){$stu->setStu_id($row['stu_id']);$stu->setStu_name($row['stu_name']);$stu->setStu_password($row['stu_password']);}mysqli_free_result($res);$mysql->close_connect();return $stu;}//根据得到的对象修改数据库中的值public function update(student $stu){$mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);$sql="update student set stu_name='".$stu->getStu_name()."',stu_password='".$stu->getStu_password()."'where stu_id=".$stu->getStu_id();$b = $mysql->execute_dml($sql);//if($b == 1)//{//return true;//}return $b;}//删除用户public function delete(student $stu){$mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);$sql = "delete from student where stu_id=".$stu->getStu_id().";";$b = $mysql->execute_dml($sql);return $b;}}?>mysql类
一直想去旅行，去很美很美的地方，但往往真正踏足想去的地方，
