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

最新推荐文章于 2021-04-02 08:29:16 发布

shareinfo2018

最新推荐文章于 2021-04-02 08:29:16 发布

阅读量664

点赞数

分类专栏： web

本文链接：https://blog.csdn.net/chenyefei/article/details/51685847

版权

web 专栏收录该内容

26 篇文章 1 订阅

订阅专栏

list.php

<?php
include("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或大于总页数则等于1
if($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");
?>

效果：

shareinfo2018

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
简易php博客(4)_后台显示列表

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 na
复制链接

扫一扫