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
