Menampilkan Data Array Dari Database

vient74 · April 24, 2013, 7:53am

Sore Rekan2,

Mudah2an ada yg bs bantu, sy sdg coba2 XGoogleChart cm ada mslh saat merender data dari database, untuk cth script bs di lihat di :

http://www.eha.ee/labs/yiiplay/index.php/en/site/extension?view=charts

cth script :

$this->widget(‘ext.widgets.google.XGoogleChart’,array(

'type'=&gt;'pie',


'title'=&gt;'Browser market 2008',


'data'=&gt;array('IE7'=&gt;22,'IE6'=&gt;30.7,'IE5'=&gt;1.7,'Firefox'=&gt;36.5,'Mozilla'=&gt;1.1,'Safari'=&gt;2,'Opera'=&gt;1.4),


'size'=&gt;array(400,300), // width and height of the chart image


'color'=&gt;array('6f8a09', '3285ce','dddddd'), // if there are fewer color than slices, then colors are interpolated.

));

sy ingin mengganti nilai script di bwh diambil dari database

…

‘data’=>array(‘IE7’=>22,‘IE6’=>30.7,‘IE5’=>1.7,‘Firefox’=>36.5,‘Mozilla’=>1.1,‘Safari’=>2,‘Opera’=>1.4),

…

sy sdh coba sperti ini :

…

$items=array();

foreach($data as $i)

{

$items1=$i[‘stk_akhir’];

$items2=$i[‘brg_nama’];

$items[]=array($items1 => $items2);

}

$this->widget(‘application.extensions.XGoogleChart’,array(

'type'=&gt;'pie',


'title'=&gt;'Persedian Barang',


[b]'data'=&gt;&#036;items,[/b]


'size'=&gt;array(400,300), // width and height of the chart image


'color'=&gt;array('6f8a09', '3285ce','dddddd'), // if there are fewer color than slices, then colors are interpolated.

));

… tapi chart nya tidak muncul, sdh cb googling tp blm ketemu solusinya, mudah2an reka2 ada yg bs bantu

Terimas kasih