How to Upload File/Image Directly In database not directory Storage

convert your image into blob before saving it to database.

@tealiedie could you please show me a demo code for this

You could use Intervention Image to do this stuff

$pic = new Picture;
$pic->data = (string) Image::make('public/bar.png')->encode('data-url');
$pic->save();

@samo but this stores image in public directory not in database could you please tell me how to store it in table not disc directory

@ankitsoni try this:

$temp = file_get_contents($yourFile);
$blob = base64_encode($temp);
// Store $blob in the database just like any other field. The column type should be 'blob' ideally.

This is a bad idea to store images in database.

this doesn't store any kind of image, it encodes an given image into a data-url driven format

in laravel you are free to load the image from 'storage/pictures' instead of 'public/', thats a simple string

and of course as @pmall said, its a bad idea to store your image that way

@pmall i know this is bad idea i used to store it in directory disc but now application that i want i needs to store it in database where size will be max 30kb

@pmall Apart from increase in query time, any other justification for it being bad ?

I just do this:

  $file = file_get_contents($tmpFileName);

    //if the item does not have a drawing - add one
    if ($item->drawing === null) {
      $drawing = New Drawing();
      $drawing->bitmap = $file;
      $item->drawing()->save($drawing);
    }else{
      //if the item already has a drawing, just update it
      $item->drawing->update(['bitmap' => $file]);
    }

My images are 6kb, so I figure that this is the best place for them. They will also get backed up with my DB.

Mick

@phpMick i tried your way but it didn't work for me.. Could some one please tell me how i simply upload image in database and retrieve it back to show page i currently use like this but it didn't work

Public function store(){
$vle = new Vle($request->all());
$vle->save();
if($request->hasFile('thumbnail'))
    {
        $data = file_get_contents(Input::file('thumbnail')->getRealPath());
        DB::table('vles')->insert(array(
                'thumbnail'=> $data
            )
        );
    }

You can't save an image directly to a database. You have to convert it into a base64 string first and save that to the database.

http://stackoverflow.com/questions/3967515/how-to-convert-image-to-base64-encoding

http://stackoverflow.com/questions/8499633/how-to-display-base64-images-in-html

@enkay as you said i decode the image into base 64 by using

if ($request->hasFile('thumbnail')) { $data = file_get_contents(Input::file('thumbnail')->getRealPath()); $base64 = base64_encode($data); } // now don't understand the logic how to retrieve it as like file ???

@ankitsoni Click the second link I posted. You don't need to decode the base64 blob, you can use it directly in your img tag.

@ankitsoni what happened when you try my code? Works for me.

Here is how I retrieve the images:

 if($item){
      $drawing = $item->drawing;
      $arrResponse['success']='true';
      if($drawing){
        $arrResponse['bitmap']=base64_encode($drawing->bitmap);
      }
    }

I am using AJAX.

Mick

@phpMick decoding is not working is there any simple method to retrieve it ???

i check to encode myfile online it shows correct encoding but how i decode and retrieve it to show.

link that you post is not works for me is there any simple method to get it ???

@d3xt3r one good reason not to: you are invoking php to serve something your filesystem and webserver are generally a lot faster at serving(nginx for example is among the fastest to serve static files).

That said, storing files in the database isn't the worst thing you can do, but you should know the impact it may have, especially if you have a site of some size.

@ankitsoni what do you mean, not working?

I believe you can store binary (BLOB) in databases, which is basically storing an image in the database without converting to some string.

I would avoid it too, but I think it's possible.

@EmilMoe yes i'm using blob and convert the image into base64_encode to save it but prob is to show the image how i retrive it whereas i decode it before it to show but still it not working

@phpMick i mean to say simply image not show on page it shows decoded string

Just use file_get_contents()

'INSERT INTO table(image) VALUES("'. file_get_contents($imagepath) .'")';

This is how I display it:

 $('#thumbnail').attr('src','data:image/bmp;base64,' + data.bitmap);

Again using AJAX and JQuery.

Mick