code igniter- how to save image in my database mysql/php

Question

In my page , i have created one form with different fields like name, email,password,etc., now i have to upload the image and store in my database. any one send the code with all fields including image upload file. i have to try in many times, image can't upload in my database. my controller is

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');
            }
        }
    }

my model is

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;

    }

what is the error you are getting from image upload library? — Kumar V
– Kumar V, Commented Feb 5, 2014 at 7:52
no error.data's only stored in my database, not store in image — abu
– abu, Commented Feb 5, 2014 at 7:57

Vlado · Accepted Answer · 2014-02-05 07:54:53Z

1

Use file_get_contents() function.

$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 )
        );

answered Feb 5, 2014 at 7:54

Vlado

431 gold badge2 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

code igniter- how to save image in my database mysql/php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related