本文實例講述了CI框架常用函數(shù)封裝。分享給大家供大家參考,具體如下:
/*** 封裝查詢函數(shù)*/public function get_what($table='',$where=array(),$fields = ' * '){ if( '' == $table ){ return false; } //查詢并返回相關(guān)結(jié)果 $query = $this->db->select($fields)->where($where)->get($table); $res = $query->result_array(); return $res;}/*** 封裝單條查詢函數(shù)*/public function get_row($table='',$where=array(),$fields = ' * '){ if( '' == $table ){ return false; } //查詢并返回相關(guān)結(jié)果 $query = $this->db->select($fields)->where($where)->get($table); $res = $query->row_array(); return $res;}/*** 封裝更新函數(shù)*/public function update_what($table='', $where=array(), $data = array()){ if('' == $table || true === empty($where) || true === empty($data)){ return false; } //更新相應(yīng)的字段 $query = $this->db->update($table,$data,$where); return $query;}/*** 擴展數(shù)據(jù)庫函數(shù)之自增 自減* using:* $table = 'codeuser';$where = array('id'=>1);$data = array('usestate'=>'usestate+1','imgtype' => 'imgtype-1');*/public function update_count($table = '', $where=array(), $data=array()){ //如果表名為空 或者數(shù)據(jù)為空則直接 返回false if('' == $table || empty($data)){ return false; } foreach($data as $key => $val){ if(false !== stripos($val,'+') || false !== stripos($val,'-')){ $this->db->set($key, $val, FALSE); }else{ $this->db->set($key, $val); } } $res = $this->db->where($where)->update($table); return $res;}/*** 封裝插入函數(shù)*/public function insert_what($table = '', $data = array()){ if('' == $table || true === empty($data)){ return false; } //插入 相關(guān)記錄 $query = $this->db->insert($table, $data); return $query;}/*** 刪除記錄封裝函數(shù)*/public function delete_what($table = '', $where=array()){ if(true === empty($where) || '' == $table){ return false; } //刪除相關(guān)表記錄 $query = $this->db->delete($table,$where); return $query;}/*** debug 相關(guān)函數(shù)*/ public function debug_what($org_error = ''){ $con = $this->router->fetch_class(); $func = $this->router->fetch_method(); if($org_error){ $error .= date("Y-m-d H:i:s",time())."/r/n"; $error .= __FILE__."/r/n"; $error .= $con." 控制器下的:/r/n"; $error .= $func." 方法調(diào)試信息如下:/r/n"; $error .= $org_error;file_put_contents("./error_log.txt",$error."/r/n",FILE_APPEND); }}希望本文所述對大家基于CodeIgniter框架的PHP程序設(shè)計有所幫助。
新聞熱點
疑難解答
圖片精選