php - 如何在laravel中使用多个键和值从数据库中查询数据？

Question

我已经尝试过，但它返回空数组。

    $arr = [];
    foreach($request->spec_id as $key=>$id){
        $arr[$id] = $request->spec[$key];
    }

    $arr = array_filter($arr);

    Ex: $arr = [
                6 => "2000",
                9 => "Petrol"
               ];

    $data = DB::table('categories as c')
        ->join('postads as p','c.id','p.category_id')
        ->join('postad_specifications as ps','p.id','ps.postad_id')
        ->join('specifications as s','ps.specification_id','s.id')
        ->where('p.category_id',$request->category_id)
        ->where(function($query) use($arr){
            foreach($arr as $key=>$value){
            $query->where('ps.specification_id',$key);
            $query->where('ps.value',$value);
            }
        })
        ->select('p.id','p.ad_title')
        ->distinct()
        ->get();

我想要的结果来自 postads 表，其中 ps.specation_id 和 ps.value 与键和值匹配。我该如何解决这个问题？

Answer 1

您可以使用 array_keys、array_values 函数，并在 Laravel 中使用 whereIn

    $arr = [];
    foreach($request->spec_id as $key=>$id){
        $arr[$id] = $request->spec[$key];
    }

    $arr = array_filter($arr);

    Ex: $arr = [
                6 => "2000",
                9 => "Petrol"
               ];

    $arrKeys = array_keys($arr);
    $arrValues = array_values($arr);

    $data = DB::table('categories as c')
        ->join('postads as p','c.id','p.category_id')
        ->join('postad_specifications as ps','p.id','ps.postad_id')
        ->join('specifications as s','ps.specification_id','s.id')
        ->where('p.category_id',$request->category_id)
        ->whereIn('ps.specification_id', $arrKeys)
        ->whereIn('ps.value', $arrValues)
        ->select('p.id','p.ad_title')
        ->distinct()
        ->get();