1 <!doctype html>
2 <html lang="en">
3 <head>
4 <meta charset="UTF-8">
5 <meta name="viewport"
6 content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
7 <meta http-equiv="X-UA-Compatible" content="ie=edge">
8 <title>展示頁面</title>
9 <link rel="stylesheet" href="{{asset('css/bootstrap.css')}}">
10 </head>
11 <body>
12 <center><h1>數據展示頁面</h1></center>
13 <input type="text" name="search" id="search"><input type="button" class="page" value="搜索">
14 <table class="table table-striped">
15 {{--@csrf--}}
16 <tr>
17 <td><input type="checkbox" id="check"></td>
18 <td>編號</td>
19 <td>用戶名</td>
20 <td>性別</td>
21 <td>郵箱</td>
22 <td>創建時間</td>
23 <td>修改時間</td>
24 <td>操作</td>
25 </tr>
26 <tbody id="tb">
27 @foreach($data as $key=>$val)
28 <tr id="{{$val->id}}">
29 <td><input type="checkbox" name="check" value="{{$val->id}}"></td>
30 <td>{{$val->id}}</td>
31 <td fd="username">{{$val->username}}</td>
32 @if($val->sex == 0 )
33 <td id="{{$val->id}}" class="se" fd="{{$val->sex}}">男</td>
34 @elseif($val->sex == 1)
35 <td id="{{$val->id}}" class="se" fd="{{$val->sex}}">女</td>
36 @endif
37 <td fd="email">{{$val->email}}</td>
38 <td>{{$val->created_at}}</td>
39 <td>{{$val->updated_at}}</td>
40 <td><a href="javascript:void (0)" id="{{$val->id}}" class="del">刪除</a>|<a href="update?id={{$val->id }}">編輯</a></td>
41 </tr>
42 @endforeach
43 </tbody>
44 </table>
45 <input type="hidden" name="a_page" id="a_page" value="1">
46 <input type="hidden" name="last_page" id="last_page" value="{{$end}}">
47 <a href="javascript:void (0)" class="page">首頁</a>
48 <a href="javascript:void (0)" class="page">上一頁</a>
49 <a href="javascript:void (0)" class="page">下一頁</a>
50 <a href="javascript:void (0)" class="page">尾頁</a>
51 <button class="del_all">批刪</button>
52 </body>
53 </html>
54 <script src="../js/jquery-3.3.1.min.js"></script>
55
56
57 //全選 全不選 反選
58 $(document).on("click","#check",function () {
59 var check = document.getElementsByName("check");
60 for (i=0;i<check.length;i++){
61 if (check[i].checked==false){
62 check[i].checked=true;
63 } else {
64 check[i].checked=false;
65 }
66 }
67 })
68 // ajax批量刪除
69 $(document).on("click",".del_all",function () {
70 var check = document.getElementsByName('check');
71 var str = "";
72 for (i=0;i<check.length;i++){
73 if (check[i].checked==true){
74 str +=","+check[i].value;
75 }
76 }
77 var id = str.substr(1)
78 $.ajax({
79 url:"delete_all",
80 type:"get",
81 dataType:"json",
82 data:{
83 id:id,
84 },
85 success:function (data) {
86 if (data==1){
87 alert("刪除成功")
88 }
89 }
90 })
91 })
1 public function delete_all(request $request)
2 {
3 $id = $request->get('id');
4 $str = explode(",",$id);
5 foreach ($str as $val){
6 DB::table('users')->delete($val);
7 }
8 return 1;
9 }
