#검색
$users = DB::select('select * from users')
#인자 순서로 주기
$usersOfType = DB::select(
'select * from users where type = ?', [$type]
);
#인자 이름으로 주기
$usersOfType = DB::select(
'select * from users where type = :type',
['type' => $userType]
);
# insert()
DB::insert(
'insert into contacts(name, email) values(?, ?)',
['sally', '[email protected]']
);
#update()
$countUpdated = DB::update(
'update contacts set status = ? where id = ?',
['donor', $id]
);
#delete()
$countDeleted = DB::delete(
'delete from contacts where archived = ?',
[true]
);