控制器方法
//显示话题
public function actionPub_list(){
//获取班级id
$c_id=yii::$app->request->get('cid');
// //实例化查询类
$query=new \yii\db\Query();
$query->select(['topiczk1.t_id','topiczk1.title','topiczk1.content','topiczk1.file','topiczk1.add_time'])
->from('topiczk1')
->leftJoin('loginzk1','topiczk1.lid=loginzk1.l_id');
$command = $query->createCommand();
$data = $command->queryAll();
//var_dump($data);die;
//分页
$pagination=new pagination(['totalCount'=>$query->count()]);
$pagination->setPageSize(2);
$data=$query->offset($pagination->offset)->limit($pagination->limit)->all();
// var_dump($data);die;
//查询数据表显示话题
// $data=yii::$app->db->createCommand("select * from topiczk1 join loginzk1 on topiczk1.lid=loginzk1.l_id")->queryAll();
return $this->render('pub_list',['data'=>$data,'pagination'=>$pagination]);
}
视图层
<?php
use yii\widgets\LinkPager;
?>
<h5><a href="?r=stud/pub">继续添加</a> <a href="?r=stud/addclass">返回空间</a></h5>
<h3 align="center">话题列表</h3>
<input type="button" class="quan" value="全选"> <input type="button" class="fan" value="反选">
<input type="button" class="pl" value="批量删除">
<center>
<table class="table">
<tr>
<td>标题</td>
<td>作者</td>
<td>图片</td>
<td>发布时间</td>
<td>操作</td>
</tr>
<?php foreach($data as $key=>$val){?>
<td><input type="checkbox" class="box" name="box" value=
"<?php echo $val['t_id']; ?>"><?=$val['title']?></td>
<td><?php echo yii::$app->session->get('username')?></td>
<td><img src="<?php echo $val['file']?>" alt="" width="150"/></td>
<td><?=$val['add_time']?></td>
<td><a href="?r=stud/pub_edit">编辑</a></td>
</tr>
<?php }?>
</table>
<?php echo LinkPager::widget([
'pagination' =>$pagination]); ?>
</center>
<script src="jquery.1.12.js"></script>
<script>
$(function(){
//全选
$(".quan").click(function(){
var box=$(".box");//获取对象
for(var i=0;i<box.length;i++){
box.eq(i).prop("checked",true);
}
})
//反选
$(".fan").click(function(){
var box=$('.box');
for(var i=0;i<box.length;i++){
if(box.eq(i).prop("checked")){
box.eq(i).prop("checked",false);
}else{
box.eq(i).prop("checked",true);
}
}
})
//批量删除
$(".pl").click(function(){
var box=$(".box");
var str="";
for(i=0;i<box.length;i++){
if(box[i].checked==true){
str=str+","+box[i].value;
}
}
var id=str.substr(1);
var url="?r=stud/del";
$.get(url,{id:id},function(msg){
alert(msg)
})
})
});
</script>