在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);" οnclick="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>