简易php博客(4)_后台显示列表

来源：互联网发布：linux下批量删除文件编辑：程序博客网时间：2024/05/21 09:46
list.php
<?phpinclude("head.php");if (!empty($_GET['keys'])) {$key = $_GET['keys'];$w = " title like '%$key%'";}else{$w = 1;}//引入连接数据库include("../connect.php");//总记录数mysql_query('set names utf8');$count = mysql_result(mysql_query("SELECT COUNT(*) FROM ".DB_TBNAME),0);//每页显示$size = 10;//总页数$pagecount = ceil($count/$size);//获取浏览器传来的PAGE值 去除两边空格 转成整数 无则赋值1$page = isset($_GET['page']) ? intval(trim($_GET['page'])) : 1;//如果小于1或大于总页数则等于1if($page < 1) $page = 1;if($page > $pagecount)  $page = $pagecount;//从第几条记录开始显示$begin = ($page - 1) * $size;$sql = mysql_query("SELECT * FROM ".DB_TBNAME." WHERE $w ORDER BY id DESC LIMIT $begin,$size");echo <<<HTML<table style="border-collapse:collapse;"><tr style="text-align: center; background-color: #eee; height: 35px; width:750px;">    <td style="width: 50px">索引</td>    <td style="width: 300px; border-left: solid 2px #fff;">标题</td>    <td style="width: 200px; border-left: solid 2px #fff;">日期</td>    <td style="width: 50px; border-left: solid 2px #fff;">点击</td>    <td style="width: 150px; border-left: solid 2px #fff;">操作</td></tr>HTML;while($count && $rs = mysql_fetch_array($sql)) {    $tmp = $rs['title'];    if(strlen($tmp) > 32){        $titl = iconv_substr($tmp, 0, 16, "utf-8")."...";    }else{        $titl =  $rs['title'];    }echo <<<HTML<tr style="height: 35px; border-bottom: solid 1px #ccc;">    <td style="width: 50px;text-align: center">{$rs['id']}</td>    <td style="width: 350px"><a href="../view.php?id={$rs['id']}" title="查看" target="_blank">{$titl}</a></td>        <td style="width: 120px;text-align: center">{$rs['time']}</td>        <td style="width: 80px;text-align: center">{$rs['hits']}</td>        <td style="width: 150px;text-align: center"> <a href="edit.php?id={$rs['id']}">edit</a> | <a href="del.php?id={$rs['id']}">delete</a></td></tr>HTML;}echo <<<HTML</table>HTML;//翻页$last = $page - 1;//前页$next = $page + 1;//后页echo <<<HTML    <form method="get" style="margin-top: 20px; height: 20px;">        <a href="?page={$last}"><前页</a>        <span>第{$page}/{$pagecount}页</span>        <a href="?page={$next}">后页></a>　        <input style="width: 50px;  height: 26px; margin-bottom: 0px;" type="text" name="page" size="3" title="跳转到第几页？"/>        <input type="submit" value="GO" style="margin-left: 10px;"/>        <a style="margin-left: 10px;" href="add.php"><B>add</B></a>        <a href="../index.php"><B>foreground</B></a>    </form></div>HTML;include("foot.php");?>
效果：
0 0