操作数据库

//语句传参数
$users = DB::select('select * from hk_admin where id = ?', [$id]);

//处理事务
DB::transaction(function () {
DB::table('hk_admin')->update(['password' => 1]);

//DB::table('hk_admin')->delete();
});

//所有的数据列
$users = DB::table('hk_admin')->get();

//获取一列的值
$users = DB::table('hk_admin')->pluck('real_name');

$users = DB::table('hk_admin')
->whereIn('id', [1, 2, 3])
->get();

$users = DB::table('hk_admin')
->whereColumn([
['real_name', '=', 'last_name'],
['create_time', '>', 'created_at']
])->get();

//添加返回ID
$id = DB::table('users')->insertGetId(
['email' => 'john@example.com', 'real_name' => "zg"]
);