Hi,
I am new to Yii. I have using CGridview in my application. I want the change in the dropdown menu should change cgridview contnents using ajax request. I done following code so far
in view index.php
echo CHtml::dropDownList(‘station_id’, ‘’, $stations,
array(
'ajax' => array(
'type'=>'POST',
'url'=>CController::createUrl('library/UpdateGrid'),
'data'=>'js:jQuery(this).serialize()',
'success'=>'function(response)
{
$.fn.yiiGridView.update("playlist-grid", {data: $(this).serialize()});
}',
)
)
);
$this->widget(‘zii.widgets.grid.CGridView’, array
(
// 'dataProvider'=>$dataProvider,
'id'=>'playlist-grid',
'columns'=>array(
array
(
'name'=>'Title',
'value'=>'$data["Title"]',
),
array
(
'name'=>'Artist',
'value'=>'$data["Artist_Name"]',
),
array
(
'header'=>'Allow Skip',
'class'=>'CCheckBoxColumn',
'checked'=>'$data["Allow_Skip"]',
),
)
)
);
in controller
public function actionUpdateGrid()
{
$sql="SELECT library_media_item.Title,library_media_item.Points,library_media_item.Allow_Skip,
artist.Artist_Name FROM library_media_item ,artist WHERE
library_media_item.Artist_ID = artist.Artist_ID";
$connection=Yii::app()->db;
$command = $connection->createCommand($sql);
$songs = $command->queryAll();
echo $songs;
}
here cgridview is not updated.