php - 从 MySql 获取 BLOB 图像到 CSS 内联样式

Question

我有一个 php 脚本，其中包含divhtml 标记。我想css background-image从 MySql 设置到每个 div。

我的错误代码：

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

标签： phpcssmysql

Answer 1

尝试这个

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