用PHP从数据库中获取Blob并在HTML标记上使用它

<?php
// 连接数据库
$servername = "数据库主机名";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名称";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}

// 查询数据库
$sql = "SELECT blob_column FROM table_name WHERE condition";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 获取Blob数据
    $row = $result->fetch_assoc();
    $blobData = $row['blob_column'];

    // 将Blob数据嵌入HTML标记
    $base64Data = base64_encode($blobData);
    echo '<img src="data:image/jpeg;base64,' . $base64Data . '" alt="Blob Image">';
} else {
    echo "未找到Blob数据";
}

$conn->close();
?>