以下是DaoKeCMS插件后台列表页的标准开发模板:
$page = intval2(get('page', 1));
$pageSize = 20;
$offset = ($page - 1) * $pageSize;
$total = DB::count('adslot_items', 'deleted=0');
$list = DB::rows(
'SELECT * FROM `' . DB_PREFIX . 'adslot_items` WHERE deleted=0 ORDER BY sort DESC, id DESC LIMIT ' . $pageSize . ' OFFSET ' . $offset
);
echo '| ID | 标题 | 状态 | 操作 |
|---|---|---|---|
| ' . $item['id'] . ' | '; echo '' . e($item['title']) . ' | '; echo '' . ($item['status'] ? '启用' : '停用') . ' | '; echo '编辑 | '; echo '