<table border="0" width="730" cellspacing="0" cellpadding="0">
<tr>
<td width="30%" bgcolor="#C0C0C0" bordercolor="#0000FF" align="center">UID</td>
<td width="30%" bordercolor="#0000FF" bgcolor="#C0C0C0" align="center">UNAME</td>
<td width="30%" bordercolor="#0000FF" bgcolor="#C0C0C0" align="center">URELATION</td>
</tr> <?php
require(conn.php);
if (mysql_connect_error())
{
echo "that meets a mistake ";
}
$query="select * from usrrelation";
$result=mysql_query($query);
//echo $query;
$numrows = mysql_number_rows($result);
//echo $numrows;
//取得记录总数$rs,计算总页数用
//计算总页数
$pagesize=2;
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)
$pages++; //设置页数
if (isset($_GET['page']))
{
$page=intval($_GET['page']);
}
else
{
//设置为第一页
$page=1;
}
//计算记录偏移量
$offset=$pagesize*($page - 1);
$query="select * from usrrelation limit $offset,$pagesize";
$result=mysql_query($query);
while($row=mysql_fetch_array($result))
{
?>
<tr>
<td width="30%" ><?php echo $row["uid"] ?> </td>
<td width="30%" ><?php echo $row["uname"] ?> </td>
<td width="30%" ><?php echo $row["urelation"] ?></td>
</tr>
<?php
}
?>
</table>
代码只差最后页面的那几个链接了!请高手帮我看下!
<tr>
<td width="30%" bgcolor="#C0C0C0" bordercolor="#0000FF" align="center">UID</td>
<td width="30%" bordercolor="#0000FF" bgcolor="#C0C0C0" align="center">UNAME</td>
<td width="30%" bordercolor="#0000FF" bgcolor="#C0C0C0" align="center">URELATION</td>
</tr> <?php
require(conn.php);
if (mysql_connect_error())
{
echo "that meets a mistake ";
}
$query="select * from usrrelation";
$result=mysql_query($query);
//echo $query;
$numrows = mysql_number_rows($result);
//echo $numrows;
//取得记录总数$rs,计算总页数用
//计算总页数
$pagesize=2;
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)
$pages++; //设置页数
if (isset($_GET['page']))
{
$page=intval($_GET['page']);
}
else
{
//设置为第一页
$page=1;
}
//计算记录偏移量
$offset=$pagesize*($page - 1);
$query="select * from usrrelation limit $offset,$pagesize";
$result=mysql_query($query);
while($row=mysql_fetch_array($result))
{
?>
<tr>
<td width="30%" ><?php echo $row["uid"] ?> </td>
<td width="30%" ><?php echo $row["uname"] ?> </td>
<td width="30%" ><?php echo $row["urelation"] ?></td>
</tr>
<?php
}
?>
</table>
代码只差最后页面的那几个链接了!请高手帮我看下!
<?php
// 建立数据库连接
$link = mysql_connect("localhost", "root", "111111")
or die("Could not connect: " . mysql_error());
mysql_select_db("gprs",$link);
mysql_query("SET NAMES gbk");
// 获取当前页数
if( isset($_POST['page']) )//判断是否有下面的表单post来的值
{
$page=$_POST['page'];
}
else if(isset($_GET['page']))//判断是否有get来的值
{
$page = intval( $_GET['page'] );
}
else
{
$page = 1;
}
// 每页数量
$page_size = 3;
// 获取总数据量
$sql = "select count(*) as amount from sms_send";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$amount = $row[0];
// 记算总共有多少页
if( $amount )
{
if( $amount < $page_size )//如果总数据量小于$PageSize,那么只有一页
{
$page_count = 1;
}
if( $amount % $page_size ) //取总数据量除以每页数的余数
{
$page_count = (int)($amount / $page_size) + 1; //如果有余数,则页数等于总数据量除以每页数的结果取整再加一
}
else
{
$page_count = $amount / $page_size; //如果没有余数,则页数等于总数据量除以每页数的结果
}
}
else
{
$page_count = 0;
}
// 翻页链接
$page_string = '';
if( $page == 1)
{
$page_string .= '首页|上一页|';
}
else
{
$page_string .= '<a href=?page=1>首页</a>|<a href=?page='.($page-1).'>上一页</a>|';
}
if( ($page == $page_count) || ($page_count == 0) )
{
$page_string .= '下一页|末页';
}
else
{
$page_string .= '<a href=?page='.($page+1).'>下一页</a>|<a href=?page='.$page_count.'>末页</a>';
}
?>
<?php
//截取GB2312中文字符串
function mysubstr($str, $start, $len) {
$tmpstr = "";
$strlen = $start + $len;
for($i = 0; $i < $strlen; $i++) {
if(ord(substr($str, $i, 1)) > 0xa0) {
$tmpstr .= substr($str, $i, 2);
$i++;
} else
$tmpstr .= substr($str, $i, 1);
}
if(strlen($str)>strlen($tmpstr))
{
$tmpstr.='...';
}
return $tmpstr;
}
?><!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=gb2312" />
<title>分页显示记录</title>
<script>
setTimeout("self.location.reload();",5000);//每隔5秒自动刷新一次
</script>
</head>
<style type="text/css">
.style1{ position: absolute; left: 5%; top: 220px }
</style><body bgcolor="#CCCCCC">
<table width="60%" style="margin-left:5%; margin-top:50px;" rules="all" border="1" bordercolor="#3300FF">
<tr style="margin-bottom:10;">总共<?php echo "<font color='#CC0033'>".$amount."</font>";?>条记录</tr>
<tr>
<td bgcolor="#333333" width="5%"><div align="center" class="title"><font color="#FFFFFF">标志</font></div></td>
<td bgcolor="#333333" width="15%"><div align="center" class="title"><font color="#FFFFFF">手机号码</font></div></td>
<td bgcolor="#333333" width="65%"><div align="center" class="title"><font color="#FFFFFF">短信内容</font></div></td>
<td bgcolor="#333333" width="15%"><div align="center" class="title"><font color="#FFFFFF">接收时间</font></div></td>
</tr>
<?php
$server=$_SERVER['PHP_SELF'];
$start=($page-1)*$page_size;
$res=mysql_query("select targetnumber,content,time,flag from sms_send order by time desc limit $start , $page_size" ,$link);
while($myrow = mysql_fetch_array($res))
{?>
<?php $myrow_q=mysubstr($myrow[1],0,20)?><!--截取10个中文汉字-->
<tr>
<?php echo "<td>".$myrow[3]."</td>"."<td>".$myrow[0]."</td>"."<td>".$myrow_q."</td>"."<td>".$myrow[2]."</td>";?>
</tr>
<?php } ?>
</table>
<table width="60%" style="margin-left:5%;" class="style1">
<tr><td colspan="3" align="center">
<form method="post">
<?php
echo "共"." ".$page_count." "."页(".$page."/".$page_count.")"." ".$page_string;
?>
跳到<input type="text" name="page" value="1" size="2" />页
<input type="submit" value="go" />
</form>
</td></tr></table></body>
</html>