Assalamualaikum
gan saya kan di controller pake sql kayak gini
public function actionTabel5122S1(){
$dataProvider=array();
//$sql = 'SELECT * FROM mata_kuliah';
$sql = ('Select * FROM mata_kuliah where kode LIKE "___1%" OR kode LIKE "___2%"
OR kode LIKE "___3%" OR kode LIKE "___4%"
GROUP BY id order by semester ASC');
$sum_bobot_sks = Yii::app()->db->createCommand('Select SUM(bobot_sks) FROM mata_kuliah where kode LIKE "___1%" OR kode LIKE "___2%"
OR kode LIKE "___3%" OR kode LIKE "___4%"
')->queryScalar();
$sum_sks_inti = Yii::app()->db->createCommand('Select SUM(SKS_inti) FROM mata_kuliah where kode LIKE "___1%" OR kode LIKE "___2%"
OR kode LIKE "___3%" OR kode LIKE "___4%"
')->queryScalar();
$dataProvider=new CSqlDataProvider(array($sql, $sum_bobot_sks, $sum_sks_inti,array('keyField'=>'id')));
return $dataProvider;
$this->render('../tabelS1/tabel5122', array('dataProvider'=>$dataProvider));
}
terus di render di view/tabelS1/tabel5122.php yang isinya kayak gini
pas ngeklik ke menu tabel5122 kok gak muncul apa-apa ya (di browser kayak blank page gitu). Mohon penjelasannya. Makasih ya para master. Ilmu yang dishare sangat bermanfaat
SOLVED!
di model buat kayak gini
$criteria = new CDbCriteria;
$criteria->condition = "kode LIKE concat (:kode, '___1%') OR kode LIKE concat (:kode, '___2%')
OR kode LIKE concat (:kode, '___3%')
OR kode LIKE concat (:kode, '___4%')";
$criteria->params = array(':kode'=> MataKuliah::model()->getAttribute('kode'). '%');
return $this->model()->findAll($criteria);
terus di Contoller buat kayak gini
public function actionTabel5122S1(){
$dataProvider = MataKuliah::model()->tabel5122S1();
$this->render('../tabelS1/tabel5122', array('dataProvider'=>$dataProvider));
}
render tabelnya kayak gini