CI框架(ajax分页,全选,反选,不选,批量删除)完整代码详解
author:一佰互联 2019-04-26   click:174

CodeIgniter 是一个小巧但功能强大的 PHP 框架,作为一个简单而“优雅”的工具包,它可以为开发者们建立功能完善的 Web 应用程序。是比较主流的一个PHP框架。

下面给大家介绍CI框架(ajax分页,全选,反选,不选,批量删除)完整代码,具体代码如下所示:

//ajax分页+搜索(视图层)
function ajax_page(page){
var sou = $("#sou").val();
$.ajax({
type: "POST",
dataType: "json",
url: "<?PHP echo site_url("Welcome/ajax_page")?>",
data: "page="+page+"&sou="+sou,
success: function(data){
var str="";
str+="<table border="1" style="text-align:center">";
str+="<tr>";
str+="<td><input type="checkbox" class="quan"/></td>";
str+="<td>ID</td>";
str+="<td>用户名</td>";
str+="<td>操作</td>";
str+="</tr>";
$.each(data.list,function(i,item){
if(item.state==0){
var locks = "<a href="JavaScript:void(0)" class="lok" fla=""+item.id+"" id="lock"+item.id+"">未锁定</a>"
}else{
var locks = "<a href="javascript:void(0)" class="lok" fla=""+item.id+"" id="lock"+item.id+"">锁定</a>"
}
str+="<tr id="av"+item.id+"">";
str+="<td><input type="checkbox" class="ss" value=""+item.id+""/></td>";
str+="<td>"+item.id+"</td>";
str+="<td>"+item.name+"</td>";
str+="<td>"+locks+"</td>";
str+="</tr>";
})
str+="<tr>";
str+="<td><input type="button" id="pdel" value="批量删除"></td>"
str+="</tr>";
str+="</table>";
str+=data.pagestr;
$("#content").html(str);
}
})
}
//状态切换
$(document).on("click",".lok",function(){
var id = $(this).attr("fla");
$.ajax({
type: "POST",
url: "<?php echo site_url("Welcome/upds")?>",
data: "id="+id,
success: function(msg){
if(msg==1){
$("#lock"+id).html("锁定");
}else{
$("#lock"+id).html("未锁定");
}
}
})
})
//批量删除
$(document).on("click","#pdel",function(){
var ids = $(".ss");
var str="";
$.each(ids,function(i,item){
if(ids[i].checked==true){
str=str+","+ids[i].value;
}
})
var new_str=str.substr(1);
$.ajax({
type: "POST",
url: "<?php echo site_url("Welcome/pdels")?>",
data: "new_str="+new_str,
success: function(msg){
$.each(ids,function(i,item){
if(ids[i].checked==true){
$("#av"+ids[i].value).remove();
}
})
}
})
})
//全选(复选框)
$(document).on("click",".quan",function(){
var obj = $(":checkbox");
var ids = $(".ss");
if(obj[0].checked==true){
$.each(ids,function(i,item){
ids[i].checked=true;
})
}else{
$.each(ids,function(i,item){
ids[i].checked=false;
})
}
})
<td><input type="checkbox" class="checks" value="<?php echo $val["u_id"]?>"/></td>
//全选(按钮)
$(".quan").click(function(){
var ids = $("input:checkbox");
$.each(ids,function(i,item){
ids[i].checked=true;
})
})
//全不选
$(".bu").click(function(){
var ids = $("input:checkbox");
$.each(ids,function(i,item){
ids[i].checked=false;
})
})
//反选
$(".fan").click(function(){
var ids = $(".checks");
$.each(ids,function(i,item){
ids[i].checked=!ids[i].checked;
})
})
//即点即改
$(document).on("click",".ss",function(){
var id = $(this).attr("id");
var con = $(this).text();
$(this).parent().html("<input type="text" id=""+id+"" class="aa" value=""+con+"">");
$(".aa").val("").focus().val(con);
$(document).on("blur",".aa",function(){
var id = $(this).attr("id");
var cons = $(this).val();
$(this).parent().html("<span id=""+id+"" class="ss">"+cons+"</span>");
$.ajax({
type: "POST",
url: "<?php echo site_url("Welcome/upd_ji")?>",
data: "id="+id+"&cons="+cons
})
})
})
//导出
$(document).on("click","#chu",function(){
var sou = $("#sou").val();
location.href="<?php echo site_url("excel/export")?>?sou="+sou;
})
//ajax分页(控制层)
public function ajax_page(){
$sou = $this->input->post("sou");
$count = $this->db->where("name like "%$sou%"")->count_all_results("peng");
$number = 3;
$this->session->set_userdata("number",$number);
$pagecount = ceil($count/$number);
@$page = $_POST["page"]?$_POST["page"]:1;
$this->session->set_userdata("page",$page);
$start = ($page-1)*$number;
$arr["list"] = $this->db->where("name like "%$sou%"")->limit($number,$start)->get("peng")->result_array();
$up_page = $page-1<1?1:$page-1;
$down_page = $page+1>$pagecount?$pagecount:$page+1;
$str = "";
$str .= "<a href="javascript:void(0)" onclick="ajax_page($up_page)">上一页</a>";
for($i=1;$i<=$pagecount;$i++){
if($i==$page){
$str .= "--"."<b>$i</b>";
}else{
$str .= "--"."<a href="javascript:void(0)" onclick="ajax_page($i)">$i</a>";
}
}
$str .= "--"."<a href="javascript:void(0)" onclick="ajax_page($down_page)">下一页</a>";
$arr["pagestr"] = $str;
echo json_encode($arr);
}
//状态切换
public function upds(){
$id = $this->input->post("id");
$arr = $this->db->get_where("peng","id="$id"")->row_array();
if($arr["state"]==0){
$data["state"]=1;
$this->db->where("id="$id"")->update("peng",$data);
echo "1";
}else{
$data["state"]=0;
$this->db->where("id="$id"")->update("peng",$data);
echo "2";
}
}
//批量删除
public function pdels(){
$str = $this->input->post("new_str");
$this->db->where("id in($str)")->delete("peng");
}

以上所述是小编给大家介绍的CI框架(ajax分页,全选,反选,不选,批量删除)完整代码详解,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对网页设计网站的支持!