Foreach

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() {

&#036;sql = 'select * from soalalumni'; 





    &#036;row = Yii::app()-&gt;db-&gt;createCommand(&#036;sql)-&gt;queryAll();


    &#036;jumlah = count(&#036;row);


    &#036;dataProvider = new CSqlDataProvider(&#036;sql, array(


        'totalItemCount' =&gt; &#036;jumlah,


        'keyField' =&gt; 'idsoal',


            //'params'=&gt; array(':'=&gt;&#036;-&gt;),


    ));


&#036;sql1 = 'select * from pilihanjawaban'; 





    &#036;row1 = Yii::app()-&gt;db-&gt;createCommand(&#036;sql1)-&gt;queryAll();


    &#036;jumlah1 = count(&#036;row1);


    &#036;dataProvider1 = new CSqlDataProvider(&#036;sql1, array(


        'totalItemCount' =&gt; &#036;jumlah1,


        'keyField' =&gt; 'idpilihan',


    


            ));


    //print_r(&#036;row);


    //exit;

//}

    &#036;this-&gt;render('isikuesioneralumni', array(


        'dataProvider' =&gt; &#036;dataProvider,


        'dataProvider1' =&gt; &#036;dataProvider1,


        


    ));


}

}

dan ini script view nya

<body>

<div align="center">

<p>KUESIONER ALUMNI</p>

<table class="table-condensed table-bordered">

&lt;thead&gt;


  &lt;tr&gt;


    &lt;th&gt;NO&lt;/th&gt;


    &lt;th&gt;Pertanyaan&lt;/th&gt;


    &lt;th colspan=&quot;4&quot;&gt;Jawaban&lt;/th&gt;


  &lt;/tr&gt;


&lt;/thead&gt;

<?php

$data=$dataProvider;

   &#036;h=&#036;data-&gt;getData();


   foreach (&#036;h as &#036;key =&gt; &#036;value); {


        &#036;data1=&#036;dataProvider1;


        unset(&#036;key);


   &#036;h1=&#036;data1-&gt;getData();


          foreach (&#036;h1 as &#036;key1 =&gt; &#036;value1); {


          unset(&#036;key1);














  echo &quot;&lt;td width='300'&gt;&amp;nbsp &amp;nbsp &amp;nbsp &amp;nbsp &amp;nbsp &amp;nbsp &amp;nbsp &lt;strong&gt; &quot;.&#036;value['idsoal'].&quot;&lt;/strong&gt;&lt;/td&gt;&quot;;


  echo &quot;&lt;td width='300'&gt;&amp;nbsp &amp;nbsp &amp;nbsp &amp;nbsp &amp;nbsp &amp;nbsp &amp;nbsp &lt;strong&gt; &quot;.&#036;value['pertanyaan'].&quot;&lt;/strong&gt;&lt;/td&gt;&quot;;


   


   





 echo&quot; &lt;td&gt; &lt;label&gt;&lt;input type='checkbox' name='checkbox' value= 'pilihan'/&gt; &quot;.&#036;value1['pilihan'].&quot;&lt;/td&gt;&quot;;





 





 echo&quot; 





&lt;td&gt;&lt;input type='reset' value='Reset'&gt;&lt;/td&gt;


&lt;td&gt;&lt;input type='submit' name='submit' value='Simpan'&gt;&lt;/td&gt;

</table>

</from>

</body>";

  }}

?>

Mohon pencerahannya master

kenapa tidak dibuat yang simple aja…? :)