简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > List of blog posts > 12月30日—laravel框架的使用原生SQL对数据库进行增删查改操作
Blogger Information
Blog 34
fans 0
comment 0
visits 22317
Special Recommendation
More>
Related recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
12月30日—laravel框架的使用原生SQL对数据库进行增删查改操作
曾龙宇
Original
926 people have browsed it

路由文件

  1. //用户添加路由
  2. Route::get('/user/add','UserController@add');
  3. Route::post('/user/store','UserController@store');
  4. Route::get('/user/index','UserController@index');
  5. Route::get('/user/edit/{id}','UserController@edit');
  6. Route::post('/user/save','UserController@save');
  7. Route::get('/user/delete/{id}','UserController@delete');

Controller文件

  1. <?php
  3. namespace App\Http\Controllers;
  5. use App\User;
  6. use Illuminate\Http\Request;
  7. use Illuminate\Support\Facades\DB;
  9. class UserController extends Controller
  10. {
  11.     public function index(){
  12.         $data = DB::select('select * from user');
  13.         return view('user.list',['data'=>$data]);
  14.     }
  15.     public function add(){
  16.         return view('user.add');
  17.     }
  19.     public function store(Request $request){
  20.         $username = $request->input('username');
  21.         $password = $request->input('pwd');
  22.         $password = md5($password);
  23.         $res = DB::insert('insert into user(`username`,`password`)values(?,?)',[$username,$password]);
  24.         if ($res){
  25.             echo json_encode(array('code'=>1,'msg'=>'添加成功'));
  26.         }else{
  27.             echo json_encode(array('code'=>0,'msg'=>'添加失败'));
  28.         }
  29.     }
  31.     public function edit($id){
  32.         $data = DB::select('select * from user where id=?',[$id]);
  34.         return view('user.edit',['data'=>$data]);
  35.     }
  37.     public function save(Request $request){
  38.         $id = $request->input('id');
  39.         $username = $request->input('username');
  40.         $password = md5($request->input('pwd'));
  41.         $res = DB::update('update user set username=?,password=? where id=?',[$username,$password,$id]);
  42.         if ($res){
  43.             echo json_encode(array('code'=>1,'msg'=>'编辑成功'));
  44.         }else{
  45.             echo json_encode(array('code'=>0,'msg'=>'编辑失败'));
  46.         }
  47.     }
  48.     public function delete($id){
  49.         $res = DB::delete('delete from user where id=?',[$id]);
  50.         if ($res){
  51.             echo '<script>alert("删除成功");window.location.href="/user/index";</script>';
  52.         }else{
  53.             echo '<script>alert("删除失败");window.reload();</script>';
  54.         }
  55.     }
  56. }

list界面

  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.     <style>
  10.         a{text-decoration: none;}
  11.     </style>
  12. </head>
  13. <body>
  14. <button><a href="/user/add">添加</a></button>
  15. <table border="1" cellpadding="4" style="border-collapse: collapse;">
  16.     <caption>展示界面</caption>
  17.     <tr>
  18.         <th>ID</th>
  19.         <th>账号</th>
  20.         <th>密码</th>
  21.         <th>操作</th>
  22.     </tr>
  23.     @foreach($data as $item)
  24.     <tr>
  25.         <td>{{$item->id}}</td>
  26.         <td>{{$item->username}}</td>
  27.         <td>{{$item->password}}</td>
  28.         <td><button><a href='/user/edit/{{$item->id}}'>编辑</a></button>&nbsp;
  29.             <button><a href='/user/delete/{{$item->id}}' onclick="if(confirm('是否删除数据？')==false)return false;">删除</a></button>
  30.         </td>
  31.     </tr>
  32.     @endforeach
  33. </table>
  34. <script>
  36. </script>
  37. </body>
  38. </html>

add界面

  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.     <script src="{{asset('js/jquery.min.js')}}"></script>
  10. </head>
  11. <body>
  12. <form action="" name="add_form">
  13.     <table border="1" cellpadding="4" style="border-collapse:collapse;">
  14.         <input type="hidden" name="_token" value="{{csrf_token()}}">
  15.         <caption>添加用户信息</caption>
  16.         <tr>
  17.             <td>账号</td>
  18.             <td><input type="text" name="username" placeholder="请输入用户名"></td>
  19.         </tr>
  20.         <tr>
  21.             <td>密码</td>
  22.             <td><input type="password" name="pwd" placeholder="请输入密码"></td>
  23.         </tr>
  24.         <tr>
  25.             <td>确认密码</td>
  26.             <td><input type="password" name="repwd" placeholder="请输入确认密码"></td>
  27.         </tr>
  28.         <tr>
  29.             <td colspan="2"><button type="button" onclick="doSave()">保存</button></td>
  30.         </tr>
  31.     </table>
  32. </form>
  33. <script>
  34.     function doSave() {
  35.         var username = $.trim($('input[name="username"]').val());
  36.         var pwd = $.trim($('input[name="pwd"]').val());
  37.         var repwd = $.trim($('input[name="repwd"]').val());
  38.         if (username==''){
  39.             alert('请输入用户名');
  40.             return;
  41.         }
  42.         if(pwd==''){
  43.             alert('请输入密码');
  44.             return;
  45.         }
  46.         if (repwd!=pwd){
  47.             alert('确认密码错误');
  48.             return;
  49.         }
  50.         $.post('/user/store',$('form[name="add_form"]').serialize(),function (res) {
  51.             if(res.code==0){
  52.                 alert(res.msg);
  53.                 return;
  54.             }else{
  55.                 alert(res.msg);
  56.                 window.location.href = '/user/index';
  57.             }
  58.         },'json');
  59.     }
  60. </script>
  61. </body>
  62. </html>

edit界面

  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.     <script src="{{asset('js/jquery.min.js')}}"></script>
  10. </head>
  11. <body>
  12. <form action="" name="add_form">
  13.     <table border="1" cellpadding="4" style="border-collapse:collapse;">
  14.         <input type="hidden" name="_token" value="{{csrf_token()}}">
  15.         @foreach ($data as $item)
  17.         <input type="hidden" name="id" value="{{$item->id}}">
  18.         <caption>编辑用户信息</caption>
  19.         <tr>
  20.             <td>账号</td>
  21.             <td><input type="text" name="username" placeholder="请输入用户名" value="{{$item->username}}"></td>
  22.         </tr>
  23.         <tr>
  24.             <td>密码</td>
  25.             <td><input type="password" name="pwd" placeholder="请输入密码"></td>
  26.         </tr>
  27.         <tr>
  28.             <td colspan="2"><button type="button" onclick="doSave()">保存</button></td>
  29.         </tr>
  30.         @endforeach
  31.     </table>
  32. </form>
  33. <script>
  34.     function doSave() {
  35.         var username = $.trim($('input[name="username"]').val());
  36.         var pwd = $.trim($('input[name="pwd"]').val());
  37.         if (username==''){
  38.             alert('请输入用户名');
  39.             return;
  40.         }
  41.         $.post('/user/save',$('form[name="add_form"]').serialize(),function (res) {
  42.             if(res.code==0){
  43.                 alert(res.msg);
  44.                 return;
  45.             }else{
  46.                 alert(res.msg);
  47.                 window.location.href = '/user/index';
  48.             }
  49.         },'json');
  50.     }
  51. </script>
  52. </body>
  53. </html>

Correcting teacher：天蓬老师天蓬老师

Correction status：qualified

Teacher's comments：不错, 继续努力
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！