laravel mysql增删改查_laravel 增删改查

路由

Route::get('/mysql', 'MysqlController@index');

Route::get('/mysql/add', 'MysqlController@add');

Route::post('/mysql/insert', 'MysqlController@insert');

Route::get('/mysql/edit/{id}', 'MysqlController@edit')->where('id', '[0-9]+');

Route::post('/mysql/update', 'MysqlController@update');

Route::get('/mysql/delete/{id}', 'MysqlController@delete')->where('id', '[0-9]+');

MysqlController.php

namespace App\Http\Controllers;

use App\User;

use App\Mysql;

use Illuminate\Http\Request;

use Illuminate\Support\Facades\DB;

class MysqlController extends Controller

{

public function index(Request $sou){

$mysql = DB::table('mysql')->where('name','like','%'.$sou->sou."%")->paginate(3);

return view('mysql.index', ['mysql' => $mysql]);

}

public function add(Request $request){

return view('mysql.create');

}

public function insert(Request $request){

$res = DB::insert("INSERT INTO mysql(`name`,`pwd`,`age`,`sex`,`tel`) values('$request->name','$pwd','$request->age','$request->sex','$request->tel')");

if ($res) {

return redirect('/mysql');

}

}

public function delete($id){

DB::table('mysql')->where('id','=',$id)->delete();

return redirect('/mysql');

}

public function edit($id){

$data = DB::table('mysql')->find($id);

return view('mysql.edit',['data'=>$data]);

}

public function update(Request $request){

$res = DB::table('mysql')->where('id','=',$request->id)->update(['name'=>$request->name,'pwd'=>md5($request->pwd),'age'=>$request->age,'sex'=>$request->sex,'tel'=>$request->tel]);

if($res){

return redirect('/mysql');

}

}

}

?>

mysql/create.blade.php

无标题文档

@csrf

姓名

密码

年龄

性别

电话

mysql/edit.blade.php

无标题文档

@csrf

姓名

密码

年龄

性别

手机号

index.blade.php

ID

姓名

密码

年龄

性别

电话

操作

操作

操作

@foreach($mysql as $key=>$value)

{{$value->id}}{{$value->name}}{{$value->pwd}}{{$value->age}}{{$value->sex}}{{$value->tel}} 添加 删除 编辑

@endforeach

{{ $mysql->links() }}