laravel 5.2 简单的增删该查

来源：互联网发布：java applet程序编辑：程序博客网时间：2024/05/01 02:50
app/html首先设置下config数据库连接路由设置Route::get('/my_home','MyController@index');Route::post('add','MyController@add');//添加Route::any('show','MyController@show');//查询Route::any('del','MyController@del');//删除Route::any('up','MyController@up');//修改Route::any('update','MyController@update');//修改控制器  先调用DB类 request类namespace App\Http\Controllers;use DB;use App\Http\Requests\Request;use App\Http\Controllers\Controller;header('content-type:text/html;charset=utf8');class MyController extends Controller{    public  function index(){        return view('my_welcom');    }    //添加    public function add(){        $name=\Request::input('name');        $pass=md5(\Request::input('password'));       $re= DB::table('denglu')->insert(['name'=>$name,'password'=>$pass]);       if($re){            return redirect('show');       }    }    //查询    public function show(){     $arr=DB::table('denglu')->get();        return view('show',['arr'=>$arr]);    }    //删除    public function del(){        $id=\Request::get('id');      $re=DB::table('denglu')->where(['uid'=>$id])->delete();      if($re){          return redirect('show');      }    }    //修改    public function up(){        $id=\Request::get('id');        $arr=DB::table('denglu')->where(['uid'=>$id])->first();        return view('up',['arr'=>$arr]);    }    public function update(){        $id=\Request::input('uid');        $name=\Request::input('name');        $password=\Request::input('password');        $arr=DB::table('denglu')->where(['uid'=>$id])->update(['name'=>$name,'password'=>$password]);        if($arr){            return redirect('show');        }    }}视图层<!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>Document</title></head><body><form action="add" method="post">    <table>        <input type="hidden" name="_token" value="<?php echo csrf_token(); ?>">        <tr>            <td>用户</td>            <td><input type="text" name="name"/></td>        </tr>        <tr>            <td>密码</td>            <td><input type="password" name="password"/></td>        </tr>        <tr>            <td><input type="submit" value="提交"/></td>        </tr>    </table></form></body></html>展示页面视图  当config里面的datebase.php一个参数是 'fetch' => PDO::FETCH_class,展示的是对象，  <h2>展示页面</h2>    <table border="1">        <tr>            <td>id</td>            <td>姓名</td>            <td>密码</td>            <td>操作</td>        </tr>        @foreach($users as $v)            <tr>                <td>{{$v->c_id}}</td>                <td>{{$v->name}}</td>                <td>{{$v->password}}</td>                <td>                    <a href="del?id={{$v->c_id}}">删除</a>||                    <a href="up?id={{$v->c_id}}">修改</a>                </td>            </tr>        @endforeach    </table>当修改成 'fetch' => PDO::FETCH_ASSOC是数组 和yii一样了哈哈。<table border="1">    <tr>        <td>账号</td>        <td>密码</td>        <td>操作</td>    </tr>    <?php foreach($arr as $k=>$v){?>    <tr>        <td><?php echo $v['name'] ?></td>        <td><?php echo $v['password'] ?></td>        <td>            <a href="del?id=<?php echo $v['uid']?>">删除</a>            <a href="up?id=<?php echo $v['uid']?>">修改</a>        </td>    </tr>    <?php }?></table>修改的页面<form action="update" method="post">    <table>        <input type="hidden" name="_token" value="<?php echo csrf_token(); ?>">        <input type="hidden" name="uid" value="<?php echo $arr['uid']?>"/>        <tr>            <td>用户</td>            <td><input type="text" name="name" value="<?php echo $arr['name']?>"/></td>        </tr>        <tr>            <td>密码</td>            <td><input type="password" name="password" value="<?php echo $arr['password']?>"/></td>        </tr>        <tr>            <td><input type="submit" value="提交"/></td>        </tr>    </table></form>
0 0