直接使用mysql语句实现数据的增删改查。
<?php
namespace App\Http\Controllers;
use Illuminate\Support\Facades\DB;
class StudentController extends Controller{
public function test1()
{
// 查询数据,返回数组
$record = DB::select('select * from student');
var_dump($record);
//在数据表中插入数据
$bool = DB::insert("insert into student(name,age) values(?,?)", ['tom', 20]);
var_dump($bool);
// 更新数据, 返回修改的行数
$num = DB::update("update Student set age=? where name=?", [20, 'tom']);
var_dump($num);
// 删除数据
$num = DB::delete('delete from Student where id>=1004');
var_dump($num);
}
}