ci 知识点总结

最新推荐文章于 2022-05-01 11:01:49 发布

fcjboke

最新推荐文章于 2022-05-01 11:01:49 发布

阅读量276

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/qq_35835160/article/details/52662839

版权

php 专栏收录该内容

66 篇文章 0 订阅

订阅专栏

//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;
})
}
})

//全选（按钮）
$('.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)' οnclick='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)' οnclick='ajax_page($i)'>$i</a>";
}
}
$str .= "--"."<a href='javascript:void(0)' οnclick='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");
}

//三级联动1

<select id="province">
<option>请选择省份</option>
<?php foreach($list as $v):?>
<option value="<?php echo $v['region_id']?>">
<?php echo $v['region_name']?>
</option>
<?php endforeach;?>
</select>
 
<select id="city">
<option>请选择城市</option>
</select>
 
<select id="village">
<option>请选择区县</option>
</select>

//三级联动1
$('#province').change(function(){
var pro_id = $(this).val();
$.ajax({
type: "POST",
dataType: "json",
url: "<?php echo site_url('Welcome/get_city')?>",
data: "p_id="+pro_id,
success:function(data){
var optstr = "<option>请选择城市</option>";
$.each(data,function(i,item){
optstr += "<option value='"+item.region_id+"'>"+item.region_name+"</option>";
})
$('#city').html(optstr);
$('#village').html("<option>请选择区县</option>");
}
})
})
$('#city').change(function(){
var pro_id = $(this).val();
$.ajax({
type: "POST",
dataType: "json",
url: "<?php echo site_url('Welcome/get_city')?>",
data: "p_id="+pro_id,
success:function(data){
var optstr = "<option>请选择区县</option>";
$.each(data,function(i,item){
optstr += "<option value='"+item.region_id+"'>"+item.region_name+"</option>";
})
$('#village').html(optstr);
}
})
})

//三级联动1

public function three2(){
$arr['list'] = $this->db->get_where("ecs_region","parent_id='1'")->result_array();
$this->load->view('three1',$arr);
}
public function get_city(){
$p_id = $this->input->post('p_id');
$child_city = $this->db->get_where("ecs_region","parent_id=$p_id")->result_array();
echo json_encode($child_city);
}

<select s_id=1 id="sel1">
<option>请选择国家</option>
<?php foreach($list as $v):?>
<option value="<?php echo $v['id']?>"><?php echo $v['name']?></option>
<?php endforeach;?>
</select>
 
<select s_id=2 id="sel2">
<option>请选择省份或直辖市</option>
</select>
 
<select s_id=3 id="sel3">
<option>请选择城市或地区</option>
</select>

//三级联动2
$(function(){
$('select').change(function(){
var p_id = $(this).val();
var id1 = $(this).attr('s_id');
var id2 = $('select:last').attr('s_id');
if(id1!=id2){
if(id1==1){
$(this).next().html("<option>请选择省份或直辖市</option>");
$(this).next().next().html("<option>请选择城市或地区</option>");
}else{
$(this).next().html("<option>请选择城市或地区</option>");
}
$.ajax({
type: "get",
url: "<?php echo site_url('Welcome/threes')?>",
data: "p_id="+p_id,
success: function(msg){
$('#sel'+id1).next().append(msg);
}
})
}
})
})

//三级联动2
public function three(){
$arr['list']=$this->db->get_where('region',"parent_id=0")->result_array();
$this->load->view('three',$arr);
}
public function threes(){
$id = $this->input->get('p_id');
$brr=$this->db->get_where('region',"parent_id=$id")->result_array();
$str='';
foreach($brr as $v){
$str.="<option value='".$v['id']."'>".$v['name']."</option>";
}
echo $str;
}

//无级分类+递归
public function digui(){
$crr = $this->db->get('category')->result_array();
$list['type'] = $this->nolimit($crr,0,0);
$this->load->view('list1',$list);
}
public function nolimit($crr,$p_id,$level){
static $arr = array();
foreach($crr as $v){
if($v['parent_id']==$p_id){
$v['level'] = $level;
$arr[] = $v;
$this->nolimit($crr,$v['cat_id'],$level+1);
}
}
return $arr;
}

//获取1级、2级、3级分类
public function sel_child($p_id){
$arr = $this->sel_son($p_id);
foreach($arr as $k=>$v){
$tmp = $this->sel_son($v['cat_id']);
foreach($tmp as $kk=>$vv){
$tmp2 = $this->sel_son($vv['cat_id']);
$tmp[$kk]['childs'] = $tmp2;
}
$arr[$k]['child'] = $tmp;
}
return $arr;
}
//通过ID获取所有的下级分类
public function sel_son($id){
$this->db->where("parent_id=$id");
return $this->db->get(self::$cate)->result_array();
}

//渲染展示主页模板
public function lists(){
$p_id = 0;
$brr['type'] = $this->Home_model->sel_child($p_id);
$brr['list'] = $this->db->get('goods')->result_array();
$this->load->view('Home/list.html',$brr);
}

<?php foreach($type as $v){?>
<li id="cat_1" class="">
<h3><a href=""><?php echo $v['cat_name']?></a></h3>
<?php foreach($v['child'] as $vv){?>
<dl class="clearfix">
<dt><a href=""><?php echo $vv['cat_name']?></a></dt>
<?php foreach($vv['childs'] as $vvv){?>
<a href=""><?php echo $vvv['cat_name']?></a>
<?php }?>
</dl>
<?php }?>
</li>
<?php }?>

文件上传：

$config['upload_path'] = './public/uploads/';
$config['allowed_types'] = 'gif|jpg|png';
$config['max_size'] = '1000';
$config['max_width'] = '1024';
$config['max_height'] = '768';
$this->load->library('upload',$config);
$this->upload->do_upload('u_file');
$info = $this->upload->data();
$data['u_file'] = $info['file_name'];
$flag = $this->db->insert("zhou1",$data);

<td><img id='pic' src="<?php echo base_url('public/uploads').'/'.$val['u_file']?>" alt="加载失败" width=50px; height=50px;/></td>

//图片放大放小
$('#pic').click(function(){
var size=parseInt($(this).attr('width'))+20;
var height=parseInt($(this).attr('height'))+20;
$(this).attr('width',size);
$(this).attr('height',height);
})

//缩略图

//图片处理,上传图片
$config['upload_path'] = './Public/uploads/';
$config['allowed_types'] = 'gif|jpg|png';
$config['max_size'] = '2000';
$config['max_width'] = '1024';
$config['max_height'] = '768';
$this->load->library('upload', $config);
if($this->upload->do_upload('img')){
$info=$this->upload->data();
//var_dump($info);exit;
//以原图来生成缩略图
$config1['source_image'] = './Public/uploads/'.$info['file_name'];
$config1['create_thumb'] = TRUE;
$config1['maintain_ratio'] = TRUE;
$config1['width'] = 75;
$config1['height'] = 50;
$this->load->library('image_lib', $config1);
$this->image_lib->resize();
//原图
$data['goods_img']=$info['file_name'];
//缩略图
$data['goods_thumb']=$info['raw_name'].'_thumb'.$info['file_ext'];
//接收数据
$data['goods_sn']=$this->input->post('goods_sn');
$data['goods_name']=$this->input->post('goods_name');
.
.
.
}

//接受原文件图片
$config['upload_path'] = './Public/uploads/thumb/';
$config['allowed_types'] = 'gif|jpg|png';
$config['max_size'] = '200000';
//初始化
$this->upload->initialize($config);
if($this->upload->do_upload('g_img')){
$info=$this->upload->data();
$config['source_image'] = './Public/uploads/thumb/'.$info['file_name'];
$config['create_thumb'] = TRUE;
$config['maintain_ratio'] = TRUE;
$config['width'] = 75;
$config['height'] = 50;
$this->image_lib->initialize($config);
$thumb=$this->image_lib->resize();
$goods=array();
$attr=array();
$goods['g_img']=$info['file_name'];
$goods['g_thumb']=$info['raw_name'].'_thumb'.$info['file_ext'];

验证码:

header("content-type:image/jpeg");
imagejpeg($im);
ImageDestroy($im);
return $word;

<tr>
<td><input type="text" id="codes" placeholder="请输入验证码"/></td>
<td><img src="<?php echo site_url('Welcome/check_code')?>" οnclick=this.src="<?php echo site_url('Welcome/check_code').'/'?>"+Math.random()></td>
</tr>

//验证码
public function check_code(){
$code = create_captcha();
$this->session->set_userdata('code',$code);
}

关键字 <input type="text" name="g_name" size="15" id="search_value" οnblur="search()">
<input type="button" value=" 搜索 " class="button" οnclick="search()">

//ajax的搜索
function search(){
var c_id=$('select[name=c_id]').val();
var b_id=$("select[name=b_id]").val();
var g_shangjia=$("select[name=g_shangjia]").val();
var g_name=$("#search_value").val();
$.ajax({
url:"<?php echo site_url('admin/goods/goods_search') ?>",
data:{
'c_id':c_id,
'b_id':b_id,
'g_shangjia':g_shangjia,
'g_name':g_name
},
type:'get',
success:function(msg){
$("#show_search").html(msg);
}
});
}

//ajax进行多条件搜索
public function goods_search(){
$c_id=$this->input->get('c_id');
$b_id=$this->input->get('b_id');
$g_shangjia=$this->input->get('g_shangjia');
$g_name=$this->input->get('g_name');
$array = array(
'c_id' => $c_id,
'b_id' => $b_id,
'g_shangjia' => $g_shangjia,
'g_name'=>$g_name
);
$data['list']=$this->privilege_model->db->like($array)->get('goods')->result_array();
$this->load->view('admin/goods_search.html',$data);
}