phpcms文章发表之列表显示

来源：互联网发布：移动端底部广告js 编辑：程序博客网时间：2024/06/06 10:50

在model文件夹下建立所需要的model

appear_model.class.php

reply_model.class.php

如：

appear_model.class.php<?php//这个文件只需要修改表名，和类名defined('IN_PHPCMS') or exit('No permission resources.');pc_base::load_sys_class('model', '', 0);class appear_model extends model {    public function __construct() {        $this->db_config = pc_base::load_config('database');        $this->db_setting = 'default';        $this->table_name = 'appear';//表名        parent::__construct();    }}?>以此类推。。。。。

modules下新建文件

function init(){        //调用model下的appear_model.class.php        $this->appear = pc_base::load_model('appear_model');        $page = isset($_GET['page']) && intval($_GET['page']) ? intval($_GET['page']) : 1;        //查询appear表里的所有数据        $list = $this->appear->listinfo('','id desc', $page, 20);        //调用分页        $pages = $this->appear->pages;        //引入模板        include template('appear', 'list');    }

templates下的文件

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><title>留言板列表</title><meta name="Generator" content="EditPlus"><meta name="Author" content=""><meta name="Keywords" content=""><meta name="Description" content=""></head><body><table style="border:solid 1px #333"><tr><td>标题</td><td>内容</td><td>姓名</td><td>时间</td><td>操作</td></tr><?php foreach($list as $v){?><tr><td style="border:solid 1px #333"><?php echo $v['title']?></td><td style="border:solid 1px #333"><?php echo $v['des']?></td><td style="border:solid 1px #333"><?php echo $v['username']?></td><td style="border:solid 1px #333"><?php echo date('Y-m-d H:i:s',$v['dataline'])?></td><td style="border:solid 1px #333"><a href="./index.php?m=appear&c=appear&a=add_ye">添加</a> <a href="./index.php?m=appear&c=appear&a=add_ye&id=<?php echo $v['id']?>">编辑</a> <a href="javascript:void(0);" onclick="del('<?php echo $v['id']?>')">删除</a><a href="./index.php?m=appear&c=appear&a=detail&id=<?php echo $v['id']?>">查看</a></td></tr><?php }?></table><div id="pages"><?php echo $pages?></div></body><script src="{JS_PATH}/jquery.min.js"></script><script>function del(id){if(confirm("是否将此留言信息删除?")){$.ajax({type:'post',data:'id='+id,url:'./index.php?m=appear&c=appear&a=del',success:function(data){if(data == 1){window.location.href='./index.php?m=appear&c=appear';}else{alert('2');}}});}}</script></html>