请教个查询分页显示的问题---(在线等) echo "<a href='$PHP_SELF?page=".$first."&search=".$search."'>首页</a> "; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 sorry,还有name,也要传给下页。忘记了写了。 恩,明白了,但对超连接参数的传递不是很清楚,上面代码也是down别人自己改的,能不能写得详细点啊?? echo "<a href='$PHP_SELF?page=$first&search=$search&name=$name'>首页</a>";例如: xxx.php?a=1&b=12&c=999这样的到了下页变量就是$a$b$c 恩,改好后确实能点下一页了,那个跳页的算法大概错了...所以点几次后就出现Warning: Unable to jump to row -5 on MySQL result index 2 in c:\apache\htdocs\myphp\r.php on line 28谁帮我改一下啊,这是我改后的代码:<?php$db=mysql_connect("localhost","root");mysql_select_db("my",$db);$result=mysql_query("SELECT * FROM customer WHERE $name LIKE '%$search%'",$db);$num= mysql_num_rows($result);if ($num==0){echo "NO FOUND";}$pagesize=5;$page_count=ceil($num/$pagesize);if($page>$page_count){$page=$page_count;}elseif($page<1){$page=1;}$start=($page-1)*$pagesize;echo "<table width=90% align=center border=1><tr><td align=center bgcolor=#00FFFF>客户帐号</td><td align=center bgcolor=#00FFFF>客户姓名</td><td align=center bgcolor=#00FFFF>客户主页</td></tr>";for ($i=1;$i<=$pagesize;$i++){if ($start<$num){$Id=mysql_result($result,$start,"Id");$name=mysql_result($result,$start,"name");$homePage=mysql_result($result,$start,"homePage");echo "<tr><td>$Id</td><td>$name</td><td>$homePage</td></tr>";$start=$start+1;}} echo "<div align='center'>共有".$page_count."页(".$page."/".$page_count.")<br>";for ($i=1;$i<=$page_count;$i++)echo "<a href='$PHP_SELF?page=".$i."&search=".$search."&name=".$name."'>第".$i ."页</a> ";echo "<br>";//显示转到页数echo "<form action='r.php'method='post'> ";//计算首页、上一页、下一页、尾页的页数值$first=1;$prev=$page-1;$next=$page+1;$last=$page_count;if ($page>1){echo "<a href='$PHP_SELF?page=".$first."&search=".$search."&name=".$name."'>首页</a> ";echo "<a href='$PHP_SELF?page=".$prev."&search=".$search."&name=".$name."'>上一页</a> ";}if ($page>$pages_count){echo "<a href='$PHP_SELF?page=".$next."&search=".$search."&name=".$name."'>下一页</a> "; echo "<a href='$PHP_SELF?page=".$last."&search=".$search."&name=".$name."'> 尾页 </a> ";}echo "转到<input type=text name='page' size='2' value=".$page.">页";echo "<input type=submit name='Submit' value='Go'>";echo "</form>";echo "</div>";?> 我知道为什么错了,$name用了两次....谢谢了. sql 注入语句 RSS 采集的问题 如何更新页面? 求php牛人写个判断 谁能检查出本程序错误?(用php制作二级关联菜单,且能从数据库中取记录. ) 怎样在本窗体关闭后自动刷新其他窗体 谁帮我实现这个功能,高分。 PHP书籍大比拼~~~~~给我建议吧! 如何在指定图片上动态生成其他图象? 在一个类里 其中的一个方法如何调用 另一个方法中的属性变量? 奇怪的问题 关于时间比较的 关于数据显示问题
忘记了写了。
$b
$c
所以点几次后就出现Warning: Unable to jump to row -5 on MySQL result index 2 in c:\apache\htdocs\myphp\r.php on line 28
谁帮我改一下啊,这是我改后的代码:
<?php
$db=mysql_connect("localhost","root");
mysql_select_db("my",$db);
$result=mysql_query("SELECT * FROM customer WHERE $name LIKE '%$search%'",$db);
$num= mysql_num_rows($result);
if ($num==0)
{echo "NO FOUND";
}
$pagesize=5;
$page_count=ceil($num/$pagesize);
if($page>$page_count)
{
$page=$page_count;
}
elseif($page<1)
{$page=1;
}
$start=($page-1)*$pagesize;
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#00FFFF>客户帐号</td>
<td align=center bgcolor=#00FFFF>客户姓名</td>
<td align=center bgcolor=#00FFFF>客户主页</td>
</tr>";
for ($i=1;$i<=$pagesize;$i++)
{if ($start<$num)
{$Id=mysql_result($result,$start,"Id");
$name=mysql_result($result,$start,"name");
$homePage=mysql_result($result,$start,"homePage");
echo "<tr>
<td>$Id</td>
<td>$name</td>
<td>$homePage</td>
</tr>";
$start=$start+1;
}
}
echo "<div align='center'>共有".$page_count."页(".$page."/".$page_count.")<br>";
for ($i=1;$i<=$page_count;$i++)
echo "<a href='$PHP_SELF?page=".$i."&search=".$search."&name=".$name."'>第".$i ."页</a> ";
echo "<br>";
//显示转到页数
echo "<form action='r.php'method='post'> ";
//计算首页、上一页、下一页、尾页的页数值
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$page_count;
if ($page>1)
{
echo "<a href='$PHP_SELF?page=".$first."&search=".$search."&name=".$name."'>首页</a> ";
echo "<a href='$PHP_SELF?page=".$prev."&search=".$search."&name=".$name."'>上一页</a> ";
}
if ($page>$pages_count)
{
echo "<a href='$PHP_SELF?page=".$next."&search=".$search."&name=".$name."'>下一页</a> ";
echo "<a href='$PHP_SELF?page=".$last."&search=".$search."&name=".$name."'> 尾页 </a> ";
}
echo "转到<input type=text name='page' size='2' value=".$page.">页";
echo "<input type=submit name='Submit' value='Go'>";
echo "</form>";
echo "</div>";
?>
谢谢了.