如何在laravel 5.2中传递联接数组以选择查询 [英] how to pass array of joins to select query in laravel 5.2

问题描述

我正在尝试从多个表中获取数据.我已将join语句存储在$ Joins数组中，并将该数组传递给model
这是我到目前为止尝试过的-

I am trying to fetch data from multiple tables. I have stored join statements in a $Joins array and passed that array to model
Here is what I tried so far -

$tbl_name="user_master";
$select= ['user_master.*', 'country.country_name', 'city.city_name', 'login_master.email_id', 'login_master.password'];
$joins=[
         "'country', 'user_master.country_id', '=', 'country.country_id'",
         "'city', 'user_master.city_id', '=', 'city.city_id'",
         "'login_master', 'user_master.user_id', '=', 'login_master.user_id'"
       ]; 
$users=$obj->getdata($tbl_name,$select,$joins);  

模型-

public function getdata($tbl_name,$select,$joins)
    {
        $users = DB::table($tbl_name)
                ->join($joins)
                ->select($select)
                ->paginate(5);

                return $users;
    }  

我正在尝试传递$ joins数组进行查询，但显示错误-
缺少Illuminate \ Database \ Query \ Builder :: join()的参数2，该参数在第61行的/opt/lampp/htdocs/demo_laravel/app/Models/Userdata.php中调用并已定义

I am trying to pass $joins array to query but it showing error -
Missing argument 2 for Illuminate\Database\Query\Builder::join(), called in /opt/lampp/htdocs/demo_laravel/app/Models/Userdata.php on line 61 and defined

如果我尝试--

$users = DB::table($tbl_name)
                ->join('country', 'user_master.country_id', '=', 'country.country_id')
                ->join('city', 'user_master.city_id', '=', 'city.city_id')
                ->join('login_master', 'user_master.user_id', '=', 'login_master.user_id')
                ->select($select)
                ->paginate(5);

                return $users;  

它工作正常，但是当我将数组传递给联接时显示错误.
如何解决?
请帮助我.

It is working fine but when I pass array to joins it shows error.
How to solve it?
Please help me.

推荐答案

尝试一下:

$joins的格式:

$joins = [
    ['country', 'user_master.country_id', '=', 'country.country_id'],
    ['city', 'user_master.city_id', '=', 'city.city_id'],
    ['login_master', 'user_master.user_id', '=', 'login_master.user_id'],
];

和型号:

public function getdata($tbl_name, $select, $joins)
{
    $users = DB::table($tbl_name);

    foreach ($joins as $join) {
        $users = $users->join(...$join);
    }

    $users = $users
        ->select($select)
        ->paginate(5);

    return $users;
}

这篇关于如何在laravel 5.2中传递联接数组以选择查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！