Display BLOB image Laravel 4

Question

I have added png images as BLOB on mysql but when I try to retrieve them, I got them as files but can't display as images.

Below is my code.

//Controller

public function post_news(){
    $image = Input::file('image');
    $filename = $image->getClientOriginalName();
    $base64 = base64_encode($filename);
    $news = new News();
    $news->title = Input::get('title');
    $news->description = Input::get('desc');
    $news->image = $filename;
    $news->save();

  return Redirect::to('news')->withErrors(['This news has been added on your database. You may continue!']);

//Route

Route::get('/', function() {
$news = DB::table('news')->get();
return View::make('home2', compact('news'));

});

//Views

<?php if (isset($news)) { ?>
            @foreach ($news as $row)
        <div class="img-container">
            <div class="imageOne image"> 
                <?php //dd($row->image); ?>
                <img src="data:image/png;base64,{{ chunk_split(base64_encode($row->image)) }}">  
            </div>
.....

James Bondze · Accepted Answer · 2019-07-15 12:37:25Z

5

<img src="data:image/png;base64,{{ chunk_split(base64_encode($posts2year->StudentImage)) }}" height="100" width="100">

I used this in my code and it worked.

edited Jul 15, 2019 at 12:37

answered Mar 16, 2018 at 6:41

James Bondze

1021 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

Display BLOB image Laravel 4

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related