How to display an BLOB image stored in MySql database?

This is what I used when I wanted to do something like that… a long time ago! =P

$sql = "SELECT image FROM table WHERE cond ORDER BY xxxx DESC LIMIT 5";
$result = mysqli_query($db,$sql);
while($arraySomething = mysqli_fetch_array($result))
{
    echo "<img src="https://stackoverflow.com/questions/13214602/php/imgView.php?imgId=".$arraySomething."" />";
}

Leave a Comment