//视图层
<div id="div1"> <center> <table border="1"> <tr> <td>ID</td> <td>用户名</td> <td>密码</td> </tr> @foreach($res as $val) <tr> <td><input type="checkbox" name="box[]" value="{{$val->id}}"/>{{$val->id}}</td> <td>{{$val->username}}</td> <td>{{$val->pwd}}</td> </tr> @endforeach </table> <button οnclick="quan()">全选</button> <button οnclick="fan()">反选</button> <button οnclick="clea()">取消全选</button> <button οnclick="del()">删除</button> </center></div> {{--<script src="jquery-1.7.2.min.js"></script>--}} <script> //全选 function quan(){ // alert(123); var box=document.getElementsByName('box[]'); //alert(box[0].value); for(var i=0;i<box.length;i++){ // alert(box[i].value) box[i].checked=true; } } //反选 function fan(){ // alert(123); var box=document.getElementsByName('box[]'); //alert(box[0].value); for(var i=0;i<box.length;i++){ if(box[i].checked==true){ box[i].checked=false; }else{ box[i].checked=true; } } } //单删 function clea(){ // alert(123); var box=document.getElementsByName('box[]'); //alert(box[0].value); for(var i=0;i<box.length;i++){ // alert(box[i].value) box[i].checked=false; } } //批删 function del(){ var box=document.getElementsByName('box[]'); var str=''; for(var i=0;i<box.length;i++){ if(box[i].checked==true){ str=str+','+box[i].value } } var rest = str.substr(1); //alert(rest) ajax=new XMLHttpRequest(); ajax.open("get",'{{url('index.php/del')}}?id='+rest); ajax.send(); ajax.onreadystatechange=function(){ if(ajax.readyState==4&&ajax.status==200){ document.getElementById('div1').innerHTML=ajax.responseText; } } } </script>//控制器
namespace App\Http\Controllers; use App\User; use App\Http\Controllers\Controller; use DB; use Symfony\Component\HttpFoundation\Request; //use Illuminate\Http\Request; header('content-type:text/html;charset=utf8'); class UserController extends Controller { /** * 为指定用户显示详情 * * @param int $id * @return Response */ //跳转添加页面方法 public function index() { return Redirect('show'); } //执行添加 public function add(Request $request){ $username=$request->input('username'); $pwd=$request->input('pwd'); $res= DB::table('user')->insert([ 'username' =>$username, 'pwd' =>$pwd, ]); if($res){ return Redirect('show'); } else{ die('添加失败'); } } //展示 public function show(){ $arr=DB::table('users')->get(); // print_r($arr);die; return view('user/show',['res'=>$arr]); } //批删 public function del(Request $request){ $id=$request->input('id'); $str= explode(",",$id); //print_r($str); foreach($str as $id){ $res=DB::table('users')->where('id',$id)->delete(); } //echo 1; if($res==1){ return redirect('show'); // echo 1; } } }