求助!!(mysql)在有1万条记录的表里,查询出符合条件的记录有2千条,有什么办法可以把这2千条记录进行分页? ..... limit 0,10是取开头的10条记录 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 多谢回复。。我点下一页怎么报这个错误:1065: Query was empty 多谢回复。。我点下一页怎么报这个错误:1065: Query was empty参数没有传递过去! 每页显示20条 <?php if(!$page){ $page=1; }else{ if($page<1) $page=1; } $temp = ($page-1)*20; //每页显示的起始位置 $str = "select * from table where ******* limit $temp,20"; $query = mysql_query($str); $nums = mysql_num_rows($query); //总的记录数 $totalpages=ceil($nums/20); //总的页数 ?> $page是点击“下一页”、“上一页”、“首页”、“尾页”、“跳到**页”传过来的参数 下一页:$page = $page + 1 上一页:$page = $page - 1 首页: $page = 1 尾页: $page = $totalpages 跳到**页:$page = ** 别的你看着办,很简单的 <?phprequire_once('../register/mysql.php'); $db=db_connect(); db_select('www'); $data=$_POST['x']; $selects=$_POST['selects'];switch($selects){ case 'a': $sqla = "select count(*) count from song where authname like'%$data%'"; $result = mysql_query($sqla) or die("查询数据库失败"); $rs=mysql_fetch_object($result); $recountCount = $rs->count; if($recountCount==0){ echo "<h1>sorry!搜索不到您要的结果!</h1>"; exit; } $show = 3; $totalPage = ceil($recountCount/$show); $page = (isset($_GET['page']) && $_GET['page']>=0)? $_GET['page']: 0; $isLast = ($page==($totalPage-1))? true: false; $hasNoPre = ($page==0)? true: false; $hasNoNext = ($page==$totalPage-1)? true: false; $isFirst = ($page==0)? true:false; $start = $page*$show; mysql_free_result($result); $sqlb = "select * from song where authname like'%$data%' limit $start,$show"; break; case 's': $sqla = "select count(*) count from song where songname like'%$data%'"; $result = mysql_query($sqla) or die("查询数据库失败"); $rs=mysql_fetch_object($result); $recountCount = $rs->count; if( $recountCount==0){ echo "<h1>sorry!搜索不到您要的结果!</h1>"; exit; } $show = 8; $totalPage = ceil($recountCount/$show); $page = (isset($_GET['page']) && $_GET['page']>=0)? $_GET['page']: 0; $isLast = ($page==($totalPage-1))? true: false; $hasNoPre = ($page==0)? true: false; $hasNoNext = ($page==$totalPage-1)? true: false; $isFirst = ($page==0)? true:false; $start = $page*$show; mysql_free_result($result); $sqlb = "select * from song where songname like'%$data%' limit $start,$show"; break; } ?> <TABLE cellSpacing=1 cellPadding=0 width="95%" border=0> <TBODY> <TR> <TD width=71 background=misic_all.files/cl-1_49.gif height=26> <DIV align=center>编号</DIV></TD> <TD width=127 background=misic_all.files/cl-1_49.gif> <DIV align=center>歌名</DIV></TD> <TD width=95 background=misic_all.files/cl-1_49.gif> <DIV align=center>歌手</DIV></TD> <TD width=58 background=misic_all.files/cl-1_49.gif> <DIV align=center>人气</DIV></TD> <TD width=55 background=misic_all.files/cl-1_49.gif> <DIV align=center>价格</DIV></TD> <TD width=63 background=misic_all.files/cl-1_49.gif> <DIV align=center>试听</DIV></TD> <TD width=54 background=misic_all.files/cl-1_49.gif> <DIV align=center>赠送</DIV></TD> <TD width=57 background=misic_all.files/cl-1_49.gif> <DIV align=center>定制</DIV></TD></TR><!tr class="td01"> <? $result = mysql_query($sqlb) or die(mysql_errno().": ".mysql_error()."\n"); while($rs=mysql_fetch_array($result)){ echo "<TR bgColor=#e8f2fb> <TD height=19> <DIV align=center>".$rs['sid']."</DIV></TD> <TD> <DIV align=center>".$rs['songname']."</DIV></TD> <TD> <DIV align=center>".$rs['authname']."</DIV></TD> <TD> <DIV align=center>".$rs['powers']."</DIV></TD> <TD> <DIV align=center>".$rs['jiage']."</DIV></TD> <TD>"; echo "<DIV align=center><a href=\"#:\" onClick=\"window.open('../shi-ting/mpv.php?y=".$rs['url']."&name=".$rs['songname']."&auth=".$rs['authname']."&pie=".$rs['jiage']."','sample','width=308 height=288 resizable=no scrollbars=no')\" width=\"308\" height=\"288\" scrollbars=\"no\"><img src=\"../music/music_all/misic_all.files/ico-1.gif\" width=\"14\" height=\"12\" border=\"0\"></a></DIV></TD> <TD>"; echo " <DIV align=center><a href=\"#\"><img src=\"../phto/zs.gif\" width=\"11\" height=\"12\" border=\"0\"></a></DIV></TD> <TD>"; echo "<DIV align=center><a href=\"#\" onClick=\"window.open('../ding-zhi/dingzhi-s.php?name=".$rs['songname']."&auth=".$rs['authname']."&pie=".$rs['jiage']."','sample','width=308 height=288 resizable=no scrollbars=no')\" width=\"248\" height=\"248\" scrollbars=\"no\"><img src=\"../phto/cl-dg.gif\" width=\"14\" height=\"14\" border=\"0\"></a></DIV></TD></TR> <TR bgColor=#6bb0e3> <TD colSpan=9 height=1></TD></TR> " ; } mysql_free_result($result); $str = "共 $recountCount 条记录,当前第 ".($page+1)."/$totalPage 页 "; $str .= $isFirst? "首页 " : "<a href=\"?page=0\">首页</a> "; $str .= $hasNoPre? "上一页 " : "<a href=\"?page=".($page-1)."\">上一页</a> "; $str .= $hasNoNext? "下一页 " : "<a href=\"?page=".($page+1)."\">下一页</a> "; $str .= $isLast? "尾页 " : "<a href=\"?page=".($totalPage-1)."\">尾页</a>"; echo $str;?> limit分页LINK中再带入参数 生成多张略缩图 类在实例化时就调用了内部的判断函数.是怎么回事 有没有朋友有PHP5服务器可以让我合租啊 如何把 mysql 中的数据生成一个 xml文档 请教dede:arclist如何修改字体大小? 如何在php中引用ActiveX对象??? 请教php中cookie的用法 怎样实现数据库中字段求和 读网卡地址(MAC) php 读取access数据的blob字段信息生成字体文件 有个php的Blog程序叫什么来 把register_globals设置成ON的问题?
参数没有传递过去!
<?php
if(!$page){
$page=1;
}else{
if($page<1) $page=1;
}
$temp = ($page-1)*20; //每页显示的起始位置
$str = "select * from table where ******* limit $temp,20";
$query = mysql_query($str);
$nums = mysql_num_rows($query); //总的记录数
$totalpages=ceil($nums/20); //总的页数
?> $page是点击“下一页”、“上一页”、“首页”、“尾页”、“跳到**页”传过来的参数
下一页:$page = $page + 1
上一页:$page = $page - 1
首页: $page = 1
尾页: $page = $totalpages
跳到**页:$page = **
别的你看着办,很简单的
require_once('../register/mysql.php');
$db=db_connect();
db_select('www');
$data=$_POST['x'];
$selects=$_POST['selects'];switch($selects){
case 'a':
$sqla = "select count(*) count from song where authname like'%$data%'";
$result = mysql_query($sqla) or die("查询数据库失败");
$rs=mysql_fetch_object($result);
$recountCount = $rs->count;
if($recountCount==0){
echo "<h1>sorry!搜索不到您要的结果!</h1>";
exit;
}
$show = 3;
$totalPage = ceil($recountCount/$show);
$page = (isset($_GET['page']) && $_GET['page']>=0)? $_GET['page']: 0;
$isLast = ($page==($totalPage-1))? true: false;
$hasNoPre = ($page==0)? true: false;
$hasNoNext = ($page==$totalPage-1)? true: false;
$isFirst = ($page==0)? true:false;
$start = $page*$show;
mysql_free_result($result);
$sqlb = "select * from song where authname like'%$data%' limit $start,$show";
break;
case 's':
$sqla = "select count(*) count from song where songname like'%$data%'";
$result = mysql_query($sqla) or die("查询数据库失败");
$rs=mysql_fetch_object($result);
$recountCount = $rs->count;
if( $recountCount==0){
echo "<h1>sorry!搜索不到您要的结果!</h1>";
exit;
}
$show = 8;
$totalPage = ceil($recountCount/$show);
$page = (isset($_GET['page']) && $_GET['page']>=0)? $_GET['page']: 0;
$isLast = ($page==($totalPage-1))? true: false;
$hasNoPre = ($page==0)? true: false;
$hasNoNext = ($page==$totalPage-1)? true: false;
$isFirst = ($page==0)? true:false;
$start = $page*$show;
mysql_free_result($result);
$sqlb = "select * from song where songname like'%$data%' limit $start,$show";
break;
}
?>
<TABLE cellSpacing=1 cellPadding=0 width="95%" border=0>
<TBODY>
<TR>
<TD width=71 background=misic_all.files/cl-1_49.gif height=26>
<DIV align=center>编号</DIV></TD>
<TD width=127 background=misic_all.files/cl-1_49.gif>
<DIV align=center>歌名</DIV></TD>
<TD width=95 background=misic_all.files/cl-1_49.gif>
<DIV align=center>歌手</DIV></TD>
<TD width=58 background=misic_all.files/cl-1_49.gif>
<DIV align=center>人气</DIV></TD>
<TD width=55 background=misic_all.files/cl-1_49.gif>
<DIV align=center>价格</DIV></TD>
<TD width=63 background=misic_all.files/cl-1_49.gif>
<DIV align=center>试听</DIV></TD>
<TD width=54 background=misic_all.files/cl-1_49.gif>
<DIV align=center>赠送</DIV></TD>
<TD width=57 background=misic_all.files/cl-1_49.gif>
<DIV align=center>定制</DIV></TD></TR><!tr class="td01">
<?
$result = mysql_query($sqlb) or die(mysql_errno().": ".mysql_error()."\n");
while($rs=mysql_fetch_array($result)){
echo "<TR bgColor=#e8f2fb>
<TD height=19>
<DIV align=center>".$rs['sid']."</DIV></TD>
<TD>
<DIV align=center>".$rs['songname']."</DIV></TD>
<TD>
<DIV align=center>".$rs['authname']."</DIV></TD>
<TD>
<DIV align=center>".$rs['powers']."</DIV></TD>
<TD>
<DIV align=center>".$rs['jiage']."</DIV></TD>
<TD>";
echo "<DIV align=center><a href=\"#:\" onClick=\"window.open('../shi-ting/mpv.php?y=".$rs['url']."&name=".$rs['songname']."&auth=".$rs['authname']."&pie=".$rs['jiage']."','sample','width=308 height=288 resizable=no scrollbars=no')\" width=\"308\" height=\"288\" scrollbars=\"no\"><img src=\"../music/music_all/misic_all.files/ico-1.gif\" width=\"14\" height=\"12\" border=\"0\"></a></DIV></TD>
<TD>";
echo " <DIV align=center><a href=\"#\"><img src=\"../phto/zs.gif\" width=\"11\" height=\"12\" border=\"0\"></a></DIV></TD>
<TD>";
echo "<DIV align=center><a href=\"#\" onClick=\"window.open('../ding-zhi/dingzhi-s.php?name=".$rs['songname']."&auth=".$rs['authname']."&pie=".$rs['jiage']."','sample','width=308 height=288 resizable=no scrollbars=no')\" width=\"248\" height=\"248\" scrollbars=\"no\"><img src=\"../phto/cl-dg.gif\" width=\"14\" height=\"14\" border=\"0\"></a></DIV></TD></TR>
<TR bgColor=#6bb0e3>
<TD colSpan=9
height=1></TD></TR> " ;
}
mysql_free_result($result);
$str = "共 $recountCount 条记录,当前第 ".($page+1)."/$totalPage 页 ";
$str .= $isFirst? "首页 " : "<a href=\"?page=0\">首页</a> ";
$str .= $hasNoPre? "上一页 " : "<a href=\"?page=".($page-1)."\">上一页</a> ";
$str .= $hasNoNext? "下一页 " : "<a href=\"?page=".($page+1)."\">下一页</a> ";
$str .= $isLast? "尾页 " : "<a href=\"?page=".($totalPage-1)."\">尾页</a>";
echo $str;
?>
分页LINK中再带入参数