<?php
namespace App\Http\Controller;
use Illuminate\Support\Facades\DB;//使用DB类
class StudentController extends Controller{
//创建名为StudentController的控制器并继承Controller基类
public function query(){
//php
}
}
[php]
DB::select(“select * from student”);//可以直接使用select语句
DB::select(“select * from student where age = ? and name = ?”,[18,’7gugu’])//等同于:select * from student where age = 18 and name = ‘7gugu’
[/php]
插入数据
[php]
DB::insert(“insert into student(name,age,sex) values(‘hzq’,’19’,’0′)”);//可以直接使用insert语句
DB::insert(“insert into student(name,age,sex) values(?,?,?)”,[‘hzq’,’19’,’0′]);//等同于:insert into student(name,age,sex) values(‘hzq’,’19’,’0′),这样子方便传值
[/php]
更新数据
[php]
DB::update(“update student set age = 1 where name =7gugu”);//可以直接使用update语句
DB::update(“update student set age = ? where name =?”,[1,’7gugu’])//等同于:update student set age = 1 where name =’7gugu’
[/php]
删除数据
[php]
DB::delete(‘delete from student where id=1002’);//直接使用delete语句
DB::delete(‘delete from student where id=?’,[‘1002’]);//等同于:delete from student where id=1002
[/php]