php简单分页 和 jquery实现超简单的隔行变色
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<!--加载 jquery.js -->
<script language="javascript" type="text/javascript" src="jquery.js"></script>
<script language="javascript" type="text/javascript">
$(document).ready(function (){
$("tr:even").css("background","#00FFFF");
$("tr:odd").css("background","#FFD700");
});
</script>
</head>
<body>
<table border="0" width="600">
<?php
//加载连接数据库的文件
include "dbconn.php";
//定义几个变量
//定义总页数
$pages="";
//定义每行显示条数据
$PAGESIZE=5;
//从数据中查找总共有多少条数据
$sql=mysql_query("select * from weibo");
$rs=mysql_num_rows($sql);
$pages=$rs;
//计算共有多少页
$pages=ceil($rs/$PAGESIZE);
if(empty($_GET['np'])){
$nowpages=1;
}else{
$nowpages=$_GET['np'];
}
if($nowpages>$pages){
$nowpages=$pages;
}
//进行显示写sql语句limit
$sql="select * from weibo limit ".($nowpages-1)*$PAGESIZE.",".$PAGESIZE." ";
$rs1=mysql_query($sql);
?>
<tr><td>编号</td><td>话题</td><td>微博</td></tr>
<?php
while($rows=mysql_fetch_assoc($rs1)){
?>
<tr><td><?php echo $rows['c_id'] ?></td><td><?php echo $rows['topic'] ?></td><td><?php echo $rows['content'] ?></td></tr>
<?php
}
?>
<tr><td colspan="3"><a href="ourpage.php?np=1">首页</a>
<a href="ourpage.php?np=<?php echo $nowpages-1; ?>">上一页</a>
<a href="ourpage.php?np=<?php echo $nowpages+1; ?>">下一页</a>
<a href="ourpage.php?np=<?php echo $pages ?>">尾页</a>
</td></tr>
</table>
</body>
</html>
页:
[1]