got stuck with displaying images

Question

I am trying to display an image from the database, however, the image does not appear, but instead, an image icon appears, see image

this is the image icon with 2 warnings

if(isset($_POST['submit2']))
{
    $usertable = "table1";
        $db  = new mysqli('localhost', 'root', '', 'testdb') or die("unable to dbect");

        $sql = mysqli_query($db,"SELECT image1 FROM table1 WHERE id = '1'");
        $sth = $db->query($sql);
        $result = mysqli_fetch_array($sth);
        echo '<img src="data:image/jpeg;base64,'.base64_decode( $result['image'] ).'"/>';
}

if anyone could fix the code, thank you very much

Are you sure you want base64_encode() instead of base64_decode()? — Pupil, Mar 12 '19 at 06:46
Also, are you sure that your connection is `$db` and not `$database`? — u_mulder, Mar 12 '19 at 06:50
Third, are you sure that you select `image1` field but output `image`? — u_mulder, Mar 12 '19 at 06:50

score 0 · Answer 1 · answered Mar 12 '19 at 06:59

actually it suppose to be Base 64

for that you have given echo '<img src="data:image/jpeg;base64 so you should not encrypt or decrypt it .

more How to display image from database using php

Try

echo '<img src="data:image/jpeg;base64,'.$result['image'] .'"/>';

got stuck with displaying images

1 Answers1