Advertisement
zulmi

Kategori_produkController part2

Nov 21st, 2017
7,910
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.53 KB | None | 0 0
  1. public function actionView($id)
  2.     {
  3.         $SQL="SELECT `nama_produk`,`stok`,`ukuran`,`image`,bp_jenis_produk.jenis_produk,bp_jenis_produk_02.jenis
  4.               FROM bp_produk INNER JOIN bp_jenis_produk ON bp_produk.jenis_id=bp_jenis_produk.id
  5.               INNER JOIN bp_jenis_produk_02 ON bp_produk.model_jenis=bp_jenis_produk_02.id_jenis_produk WHERE kategori_produk_id='".$id."'";
  6.         $commands=Yii::app()->db->createCommand($SQL);
  7.         $models=$commands->queryAll();
  8.  
  9.         $this->render('view',array(
  10.             'model'=>$this->loadModel($id),'models'=>$models
  11.         ));
  12.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement