Here I want to add the data I have based id_data kos
, so whenever I add data will auto count by id_data_kos
.
here my controller :
$limit = 10;
$result = DB::table('residents')
->join("data_kos","data_kos.id","=","residents.id_data_kos")
->select("residents.*","data_kos.title as data_title")
->groupBy('id_data_kos')
->orderBy('residents.id', 'asc');
$data['posts'] = $result->paginate($limit);
and this my view :
@foreach($posts as $row)
<td></td>
<td>here i want to count</td>
@endforeach
this my table :
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire