php ci上传图片,php-将图像上传到Codeigniter中的MySQL数据库Bl...

模型中的$this-> input-> post(‘photo’)将无法检索图像信息.因为图像存储在$_FILES中而不是$_POST中.因此,您需要在codeignitor中使用upload library,如下所示.

In Controller:

public function update_profile() {

$id = $this->session->userdata('id');

$this->load->model('edit_profile_model');

$config['upload_path'] = './uploads/';

$config['allowed_types'] = 'gif|jpg|png';

$config['max_size'] = '100';

$config['max_width'] = '1024';

$config['max_height'] = '768';

$this->load->library('upload', $config);

$this->upload->do_upload();//upload the file to the above mentioned path

$this->edit_profile_model->update_db_user_info($id, $this->upload->data());// pass the uploaded information to the model

}

In Model:

public function update_db_user_info($id, $imgdata) {

$imgdata = file_get_contents($imgdata['full_path']);//get the content of the image using its path

$data = array(

'fullname' => $this->input->post('fullname'),

'address' => $this->input->post('address'),

'state' => $this->input->post('state'),

'city' => $this->input->post('city'),

'pincode' => $this->input->post('pincode'),

'image' => $imgdata,

);

$this->db->where('id', $id);

$this->db->update('userdetails', $data);

}

要检索图像,请在下面的模型中编写一个函数.

public function get_image($id){

$this->db->where('id', $id);

$result = $this->db->get('userdetails');

header("Content-type: image/jpeg");

echo $result['image'];

}

而且,存储图像并从数据库检索也不是一个好习惯.与其尝试将图像存储在文件夹中,然后将路径存储在数据库中,如下所示.

In Model:

public function update_db_user_info($id, $imgdata) {

$imgdata = $imgdata['full_path'];// get the path of the image

$data = array(

'fullname' => $this->input->post('fullname'),

'address' => $this->input->post('address'),

'state' => $this->input->post('state'),

'city' => $this->input->post('city'),

'pincode' => $this->input->post('pincode'),

'image' => $imgdata,// change the type of image from blob to varchar or text

);

$this->db->where('id', $id);

$this->db->update('userdetails', $data);

}