DB façade 方式

配置访问路由

routes/web.php文件中配置

Route::any('FacadesTest', ['uses' => 'StudentController@FacadesTest']);

控制器

文件示例App\Http\Controllers\StudentController

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\DB;
class StudentController extends Controller
{

    public function FacadesTest()
    {
        // 新增
       $bool = DB::insert('insert into student(name, age) values(?, ?)',
           ['imooc', 19]);
       var_dump($bool);

        // 更新
       $num = DB::update('update student set age = ? where name = ?',
           [20, 'sean']);
       var_dump($num);

        // 查询
       $students = DB::select('select * from student where id > ?',
           [1001]);
       dd($students);

        // 删除
        $num = DB::delete('delete from student where id > ?', [1001]);
        var_dump($num);

    }
}

Last updated

Was this helpful?