CodeIgniter Forums
File not uploading in mysql database. - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: File not uploading in mysql database. (/thread-60239.html)



File not uploading in mysql database. - El Forum - 02-12-2014

[eluser]Unknown[/eluser]
I want to upload selected file in mysql database. But I am unable to upload it.
When I upload something it shows no error and a column as 'file_name' shows its value as NULL.
Please tell me whats wrong with my code.

code :

Code:
function manage_prescription($param1 = '', $param2 = '', $param3 = '')
{
  if ($this->session->userdata('laboratorist_login') != 1)
   redirect(base_url() . 'index.php?login', 'refresh');
  
  if ($param1 == 'create_diagnosis_report') {
   $data['report_type']     = $this->input->post('report_type');
   $data['document_type']   = $this->input->post('document_type');
   move_uploaded_file($_FILES["userfile"]["tmp_name"], "./uploads/diagnosis_report/" . $_FILES["userfile"]["name"]);
   $data['file_name'] = $_FILES["userfile"]["name"];
   $data['prescription_id'] = $this->input->post('prescription_id');
   $data['description']     = $this->input->post('description');
   $data['timestamp']       = strtotime(date('Y-m-d') . ' ' . date('H:i:s'));
   $data['laboratorist_id'] = $this->session->userdata('laboratorist_id');
  
   $this->db->insert('diagnosis_report', $data);
   $this->session->set_flashdata('flash_message', get_phrase('diagnosis_report_created'));
   redirect(base_url() . 'index.php?laboratorist/manage_prescription/edit/' . $this->input->post('prescription_id'), 'refresh');
  }
  
  if ($param1 == 'delete_diagnosis_report') {
   $this->db->where('diagnosis_report_id', $param2);
   $this->db->delete('diagnosis_report');
   $this->session->set_flashdata('flash_message', get_phrase('diagnosis_report_deleted'));
   redirect(base_url() . 'index.php?laboratorist/manage_prescription/edit/' . $param3, 'refresh');
  
  } else if ($param1 == 'edit') {
   $page_data['edit_profile'] = $this->db->get_where('prescription', array(
    'prescription_id' => $param2
   ))->result_array();
  }
  $page_data['page_name']     = 'manage_prescription';
  $page_data['page_title']    = get_phrase('manage_prescription');
  $page_data['prescriptions'] = $this->db->get('prescription')->result_array();
  $this->load->view('index', $page_data);
}



File not uploading in mysql database. - El Forum - 02-12-2014

[eluser]CroNiX[/eluser]
You sure it's set?
Code:
var_dump($_FILES);

If not, check your form. Is it using
Code:
enctype="multipart/form-data"
?