Can't Display Longblob images with php in cpanel

Question

$con= mysqli_connect("host", "user", "password", "database");  
session_start();
if(isset($_SESSION['username'])){
    //echo 'Hi! '.$_SESSION['username'];
}
if(isset($_GET["name"])){
    $n= "SELECT * FROM `users` WHERE `user_name`='".$_GET['name']."' "[0];
    $r= mysqli_query($con, $n);
    if($r){
        while($row= mysqli_fetch_assoc($r)){
             echo $row['Full_name'];
             $image= $row['profile'];
             echo $image;
    }
    }
}

Here is my Code. When I run it it just shows scrambled lines(!!) What can I do to display the images which are saved as Longblob in mysql database.

This is a web-based project, coded in cpanel hosting. I tried some solutions but they didn't work. I think the problem happens in the links

I tried this solution:

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

have you tried this one https://stackoverflow.com/questions/34111390/displaying-blob-image-from-mysql-database-into-dynamic-div-in-html/34112174 — Dhaval Purohit, Nov 27 '19 at 06:45
Your code is vulnerable to SQL injection. You should use prepared statements. — Dharman, Nov 27 '19 at 07:24

score 0 · Answer 1 · answered Nov 27 '19 at 07:28

0

Don't use blob to store images. Use varchar to save URL of the image and upload that images to specific folder. MySQL is not designed to store images.

answered Nov 27 '19 at 07:28

Ashok

131
2
7

Can't Display Longblob images with php in cpanel

1 Answers1