php - 从 phpmyadmin 动态检索多个图像

Question

我在 phpmyadmin 中存储了一组多项选择题。我需要检索一张图片以及每个问题和答案。换句话说，当用户开始测试或点击“下一题”按钮时，他们不仅需要看到问题和答案，还需要看到与该问题相关的图像。我已经将图像以 Blob 格式保存在数据库中，但在动态检索它们时遇到问题。如果有人帮助我，我将不胜感激

部分代码如下:

$singleSQL = mysql_query("SELECT * FROM questions WHERE id='$question' LIMIT 1");
    while($row = mysql_fetch_array($singleSQL)){
        $id = $row['id'];
        $thisQuestion = $row['question'];
        $type = $row['type'];
        $question_id = $row['question_id'];
        $q = '<h2><i>'.$thisQuestion.'</i></h2>';

        $sql2 = mysql_query("SELECT * FROM answers WHERE question_id='$question' ORDER BY rand()");
        while($row2 = mysql_fetch_array($sql2)){
            $answer = $row2['answer'];
            $correct = $row2['correct'];
            $answers .= '<label style="cursor:pointer;"><input type="radio" name="rads" value="'.$correct.'"><b>'.$answer.'</b></label> 
            <input type="hidden" id="qid" value="'.$id.'" name="qid"><br /><br />
            ';  
        }

        $sql3 = mysql_query("SELECT username FROM quiz_takers");
        while($row3 = mysql_fetch_array($sql3)){
        $name = $row3['username'];
            }

Answer 1

尝试像这样显示 blob 图像:

$image = $row['image'];
echo '<img src="data:image/type;base64,'.base64_encode($image).'" />';

将 image/type 替换为 image/jpeg 或图像的任何类型。