我在弄搜索以后 把搜索结果按分页来显示 但是只能显示第一页 后面的页都显示不出来 部分代码如下
<?php
$searchtype=$_POST['searchtype'];//从搜索页面传来的值
$searchterm=$_POST['searchterm'];
$searchterm= trim($searchterm);$db = new mysqli('localhost', 'root', '123456', 'book');
$query = "select * from books where ".$searchtype." like '%".$searchterm."%' ";
$result = $db -> query($query);
$total = $result -> num_rows;
if(!$result)
echo 'ther is no';
else
echo '<p>Number of books found: '.$total.'</p>';//以上代码为搜索过程$page=isset($_GET['page'])?intval($_GET['page']):1; //翻页代码
$num=1;
$db=mysql_connect("localhost","root","123456");
$select=mysql_select_db("book",$db);
$url="result.php";
$pagenum=ceil($total/$num);
If($page>$pagenum || $page == 0){
Echo "Error : Can Not Found The page .";
Exit;
}
$offset=($page-1)*$num;
$query1 = "select * from books where ".$searchtype." like '%".$searchterm."%' limit $offset,$num";
$info=mysql_query($query1);
While($it=mysql_fetch_array($info)){
Echo $it['isbn'];
echo $it['author']."<br/>";} For($i=1;$i<=$pagenum;$i++){
$show=($i!=$page)?"<a href='$url?page=".$i."'>".$i."</a>":"<b>$i</b>";
Echo $show." ";
}echo "共有 $total 条记录";
?>
<?php
$searchtype=$_POST['searchtype'];//从搜索页面传来的值
$searchterm=$_POST['searchterm'];
$searchterm= trim($searchterm);$db = new mysqli('localhost', 'root', '123456', 'book');
$query = "select * from books where ".$searchtype." like '%".$searchterm."%' ";
$result = $db -> query($query);
$total = $result -> num_rows;
if(!$result)
echo 'ther is no';
else
echo '<p>Number of books found: '.$total.'</p>';//以上代码为搜索过程$page=isset($_GET['page'])?intval($_GET['page']):1; //翻页代码
$num=1;
$db=mysql_connect("localhost","root","123456");
$select=mysql_select_db("book",$db);
$url="result.php";
$pagenum=ceil($total/$num);
If($page>$pagenum || $page == 0){
Echo "Error : Can Not Found The page .";
Exit;
}
$offset=($page-1)*$num;
$query1 = "select * from books where ".$searchtype." like '%".$searchterm."%' limit $offset,$num";
$info=mysql_query($query1);
While($it=mysql_fetch_array($info)){
Echo $it['isbn'];
echo $it['author']."<br/>";} For($i=1;$i<=$pagenum;$i++){
$show=($i!=$page)?"<a href='$url?page=".$i."'>".$i."</a>":"<b>$i</b>";
Echo $show." ";
}echo "共有 $total 条记录";
?>
1.改$searchterm=$_POST['searchterm'];--->$searchterm=$_REQUEST['searchterm'];2.改$show=($i!=$page)?"<a href='$url?page=".$i."'>".$i."</a>":"<b>$i</b>";
----------->
$show=($i!=$page)?"<a href='$url?page=".$i."searchterm={$searchterm}'>".$i."</a>":"<b>$i</b>";
$show .= ($i!=$page)?"<a href='$url?page=".$i."searchterm={$searchterm}'>".$i."</a>":"<b>$i</b>";