Advertisement
zulmi

ComboboxController.php tutorial combobox

Nov 26th, 2017
2,392
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.66 KB | None | 0 0
  1. public function actionTambah(){
  2.  
  3. if (isset($_POST['addsubmit'])) {
  4. $SQL="INSERT INTO tutorial_combobox values('','".$_POST['province']."','".$_POST['kabupaten']."','".$_POST['kecamatan']."','".$_POST['kelurahan']."','".$_POST['harga']."')";
  5. $command= Yii::app()->db->createCommand($SQL);
  6. $n=$command->execute();
  7.  
  8. $this -> redirect(array('combobox/index'));
  9. }else{
  10. $this->render('tambah');
  11. }
  12. }
  13. public function actionGet_Kab(){
  14.  
  15. $criteria= new CDbCriteria;
  16. $criteria->order = 'nama ASC';
  17. $criteria->condition ='id_prov = '.$_POST['prov'].' ';
  18. $model=Kabupaten::model()->findAll($criteria);
  19.  
  20. $return = '<option>pilih kabupaten</option>';
  21. foreach($model as $m)
  22. {
  23. $return .= '<option value="'.$m['id_kab'].'">'.$m['nama'].'</option>';
  24. }
  25. echo $return;
  26. }
  27.  
  28. public function actionGet_Kec(){
  29. //IsAuth::Admin();
  30. $criteria1= new CDbCriteria;
  31. $criteria1->order = 'nama ASC';
  32. $criteria1->condition ='id_kab = '.$_POST['kab'].' ';
  33. $models=Kecamatan::model()->findAll($criteria1);
  34.  
  35. $return = '<option>Pilih Kecamatan </option>';
  36. foreach($models as $ms)
  37. {
  38. $return .= '<option value="'.$ms['id_kec'].'">'.$ms['nama'].'</option>';
  39. }
  40. echo $return;
  41. }
  42.  
  43. public function actionGet_Kel(){
  44. //IsAuth::Admin();
  45. $criteria2= new CDbCriteria;
  46. $criteria2->order = 'nama ASC';
  47. $criteria2->condition ='id_kec = '.$_POST['kel'].' ';
  48. $model2=Kelurahan::model()->findAll($criteria2);
  49.  
  50. $return = '<option>Pilih Kelurahan </option>';
  51. foreach($model2 as $mk)
  52. {
  53. $return .= '<option value="'.$mk['id_kel'].'">'.$mk['nama'].'</option>';
  54. }
  55. echo $return;
  56. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement