public function index()
{
//接收搜索数据
$name = input('title');
$type_id = input('type_id');
$Bbs = Db::name('post p')
->join('user u','p.user_id=u.id','left')
->join('post_type t','p.type_id=t.id')
->field('p.*,u.user_name,t.name')
->whereLike('title',"%" . $name . "%")
->whereLike('type_id',"%" . $type_id . "%")
->order("id desc")
->paginate(3);
$type = Db::name('post_type')->where(['available'=>1])->select();
$this->assign('type_list',$type);
$this -> assign('list',$Bbs);
return $this->fetch();
}
html
<div class="v_bd">
<div class="v_bd_tag">
<span> 标题搜索:
<input id="title" name="title" class="edit_input" value="{:input('title')}" placeholder="帖子标题" type="text"/>
<a href="javascript:;" onClick="searchs();" class="btn btn-success">提交</a>
</span>
<p style='float:right;margin-top:4px;'>
<a href="{:url('post_add?nav=添加帖子')}" class="btn btn-success">发布帖子</a>
</p>
<span> 分类:</span>
<div class="select_style">
<select name="type_id" style="height:28.8px;line-height:28.8px;padding-left:10px;width: 85px;" id="type_f">
<option value="0">请选择</option>
{foreach $type_list as $v}
<option value="{$v.id}">{$v.name}</option>
{/foreach}
</select>
</div>
</div>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="table">
<tr class="hd">
<td width="5%">ID</td>
<td width="10%">用户</td>
<td width="10%">分类</td>
<td width="10%">标题</td>
<td width="10%">发布时间</td>
<td width="10%">点赞</td>
<td width="10%">评论</td>
<td width="10%">浏览量</td>
<td>操作</td>
</tr>
{foreach $list as $item}
<tr>
<td>{$item.id}</td>
{if condition ="$item['is_user'] eq 0"}
<td>{$item.user_name}</td>
{else /}
<td>官方</td>
{/if}
<td>{$item.name}</td>
<td>{$item.title}</td>
<td>{$item.addtime|date="Y-m-d H:i:s",###}</td>
<td>{$item.gives}</td>
<td>{$item.comments}</td>
<td>{$item.looks}</td>
<td>
<a href="{:url("post_edit?id=$item[id]&nav=编辑帖子")}" class="v_icon_btn iconfont icon-bianji" title="编辑"></a>
<a href="javascript:;" class="v_icon_btn iconfont icon-del" onclick="onexinxi_del({$item['id']});" title="删除"></a></td>
</td>
</tr>
{/foreach}
</table>
<div class="lgb_loading"><p id="lgb">Loading...</p></div>
{load href="/static/manage/pic_enlarge/dist/zoomify.min.js"}
</div>
{$list->render()}
js
//分类
$('#type_f').change(function () {
var is_type = $('#type_f').val();
var url = '{:url("index")}?type_id=' + is_type;
window.location.href = url;
})
function onexinxi_del(id) {
if (!confirm("确定要删除这条信息吗?")) {
return false;
}
var url = "{:url('post_delete')}";
$.ajax({
url: url,
data: "id=" + id,
type: 'post',
success: function (txt) {
if (txt.code == 200) {
window.location.href = '{:url("index")}';
tishi('success', txt.msg);
} else {
tishi('error', txt.msg);
}
}
})
}
function searchs() {
var title = $('#title').val();
var url = '{:url("index")}?title=' + title
window.location.href = url;
}