Advertisement
citstudio

Multiple Kriteria (Parameter) Code Igniter

May 21st, 2012
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.15 KB | None | 0 0
  1. public function CIT_SELECT($table,$opr='',$data='array',$ord='',$sort='asc',$limit=0,$start=0){
  2.         $record = array();
  3.         $this->db->select("*");
  4.         $this->db->from($table);
  5.  
  6.         if ($opr != ''){
  7.             switch($opr){
  8.             case 'like':
  9.                 foreach($data as $key=>$val){
  10.                     $this->db->like($key,$val);
  11.                 }
  12.                 break;
  13.             case 'equal':
  14.                 foreach($data as $key=>$val){
  15.                     $this->db->where($key,$val);
  16.                 }
  17.             break;
  18.             }
  19.         }
  20.  
  21.         if (trim($ord)!=''){ $this->db->order_by($ord, $sort); }
  22.         if (trim($limit)!='0'){ $this->db->limit($limit); }
  23.  
  24.         $Q = $this-> db-> get();
  25.         if ($Q-> num_rows() > 0){
  26.             foreach ($Q-> result_array() as $row){
  27.                 $record[] = $row;
  28.             }
  29.         }
  30.  
  31.         $Q-> free_result();
  32.         return $record;
  33.     }
  34. $kriteria = array('param1'=>'kriteria1','param2'=>'kriteria2'......);
  35. $sql = CIT_SELECT('namatable','equal',$kriteria)
  36. // membalikan ke bentuk array
  37. foreach ($sql as $r){
  38. echo $r["namafield"];
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement