Yii - Highcharts

Yii 1.1 General Discussion
1

I’m using the Yii Highcharts extension, i can show X’s values but cannot show the Y’s values. My Highchart widget code is:




$user = Yii::app()->user->id ;

	$xAxis =  Yii::app()->db->createCommand()

			    ->select('data')

			    ->from('teste')

			    ->where('Utilizador_idUtilizador=:ut', array( ':ut'=>$user))    

			    ->queryColumn();


$yAxis =  Yii::app()->db->createCommand()

			    ->select('racio')

			    ->from('teste')

			    ->where('Utilizador_idUtilizador=:ut', array( ':ut'=>$user))    

			    ->queryColumn);



 $this->Widget('ext.highcharts.HighchartsWidget',array(

            'options' =>array(    			           

                'title' => array('text' => 'Progressão'),

                'xAxis' => array(

                    'categories' => $xAxis,                  

                ),

                'yAxis' => array(

                    'title' => array('text' => 'valor'),                	   

                ),

                'series' => array(

                    array('name'   => 'Racio','data'   => $yAxis,'shadow' => false,

                    )

                )

            )        

    ));

print_r($yAxis);

When i print_r($yAxis) it shows : Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 1 [5] => 0 [6] => 1 [7] => 1 )

if i use a static array: $yAxis = array(1,2,3,4,1,0,1,1); it works and When i print_r($yAxis) it shows : Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 1 [5] => 0 [6] => 1 [7] => 1 ) , its the same array ! why the dynamic array doesn’t work ?

Can anyone help me ? Thank you for your time.

2

to me this works:




$yAxis = array(1,2,3,4,1,0,1,1); 

$xAxis=array('data0', 'data1', 'data2','data3','data4','data5','data6','data7');


$this->Widget('ext.highcharts.HighchartsWidget',array(

		'options' =>array(                                     

			'title' => array('text' => 'Progressão'),

			'xAxis' => array('categories' =>$xAxis ),

			'yAxis' => array(

				'title' => array('text' => 'valor'),                           

			),

			'series' => array(

				array('name'   => 'Racio','data'   => $yAxis,'shadow' => false,

				)

			)

		)        

));

Are you sure $xAxis is ok? check it

OPs!! i have it. Sorry You are right. I’ll go to see this now

3

change it:





$yAxis =  Yii::app()->db->createCommand()

                            ->select('racio')

                            ->from('teste')

                            ->where('Utilizador_idUtilizador=:ut', array( ':ut'=>$user))    

                            ->queryColumn);




$yAxis =  Yii::app()->db->createCommand()

                            ->select('racio')

                            ->from('teste')

                            ->where('Utilizador_idUtilizador=:ut', array( ':ut'=>$user))    

                            ->queryColumn(); //---->HERE

I try it and the problem is when fields are string:

$yAxis = array(1,2,3,4,1,0,1,1); -->this works

$yAxis = array(‘1’,‘2’,‘3’,‘4’,‘1’,‘0’,‘1’,‘1’); -->this not works