PHP retrieve VARBINARY & display as an image

Question

i am

Creating an image with C#
Converting it to Byte[] -------> This is how i am doing it
then Sending it to MySQL and storing it in VARBINARY

the problem is now I don't know how to retrieve it TO display it as an image

$query = mysql_query("SELECT * FROM sad_img WHERE ss_id='1'");
if( mysql_num_rows( $query ) > 0 )
$ui = mysql_fetch_assoc( $query );

and after that i have no clue, what to do. The internet is not providing mch information about this. Please help

image/jpeg but as i am only generating JPGs so i don't need to store it anywhere, i will explicitly mention it when it comes times to mention, anything else like the width\height of image, title\caption will all be explicit mentions in the php code — Moon
– Moon, Commented Feb 25, 2012 at 3:07
And where do you want to display the image? You can just base64 encode the binary string and then <img src="data:image/jpeg;base64,YOURENCODEDBINARYDATA" />. — hakre
– hakre, Commented Feb 25, 2012 at 3:10
i did it, its not working. i did this '<img src="data:image/jpeg;base64,<?php echo $ui['screenshot'];?>" />' check the out put at moon.pk/sad — Moon
– Moon, Commented Feb 25, 2012 at 3:17
That outputs the following URI: data:image/jpeg;base64,System.Byte[] - obviously this can't work ;) You need to debug your code how you store the binary data into the db, this looks more like the name of the object. — hakre
– hakre, Commented Feb 25, 2012 at 3:19

hakre · Accepted Answer · 2012-02-25 04:30:32Z

2

You have stored the string System.Byte[] into the database field where you wanted to store the binary data of the image file into. Fix the insert code and put the plain bytes into the database. In PHP then encode it as base64 to output it:

<img src="data:image/jpeg;base64,<?php echo base64_encode($ui['screenshot']);?>" />

This should do the job.

answered Feb 25, 2012 at 4:30

hakre

200k55 gold badges454 silver badges865 bronze badges

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

Comments

Vijay Balan · Accepted Answer · 2016-08-17 08:17:37Z

-2

use this code for base64 type image fileds

<img class="w3-hover-opacity"src="data:image/jpeg;base64,'.base64_encode( $row['Photo'] ).'"
                        width="120" height="120" onClick="onClick(this)" style="cursor:pointer border-raduis:1px;">';

edited Aug 17, 2016 at 8:17

answered Aug 17, 2016 at 8:12

Vijay Balan

511 silver badge2 bronze badges

Collectives™ on Stack Overflow

PHP retrieve VARBINARY & display as an image

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related