Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function CIT_SELECT($table,$opr='',$data='array',$ord='',$sort='asc',$limit=0,$start=0){
- $record = array();
- $this->db->select("*");
- $this->db->from($table);
- if ($opr != ''){
- switch($opr){
- case 'like':
- foreach($data as $key=>$val){
- $this->db->like($key,$val);
- }
- break;
- case 'equal':
- foreach($data as $key=>$val){
- $this->db->where($key,$val);
- }
- break;
- }
- }
- if (trim($ord)!=''){ $this->db->order_by($ord, $sort); }
- if (trim($limit)!='0'){ $this->db->limit($limit); }
- $Q = $this-> db-> get();
- if ($Q-> num_rows() > 0){
- foreach ($Q-> result_array() as $row){
- $record[] = $row;
- }
- }
- $Q-> free_result();
- return $record;
- }
- $kriteria = array('param1'=>'kriteria1','param2'=>'kriteria2'......);
- $sql = CIT_SELECT('namatable','equal',$kriteria)
- // membalikan ke bentuk array
- foreach ($sql as $r){
- echo $r["namafield"];
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement