語法 | int delete(string $query, array $bindings = array()) |
---|---|
參數(shù) |
|
Returns | int |
Description |
在數(shù)據(jù)庫運(yùn)行一個(gè)delete語句。
|
php artisan make:controller StudDeleteController
第3步 - 將以下代碼復(fù)制到文件 app/Http/Controllers/StudDeleteController.php
app/Http/Controllers/StudDeleteController.php
<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use DB; use App\Http\Requests; use App\Http\Controllers\Controller; class StudDeleteController extends Controller { public function index(){ $users = DB::select('select * from student'); return view('stud_delete_view',['users'=>$users]); } public function destroy($id) { DB::delete('delete from student where id = ?',[$id]); echo "刪除記錄成功.<br/>"; echo '<a href="/delete-records">點(diǎn)擊這里</a> 返回.'; } }
resources/views/stud_delete_view.blade.php
<html> <head> <title>查看學(xué)生記錄</title> </head> <body> <table border = "1"> <tr> <td>編號(hào)ID</td> <td>名字</td> <td>操作</td> </tr> @foreach ($users as $user) <tr> <td>{{ $user->id }}</td> <td>{{ $user->name }}</td> <td><a href = 'delete/{{ $user->id }}'>刪除</a></td> </tr> @endforeach </table> </body> </html>
app/Http/routes.php
Route::get('delete-records','StudDeleteController@index'); Route::get('delete/{id}','StudDeleteController@destroy');
第7步 - 點(diǎn)擊刪除鏈接執(zhí)行刪除數(shù)據(jù)庫中的記錄(刪除編號(hào)為 3 的記錄)。您將被重定向到一個(gè)頁面,會(huì)看到一條消息,如下面圖中所示。