Introducing the advanced usage of where in Laravel

The following tutorial column will introduce to you the advanced usage of where in Laravel. I hope it will be helpful to friends in need!

• $username = '';// 收货人姓名
  $hospital_id = ''; // 医院id
  # 判断是否有姓名搜索
  if (!empty($request->username)) {
      $username = $request->username;
  }
  # 判断是否有医院搜索
  if (!empty($request->hospital_id)) {
      $hospital_id = $request->hospital_id;
  }
  # 执行
  $data = DB::table('test')
  ->where(function($query)use($username){
  	# 进行判断
      if (!empty($username)) {
          $query->where('username','Like',"%$username%");
      }
  })
  ->where(function($query)use($hospital_id){
  	# 进行判断
      if (!empty($hospital_id)) {
          $query->where('hospital_id','=',$hospital_id);
      }
  })
  ->get()
  ->toArray();
  dd($data)

  Copy after login
• Recommendation:
The latest five Laravel video tutorials

The above is the detailed content of Introducing the advanced usage of where in Laravel. For more information, please follow other related articles on the PHP Chinese website!