Display if exist image from mysql with PHP

Question

I setup a comment form with the option to submit an image, I want now to display the image only if exist.

This is the php script that I have, I know it should be related to an "if" statement but I don't know how to do it

Any help would be appreciated

<?php
$dbLink = mysql_connect("xxx","xxx","xxx");
mysql_query("SET character_set_results=utf8", $dbLink);
mb_language('uni');
mb_internal_encoding('UTF-8');

$getquery=mysql_query("SELECT * FROM comment ORDER BY id DESC");

while($rows=mysql_fetch_assoc($getquery)) {
    $id=$rows['id'];
    $name=$rows['name'];
    $comment=$rows['comment'];
    echo '<b>' . $name . '</b>' . '<br/>' . '<br/>' . $comment . '<br/>' . '<br/>' . '<img src="data:image/jpeg;base64,'.base64_encode($rows['imageData'] ).'"/>' . '<br/>' . '<br/>' . '<hr size="1"/>';
}
?>

reza · Accepted Answer · 2017-02-06 21:28:04Z

2

Just divide the echo into 3 parts

echo '<b>' . $name . '</b>' . '<br/>' . '<br/>' . $comment . '<br/>' . '<br/>' ;

if(isset($rows['imageData']) && $rows['imageData'] != '') 
   echo '<img src="data:image/jpeg;base64,'.base64_encode($rows['imageData'] ).'"/>'.'<br/>' . '<br/>' ;

echo   '<hr size="1"/>';

edited Feb 6, 2017 at 21:28

answered Feb 6, 2017 at 21:16

reza

1,5072 gold badges12 silver badges17 bronze badges

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

1 Comment

reza Over a year ago

yes, you are right. there is a possibility of it. made the necessary edit

Collectives™ on Stack Overflow

Display if exist image from mysql with PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related