get BLOB image from MySql into CSS inline style

Question

I have a php script, which contain div html tag. and I want to set css background-image from MySql to each divs.

My Wrong Code:

<?php
require 'config.php';
$query = "SELECT * FROM `users`";
$result = mysqli_query($conn, $query);
while($row = mysqli_fetch_array($result))
{
    $user_Image = $row['blob'];
    echo "<div class='avatar' style='background-image :url(\"data:image/jpeg;base64, base64_encode($user_Image)\");'></div>";
}
$conn->close();
?>

Rp9 · Accepted Answer · 2018-09-05 05:48:39Z

2

try this

      <?php
require 'config.php';
$query = "SELECT * FROM `users`";
$result = mysqli_query($conn, $query);
while($row = mysqli_fetch_array($result))
{
    $user_Image = $row['blob'];
    ?>
    <div class="avatar" style="background-image :url(data:image/jpeg;base64, base64_encode(<?php echo $user_Image;?>)")></div>
<?php     
}
$conn->close();
?>

answered Sep 5, 2018 at 5:48

Rp9

1,9612 gold badges27 silver badges34 bronze badges

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

1 Comment

Aso Over a year ago

Sir, your answer probably right to me, but now i want to save my blob image into a new record which is also blob, please how can i do this. thank you.

Collectives™ on Stack Overflow

get BLOB image from MySql into CSS inline style

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