aaa大片免费观看,99久久夜色精品国产网站,97se亚洲国产综合自在线

Home

類庫下載

PHP類庫

PHP search plus pagination

高洛峰

Oct 10, 2016 am 09:22 AM

$wherelist=array();
$urlist=array();
if(!empty($_GET[&#39;title&#39;]))
{
$wherelist[]=" title like &#39;%".$_GET[&#39;title&#39;]."%&#39;";
$urllist[]="title=".$_GET[&#39;title&#39;];
 
}
if(!empty($_GET[&#39;keywords&#39;]))
{
$wherelist[]=" keywords like &#39;%".$_GET[&#39;keywords&#39;]."%&#39;";
$urllist[]="keywords=".$_GET[&#39;keywords&#39;];
}if(!empty($_GET[&#39;author&#39;]))
{
$wherelist[]=" author like &#39;%".$_GET[&#39;author&#39;]."%&#39;";
$urllist[]="author=".$_GET[&#39;author&#39;];
}
$where="";
if(count($wherelist)>0)
{
$where=" where ".implode(&#39; and &#39;,$wherelist);
$url=&#39;&&#39;.implode(&#39;&&#39;,$urllist);
}
//分頁的實現(xiàn)原理
//1.獲取數(shù)據(jù)表中總記錄數(shù)
$sql="select count(*) from news $where ";
$result=mysql_query($sql);
$totalnum=mysql_num_rows($result);
//每頁顯示條數(shù)
$pagesize=5;
//總共有幾頁
$maxpage=ceil($totalnum/$pagesize);
$page=isset($_GET[&#39;page&#39;])?$_GET[&#39;page&#39;]:1;
if($page <1)
{
$page=1;
}
if($page>$maxpage)
{
$page=$maxpage;
}
$limit=" limit ".($page-1)*$pagesize.",$pagesize";
$sql1="select * from news {$where} {$limit}";
 
//$sql1="select * from news {$where} {$limit}";
$res=mysql_query($sql1);
 
?>
<form action="searchpage.php" method="get">
標(biāo)題：<input type="text" name="title" value="<?php echo $_GET[&#39;title&#39;]?>" size="8">
關(guān)鍵字<input type="text" name="keywords" value="<?php echo $_GET[&#39;keywords&#39;]?>" size="8">
作者：<input type="text" name="author" value="<?php echo $_GET[&#39;author&#39;]?>" size="8">
    <input type="button" value="查看全部" onclick="window.location=&#39;searchpage.php&#39;">
    <input type="submit" value="搜索">
</form>
 
<table border="1" width="1000" align="center">
    <tr>
        <td>編號</td>
        <td>標(biāo)題</td>
        <td>關(guān)鍵字</td>
        <td>作者</td>
        <td>日期</td>
        <td>內(nèi)容</td>
    </tr>
<?php while($row= mysql_fetch_assoc($res)){?>
<tr>
            <td><?php echo $row[&#39;id&#39;] ?></td>
            <td><?php echo $row[&#39;title&#39;] ?></td>
            <td><?php echo $row[&#39;keywords&#39;] ?></td>
            <td><?php echo $row[&#39;author&#39;] ?></td>
            <td><?php echo date("Y-m-d H:i:s",$row[&#39;addtime&#39;]) ?></td>
            <td><?php echo $row[&#39;content&#39;] ?></td>
        </tr>
<?php }?>
<tr>
        <td colspan="6">
<?php
            echo " 當(dāng)前{$page}/{$maxpage}頁 共{$totalnum}條";
echo " <a href=&#39;searchpage.php?page=1{$url}&#39;>首頁</a> ";
echo "<a href=&#39;searchpage.php?page=".($page-1)."{$url}&#39;>上一頁</a>";
echo "<a href=&#39;searchpage.php?page=".($page+1)."{$url}&#39;>下一頁</a>";
echo " <a href=&#39;searchpage.php?page={$maxpage}{$url}&#39;>尾頁</a> ";
 
?>
</td>
    </tr>
</table>

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn