laravel 怎么操作sql写in

2025-04-14 15:04:37
推荐回答(2个)
回答1:

{
$res = null;
//insert数据插入
//$user=array('username'=>'joy','password'=>'123456','age'=>23);
//$res = DB::table('users')->insert($user);
/*
数据查询
$res = DB::table('users')->where('username','joy')->get();
$res = DB::select('SELECT * FROM users WHERE username="joy"');
*/

回答2:

$array = array(1,2,3);

$query = DB::table(表名)->whereIn('字段名',$array)->get();

OK 啦