单纯点的:
$rbp=10;if(empty($page))
{
$limitSQL="limit 0,$rbp";
$page=0;
}
else
{
$offset=$page*$rbp;
$limitSQL="limit $offset,$rbp";
}$sql="select * from AD_expo order by id desc $limitSQL";
$rbp=10;if(empty($page))
{
$limitSQL="limit 0,$rbp";
$page=0;
}
else
{
$offset=$page*$rbp;
$limitSQL="limit $offset,$rbp";
}$sql="select * from AD_expo order by id desc $limitSQL";
解决方案 »
- mysql_fetch_row(): supplied argument is not a valid MySQL result resource
- 刚学PHP,想问下怎么打开MYSQL
- title标签输出不了PHP程序
- 依据单选按钮触发事件
- 调用mysql存储过程问题
- 现在普遍用什么样的PHP调试环境呢?
- 在2000下安装php编程,要不要象asp(本人略通asp)那样设置odbc数据源,哪个iodbc是做什么用的
- 为何这里的变量没有注册
- 头痛!!unix下装了PHP,可惜没GD图型库,怎么办啊?:(
- 帮我看看是什么出错,好吗?Fatal error: Maximum execution time of 30 seconds exceeded in G:\supermarket\SearchHeTong.php on line 186
- SQL查询:能不能只找到限定数量的数据比如从1~10条or11~20条?还要对于要分页显示的内容是一次全找出来再分页,还是安装需求找所需数据?请提
- 谁可以帮我做一个记录总访问量的程序
http://www.chinesehis.com/starry/sread.php?forumid=3&filename=f_50
$rbp=10;if(empty($page))
{
$limitSQL="limit 0,$rbp";
$page=0;
}
else
{
$offset=$page*$rbp;
$limitSQL="limit $offset,$rbp";
}$sql="select * from AD_expo order by id desc $limitSQL";
就是 PHP自己不提供翻页功能,只能依靠MySql来完成,没有ASP方便,但是很灵活。
require('header.php');
require('pre1.php');?>
<?php
$whyname=$name;
$str ="select * from reg where xname='$name'";
$sult=mysql_db_query($dbname,$str,$link_message);
$record=mysql_fetch_object($sult);
?>
<?php
if ($pass !=$record->xpass )
{echo 'error' ;}
else { ?>
<table width="600" border="0">
<tr>
<td width="14%">
<div align="center">呢称</div>
</td>
<td width="14%">
<div align="center">生日</div>
</td>
<td width="14%">
<div align="center">来自</div>
</td>
<td width="14%">
<div align="center">性格</div>
</td>
<td width="14%">
<div align="center">工作</div>
</td>
<td width="14%">
<div align="center">魅力</div>
</td> <td width="16%">
<div align="center">删除</div>
</td>
</tr>
<?php
$char="select name,birthday,laizi,nature,job,count,id from $tablename";
mysql_select_db("$dbname",$link_message);$querystring="select name,birthday,laizi,nature,job,count,id from $tablename order by id desc";
$result=mysql_query($querystring,$link_message);$pagenum=@mysql_num_rows($result);
$quotient=$pagenum/10;if(is_int($quotient)){
$pages=$quotient;}else{
$pages=intval($quotient)+1;}if(empty($page)){
$page=1;
$querystring="select name,birthday,laizi,nature,job,count,id from $tablename where id between $pagenum-9 and $pagenum order by id desc";}
else{
$querystring="select name,birthday,laizi,nature,job,count,id from $tablename where id between $pagenum-($page-1)*10-9 and $pagenum-($page-1)*10 order by id desc";
}
$result=mysql_query($querystring,$link_message);
while(list($name,$birthday,$laizi,$nature,$job,$count)=mysql_fetch_row($result)){
require('display3.php');}}
?>
</table>
<table width="620" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td width="70%"> [ <?if($page>1):?><a href="msgboard.php?page=<?echo $page-1;?>">上一页</a> <?endif;?><font face="Verdana, Arial, Helvetica, sans-serif">
<?
for($i=1;$i<$pages+1;$i++){
if($i!=$page):
echo "<a href=showall.php?page=$i>$i</a> ";
else:
echo "$i ";
endif;
}
?>
</font> <?if($page<$pages):?><a href="showall.php?page=<?echo $page+1;?>">下一页</a> <?endif;?>]</td>
<td>每页显示11条共<font face="Verdana, Arial, Helvetica, sans-serif"><?echo $pagenum;?></font>条<font face="Verdana, Arial, Helvetica, sans-serif"><?echo $pages;?></font>页
第<font face="Verdana, Arial, Helvetica, sans-serif"><?echo $page;?></font>页</td>
</tr>
</table>
<?php
require('footer.php');
?>
如果运用呢?
的意思
用法:
limti x,yx:记录偏移
y:数量从x开始,取y 条记录