1.全表查询publicfunctionquery(){$sql="查询语句";$query=$this->db->query($sql);$this->output->set_output(json_encode($query->result()));}2.带参数查询（获取请求）publicfunctionqueryByParam($param){$sql="querystatementwherefield={$param}";$query=$this->db->query($sql);$this->output->set_output(json_encode($query->result()));}3.带参数查询（postrequest）publicfunctiondetail(){$jsonStr=$this->input->raw_input_stream;$jsonObj=json_decode($jsonStr);$param=$jsonObj->id;$sql="查询语句来自表名wherefield='{$param}'";$query=$this->db->query($sql);$resData=$query->result();$this->output->set_output(json_encode($resData));}4.分页查询publicfunctionpaginate(){$jsonStr=$this->input->raw_input_stream;$jsonObj=json_decode($jsonStr);$page=$jsonObj->page;//$page=1$limit=$jsonObj->limit;//$limit=2if($page<1){$page=1;}$tmp=($page-1)*$limit;$sql="查询语句来自表名limit{$tmp},{$limit}";$query=$this->db->query($sql);$this->output->set_output(json_encode($query->result())));}5.保存publicfunctionsave(){$jsonStr=$this->input->raw_input_stream;$jsonObj=json_decode($jsonStr);$params=array('id'=>$jsonObj->id,'name'=>$jsonObj->title,'content'=>$jsonObj->content);$this->db->insert('表名',$params);$this->output->set_output($this->db->affected_rows());}
