permisi master , saya mau tanya bagaimana menampilkan seluruh record tabel pada checkbox menggunakan perulangan foreach?? disini yang keluar hanya isi record tabel data terakhirnya saja
ini script controller nya
<?php
class HelloController extends Controller
{
public function actionIndex() {
$sql = 'select * from soalalumni';
$row = Yii::app()->db->createCommand($sql)->queryAll();
$jumlah = count($row);
$dataProvider = new CSqlDataProvider($sql, array(
'totalItemCount' => $jumlah,
'keyField' => 'idsoal',
//'params'=> array(':'=>$->),
));
$sql1 = 'select * from pilihanjawaban';
$row1 = Yii::app()->db->createCommand($sql1)->queryAll();
$jumlah1 = count($row1);
$dataProvider1 = new CSqlDataProvider($sql1, array(
'totalItemCount' => $jumlah1,
'keyField' => 'idpilihan',
));
//print_r($row);
//exit;
//}
$this->render('isikuesioneralumni', array(
'dataProvider' => $dataProvider,
'dataProvider1' => $dataProvider1,
));
}
}
dan ini script view nya
<body>
<div align="center">
<p>KUESIONER ALUMNI</p>
<table class="table-condensed table-bordered">
<thead>
<tr>
<th>NO</th>
<th>Pertanyaan</th>
<th colspan="4">Jawaban</th>
</tr>
</thead>
<?php
$data=$dataProvider;
$h=$data->getData();
foreach ($h as $key => $value); {
$data1=$dataProvider1;
unset($key);
$h1=$data1->getData();
foreach ($h1 as $key1 => $value1); {
unset($key1);
echo "<td width='300'>&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp <strong> ".$value['idsoal']."</strong></td>";
echo "<td width='300'>&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp <strong> ".$value['pertanyaan']."</strong></td>";
echo" <td> <label><input type='checkbox' name='checkbox' value= 'pilihan'/> ".$value1['pilihan']."</td>";
echo"
<td><input type='reset' value='Reset'></td>
<td><input type='submit' name='submit' value='Simpan'></td>
</table>
</from>
</body>";
}}
?>
Mohon pencerahannya master