Displaying an image in blade.php file

Question

I am making a laravel application to serve as a backend to my website. I have an image (images) stored in a postgresql database. The format is bytea. I now want to display this image but it is showing me an error message.

Facade\Ignition\Exceptions\ViewException htmlspecialchars() expects parameter 1 to be string, resource given (View: C:\wamp64\www\WebTech\resources\views\shop\index-temp.blade.php)

I can't figure out whats wrong. Here is the code that is producing this error.

    @foreach($productsList as $product)
    <div class="col text-center">
       <a href="/products/{{$product->id}}">
          <img class="img-fluid" srcset="{{ $product->image_200 }} 200w, {{ $product->image_300 }} 300w"
                                 sizes="(max-width: 480px) 200px, 300px" 
                                 src="{{ $product->image_300 }}" alt="{{ $product->alt_text }}">
          <p class="mb-0 text-center text-white">{{ $product->name }}<br>{{ $product->cost }} eur</p>
          <p>{{$product->image_200}}</p>
      </a>
   </div>
   @endforeach

For clarification, the columns image_200, image_300 and image_500 are in bytea format in postgresql database. I have tried using the pg_unescape_bytea({{ $product->image_300 }}) function, but it doesn't help. What is the correct way to display an image in this way?

also it would be {{ pg_unescape_bytea($product->image_300) }} if you were trying to do what you had tried — lagbox
– lagbox, Commented Nov 13, 2019 at 23:33
The link doesn't help really, i tried it with the result of my page loading, but the image being broken. As to the second comment now i get this error: > pg_unescape_bytea() expects parameter 1 to be string, resource given — Michael Kročka
– Michael Kročka, Commented Nov 13, 2019 at 23:37
yes because it is still a resource that hasn't changed, i was just pointing out you were not doing what you thought you were doing ... you still need to get the contents from that resource before you can use it — lagbox
– lagbox, Commented Nov 13, 2019 at 23:39

lagbox · Accepted Answer · 2019-11-14 09:25:29Z

1

As per https://stackoverflow.com/a/33499238/2109233 :

Try to get the stream contents, then unescape the bytea:

{{ pg_unescape_bytea(stream_get_contents($product->image_300)) }}

I am not sure what format that will end up in, if it can't go through htmlspeciachars replace {{ }} with {!! !!}.

You could move this into an accessor so you can just call $product->image_300 and have it converted for you.

You probably want to be using a data URI scheme for the image src attribute.

Update:

Apparently you may not need the pg_unescape_bytea function but you do need to use a Data URI scheme for the image source.

edited Nov 14, 2019 at 9:25

answered Nov 13, 2019 at 23:44

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

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

4 Comments

Michael Kročka Over a year ago

I have tried doing this, but as i said, the result is that the website shows (without errors), but the image is broken.

lagbox Over a year ago

then look at the html source to see the value of the src attribute of the image tag so then you can figure out what is going wrong.

Michael Kročka Over a year ago

The output using this code

$temp = stream_get_contents($product->image_200);             $temp1 = pg_unescape_bytea($temp);             $product->image_200 = "data:image/jpeg;base64," . base64_encode($temp1);

is: data:image/jpeg;base64,/9j/4A== but it should be more like: data:image/png;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/4gJASUNDX1... I got the last one using this code:

ob_start();             fpassthru($product->image_200);             $contents = ob_get_contents();             ob_end_clean();             $product->image_200 = "data:image/png;base64," . base64_encode($contents);

Michael Kročka Over a year ago

Just wanted to update that I solved it using information above. The resulting code is:

$temp1 = stream_get_contents($product->image_200);   $product->image_200 = "data:image/png;base64," . base64_encode($temp1);

Collectives™ on Stack Overflow

Displaying an image in blade.php file

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related