laravel框架之即点即改、批量删除

最新推荐文章于 2023-08-20 18:16:10 发布

X梦阳X

最新推荐文章于 2023-08-20 18:16:10 发布

阅读量798

点赞数

分类专栏： php 文章标签： php

本文链接：https://blog.csdn.net/lmy_1/article/details/52979745

版权

php 专栏收录该内容

55 篇文章 1 订阅

订阅专栏

表单页面

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>商品列表页面</title>
</head>
<body>
<center>
<a href="{{URL('add')}}"><button style="width:80px;">+</button></a>
<table border="1">
<tr>
<td><input type="checkbox" name=""></td>
<td>名称</td>
<td>价格</td>
<td>操作</td>
</tr>
@foreach($users as $k => $v)
<tr>
<tr>
<td><input type="checkbox" name="box" value="{{$v->g_id}}"></td>
<td pid="{{$v->g_id}}"><span class="name">{{$v->g_name}}</span></td>
<td pid="{{$v->g_id}}"><span class="price">{{$v->g_price}}</span></td>
<td><a href="del?g_id={{$v->g_id}}">删除</a></td>
</tr>
</tr>
@endforeach
</table>
<button class="pl">批量删除</button>
</center>
</body>
</html>

<script src="style/js/jquery-1.7.2.min.js"></script>

<script>
//即点击该
$(document).on("click", ".name", function () {
var con = $(this).html();
var pid = $(this).parent().attr('pid');
$(this).parent().html('<input type="text" value="'+con +'" class="input" pid="'+pid+'" />');
$("input").focus();
$(document).on("blur", ".input", function () {
var g_name = $(this).val();
pid = $(this).attr("pid");
$(this).parent().html('<span class="update">'+g_name +'</span>');
$.post("update",{g_name:g_name,pid:pid},function(msg){
alert(msg)
location.href="index";

})
});

});

//批量删除
$(".pl").click(function(){
var box = $("input[name='box']");
length =box.length;
//alert(length);
var str ="";
for(var i=0;i<length;i++){
if(box[i].checked==true){
str =str+","+box[i].value;
}
}
str= str.substr(1)
//alert(str)
location.href="del2?id="+str;
})
</script>

控制器页面

//即点击改修改名称
public function update(){
$g_id = input::get('pid');
$old = DB::table('goods')->where('g_id',"=","$g_id")->first();
$old_name = $old->g_name;
$g_name = input::get('g_name');
$res= DB::table('goods')->where('g_id','=',$g_id)->update(array('g_name' => $g_name));
echo 1;
}

//批量移除
public function del2(){
$g_id = input::get('id');
$str = explode(",",$g_id);
foreach($str as $v){
DB::table('goods')->where('g_id',"=","$v")->delete();
}
return redirect("index");
}