I would like to display product number, product name and procut detail.
I can display "product number" as below code that is ($pn) I would like to bring "product name" and "product detatil" data which only mache to ($pnum) below foreach loop.
Another table name is "pn_list". table A $pn and table B $pnum should be maches then displya table B's product name is $pname product detail is $pdetail shows up.
blade file (pn is product number)
@foreach ($pns as $pnx)
,
@endforeach
Controller
public function countpn(Request $request)
{ $pns = Tablea::select('pn', DB::raw('COUNT(pn) count'))
->groupBy('pn')
->get();
return view('pn.index')->with('pns',$pns);
}
Sorry I have no idea how to combine 2nd table and matching rule so I didn'T make code.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire