codeigniter Missing value file name in db

Question

I have a problem with update in my db the value of file upload

My controller

public function c_piloti_update()
    {
        // Modifica i valori scheda pilota
        $id= $this->input->post('id');
        $data = array(
            'nominativo' => $this->input->post('nominativo'),
            'fotografia' => $this->input->post('fotografia')
        );

        $config['upload_path']          = './uploads/avatar/';
        $config['allowed_types']        = 'gif|jpg|png';
        $config['max_size']             = 1000;


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

        if ( ! $this->upload->do_upload('fotografia'))
        {
            $error = array('error' => $this->upload->display_errors());
            $this->load->view('upload_form', $error);
        }
        else
        {
            $this->load->model('alfa/alfa_model');
            $this->piloti_model->alfa_update($id,$data);            
            redirect('alfa/alfa-edit/'.$id);        
        }

    }

My Model

public function alfa_update($id, $data)
{       
    $this->db->where('id', $this->input->post('id'));  
    $this->db->update('register', $data);  
}

The attachment is saved, but in the DB i haven't the file name. thanks

maybe you should replace $this->input->post('id') with $id, I'm not sure if the Model has access to post data. — Airwavezx
– Airwavezx, Commented Apr 10, 2017 at 16:42

Pradeep · Accepted Answer · 2017-04-10 18:20:56Z

1

Get File details using this : $this->upload->data();

    if ( ! $this->upload->do_upload('fotografia'))
    {
        $error = array('error' => $this->upload->display_errors());
        $this->load->view('upload_form', $error);
    }
    else
    {
        $data['image_name '] = $this->upload->data('file_name'); 
       //here image_name is column name in table
        $this->load->model('alfa/alfa_model');
        $this->piloti_model->alfa_update($id,$data);            
        redirect('alfa/alfa-edit/'.$id);        
    }

see this :

https://www.codeigniter.com/user_guide/libraries/file_uploading.html#the-upload-directory

Change model method alfa_update() to this :

   public function alfa_update($id, $data)
   {       
     $this->db->where('id',$id);  
     $this->db->update('register', $data);  
   }

edited Apr 10, 2017 at 18:20

answered Apr 10, 2017 at 17:50

Pradeep

9,70713 gold badges29 silver badges34 bronze badges

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

1 Comment

Alessandro Petrera Over a year ago

$data['image_name '] = $this->upload->data('file_name'); It Works!!!!!! thanks a lot!!!!

Collectives™ on Stack Overflow

codeigniter Missing value file name in db

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related