CODEWITHSUNDEEP
phpcssmysql
Aso
Aso

Reputation: 641

get BLOB image from MySql into CSS inline style

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();
?>

Upvotes: 2

Views: 753

Answers (1)

Rp9
Rp9

Reputation: 1963

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();
?>

Upvotes: 2

Related Questions