How to store the file in mysql database using codeigniter?

Question

I have created a simple contact form.I want to store the file in database which is uploaded by any user.I am able to store the file in my folder but i have to store the file in database to identify the admin which file is upload.

Controller

public function index()
        {
                $this->load->view('demo', array('error' => ' ' ));
        }

 public function do_upload()
        {


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

                $config['upload_path']          = './upload/';
                $config['allowed_types']        = 'docx';
                $config['max_size']             = 1000;
                $config['max_width']            = 1024;
                $config['max_height']           = 768;

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

                $this->upload->do_upload();
                $this->Model_doc->index($id, $this->upload->data());
   }

Model

public function index($id,$imgdata)

{


 $imgdata = file_get_contents($imgdata['../upload/']);

$data = array(
        'path'=>$imgdata,

         );
    $this->db->set('curentDate', 'NOW()', FALSE);
 $this->db->insert('test',$data);

}

View

<?php echo form_open_multipart('welcome/do_upload');?>

<input type="file" name="userfile" size="20" />

<br /><br />

<input type="submit" value="upload" />

</form>

i am getting 2 error in model 1) Undefined index: ../upload/ 2)file_get_contents(): Filename cannot be empty. — user6930268
– user6930268, Commented Feb 9, 2016 at 3:03

Ketan Solanki · Accepted Answer · 2016-02-09 11:20:49Z

1

Change code in the Controller File as Folow:

public function do_upload()
    {
        $id = $this->session->userdata('id');
        $this->load->model('Model_doc');
        $config['upload_path']          = './upload/';
        $config['allowed_types']        = 'docx';
        $config['max_size']             = 1000;
        $config['max_width']            = 1024;
        $config['max_height']           = 768;
        $this->load->library('upload', $config);
        $this->upload->do_upload();

        $full_file_path = base_url()."/upload/".$_FILES['userfile']['name'];
        //This Is Full Path of the file stored to your folder,Change it if required.

        $this->Model_doc->index($id,$full_file_path);
    }

Changes in the Model File:

public function index($id,$full_file_path)
    {

        $data = array(
            'path'=>$full_file_path,
        );
        $this->db->set('curentDate', 'NOW()', FALSE);
        $this->db->insert('test',$data);
    }

edited Feb 9, 2016 at 11:20

answered Feb 9, 2016 at 7:22

Ketan Solanki

2911 silver badge6 bronze badges

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

6 Comments

user6930268 Over a year ago

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <html> <head> <title>Index of /newfolder//upload</title> </head> <body> <h1>Index of /newfolder//upload</h1> <table> <tr><th valign=

user6930268 Over a year ago

Thanks for reply Mr.ketan , When i am submit the data i am getting above code in my database....

Ketan Solanki Over a year ago

@Hybreeder Do you need the path to be stored in the database or just the file name,Because File_get_contents reads the file as a string from the mentioned starting point.

Ketan Solanki Over a year ago

@Hybreeder Check the code above , I have updated the code.

Ketan Solanki Over a year ago

@Hybreeder Keep Rocking ...:)

|

Collectives™ on Stack Overflow

How to store the file in mysql database using codeigniter?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related