lundi 30 mai 2022

Data repeat for eloquent query in Laravel 8

$data = EmpData::leftJoin('states', 'states.id', 'emp_data.empState')
        ->leftJoin('districts', 'districts.id', 'emp_data.empDistrict')
        ->selectRaw('emp_data.*, states.name as stateName')
        ->selectRaw('emp_data.*, districts.name as districtName')
        ->paginate(30); 

In my model 'EmpData' I contain state id and district id, and the 'state' & 'district' table includes the name of the state or district. so I use left join. Data fetch correctly, but it returns 4 times data, how can I fix it.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire