Unable to insert image file in database

Question

I want to insert file in database how can i do it with codeigniter... Please note I don't want to store the path of the image. How can I store the image directly in the database?

Controller

class UserController extendes CI_Controller{
}

Model

class User extends CI_Model{
}

Just out of curiosity why are you determined to store the image in the database rather than a the file name? — Dale, Apr 09 '13 at 09:48
See this link may be help you.http://stackoverflow.com/questions/1650275/codeigniter-image-uploading-mysql — Hkachhia, Apr 09 '13 at 09:49
I dont want to keep it separate in folder structure so that.is there any way to store file directly in the mysql.. — Nilesh Mahajan, Apr 09 '13 at 09:50
If really want to store the data image in your database, one way to achieve it is to encode it with something like `base64_encode()`. — GiDo, Apr 09 '13 at 09:52

score 0 · Answer 1 · answered Apr 09 '13 at 09:56

0

You can store images in table with LONGBLOB datatype in mysql. just try this- http://www.phpriot.com/articles/images-in-mysql

answered Apr 09 '13 at 09:56

Suresh Kamrushi

14,655
12
74
87

score 0 · Answer 2 · answered Apr 09 '13 at 10:38

I guess for a better speed in high range of image records, storing the path or image name in a table is much more effective than storing the image data itself. you need to store the filename or the file path as a varchar and upload the file using uoload library of codeigniter.. This makes the whole process much simpler..!

Unable to insert image file in database

2 Answers2