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?