如何从MySQL检索和显示图像？

Question

I just want to retrieve display images from SQL data base but I can't.

<?php

$sql = "SELECT * FROM two_upload_pics";
$myData = mysql_query($sql);

while($record = mysql_fetch_assoc($myData))
{
    $img=$record["upload_image"];
    print_r($img)
    ?>

    <img src ="uploads/<?php echo $img; ?> style="height: 200px;" class="img-resposive">
    <?php
} 

?>

Answer 1

I've just modified your code. Try this one. Maybe it'll work.

<?php
$sql = "SELECT * FROM two_upload_pics";
$myData = mysql_query($sql);

while($record = mysql_fetch_assoc($myData))
{
    $img=$record["upload_image"];

    echo "<img src ='uploads/$img' style='height: 200px;' class='img-resposive' >";
}
?>

Still, I'll not suggest to use mysql extension. Go with PDO or MySQLi