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>
laravel 5.2 简单的增删该查
最新推荐文章于 2024-04-09 12:24:47 发布