这是学生信息管理每三条一页=>
<?php
function news($pageNum = 1, $pageSize = 3)
{
$array = array();
$mysql=new mysql();
$rs = "select * from user limit " . (($pageNum - 1) * $pageSize) . "," . $pageSize;
$r = $mysql->query($rs);
while ($obj = mysqli_fetch_object($r)) {
$array[] = $obj;
}
return $array;
}
function allNews()
{
$mysql=new mysql();
$rs = "select count(*) num from user";
$r = $mysql->query($rs);
$obj = mysqli_fetch_object($r);
return $obj->num;
}
@$allNum = allNews();
@$pageSize = 3;
@$pageNum = empty($_GET["pageNum"])?1:$_GET["pageNum"];
@$endPage = ceil($allNum/$pageSize);
@$array = news($pageNum,$pageSize);
?>
<form>
<table border="1" cellspacing="0" align="center" style="z-index:10;">
<tr>
<td>ID</td>
<td>username</td>
<td>mela</td>
<td>academic</td>
<td>profession</td>
<td>number</td>
<td>email</td>
<td>qq</td>
<td>pubtime</td>
<td>status</td>
<td>modify</td>
<td>delete</td>
</tr>
<?php foreach($array as $k=>$v){ ?>
<tr>
<?php
echo "<td>{$v->id}</td>";
echo "<td>{$v->username}</td>";
echo "<td>{$v->mela}</td>";
echo "<td>{$v->academic}</td>";
echo "<td>{$v->profession}</td>";
echo "<td>{$v->number}</td>";
echo "<td>{$v->email}</td>";
echo "<td>{$v->qq}</td>";
echo "<td>{$v->pubtime}</td>";
echo "<td>{$v->status}</td>";
?>
</tr>
</form>
<?php } ?>
</table>
<div>
<a href="?pageNum=1">首页</a>
<a href="?pageNum=<?php echo $pageNum==1?1:($pageNum-1)?>">上一页</a>
<a href="?pageNum=<?php echo $pageNum==$endPage?$endPage:($pageNum+1)?>">下一页</a>
<a href="?pageNum=<?php echo $endPage?>">尾页</a>
</div>
结果为:
php在函数前加@的作用:
@是错误控制运算符,用屏蔽错误提示
比如:
@mysql_connect() 不会出现Warning。