php - code igniter - 如何在我的数据库 mysql/php 中保存图像

Question

在我的页面中，我创建了一个表格，其中包含不同的字段，如姓名、电子邮件、密码等，现在我必须上传图像并将其存储在我的数据库中。任何人发送包含图像上传文件在内的所有字段的代码。我必须尝试很多次，图像无法上传到我的数据库中。我的 Controller 是

function activity()
    {
        $this->load->library('form_validation');
        //field name,error message, validation rules
        $this->form_validation->set_rules('activityid', 'Activity Id', 'trim|required');
        $this->form_validation->set_rules('hostid', 'Host Id', 'trim|required');
        $this->form_validation->set_rules('activityname', 'Activity Name', 'trim|required');
        $this->form_validation->set_rules('date', 'Date', 'trim|required');
        $this->form_validation->set_rules('venue', 'Venue', 'trim|required');
        $this->form_validation->set_rules('typeofactivity', 'Type of Activity', 'trim|required');
        $this->form_validation->set_rules('conductedby', 'Conducted By', 'trim|required');
         $config['upload_path'] = './asset/';
$config['allowed_types'] = 'gif|jpg|png|jpeg';
$config['max_size'] = '1000';
$config['max_width'] = '1024';
$config['max_height'] = '768';
$config['encrypt_name'] = TRUE;
$this->load->library('upload', $config);    
$w = $this->upload->data();
        if($this->form_validation->run()==FALSE)
        {
            //$this->load->view('signup_form');
            $this->activity_reg();
        }
        else
        {
             $this->load->model('membership_model');

            $query=$this->membership_model->activity();

            if($query)
            {

                $data['main_content']='signup_successful';
                $this->load->view('includes/templates',$data);
            }
            else
            {
                $this->load->view('activity');
            }
        }
    }

我的模型是

function activity()

    {
        $w = $this->upload->data();
        $new_member_insert_data= array(

                        'activityid'=>$this->input->post('activityid'),
                        'hostid'=>$this->input->post('hostid'),
                        'activityname'=>$this->input->post('activityname'),
                        'date'=>$this->input->post('date'),
                        'venue'=>$this->input->post('venue'),
                        'typeofactivity'=>$this->input->post('typeofactivity'),
                        'conductedby'=>$this->input->post('conductedby'),
                            'image' => $w['file_name']
            );

                        $this->load->database();
                        $insert=$this->db->insert('activity',$new_member_insert_data);
                        return $insert;

    }

Answer 1

使用 file_get_contents() 函数。

$image = $_FILES['YOUR_INPUT_NAME']['tmp_name'];
$new_member_insert_data= array(
                    'activityid'=>$this->input->post('activityid'),
                    'hostid'=>$this->input->post('hostid'),
                    'activityname'=>$this->input->post('activityname'),
                    'date'=>$this->input->post('date'),
                    'venue'=>$this->input->post('venue'),
                    'typeofactivity'=>$this->input->post('typeofactivity'),
                    'conductedby'=>$this->input->post('conductedby'),
                    'image' => file_get_contents( $image )
        );