selecting longblobs in php

[knows_something]

I'm having difficulties selecting and displaying images i've saved in my database with longblob. there are a lot of examples on google that presumably work but after trying them all, nothing works. 

this is a part of my code: 

$sql = "SELECT teamID, name, date, managerID, points, logo FROM team;";

if(!$result = $mysqli->query($sql)){
    die('There was an error running the query [' . $mysqli->error . ']');
}
echo '<div>';
echo '<table border="1">';
while($row = $result->fetch_assoc())
{
	echo '<tr>
     <td>'.$row['teamID'] . '</td>
	 <td>'.$row['name'] . '</td>
	 <td>'.$row['date'] . '</td>
	 <td>'.$row['managerID'] . '</td>
	 <td>'.$row['points'] . '</td>
	 <td>'.$row['logo'] . '</td>
	 </tr>';
}
echo '</table>';
echo '</div>';

what's wrong and why doesn't it work? I used phpmyadmin to select an image and save it into the database, firstly i connected to it and then wanted to display a table of teams. But as soon as i add blob to the mix it doesn't work. Without it everything works and after that i just get a table with random signs instead of a picture.

What could be the problem?

[Brenz]

You can't just echo the blob and expect it to work. You need to wrap it in valid HTML as well. Try this:

<img src="data:image/jpeg;base64,<?php echo base64_encode($row['logo']) ?>" alt="My Image" />

 

[Blade of Grass]

I would highly suggest against the storing of images in your database, instead, I would suggest you store the filepath to said image. Databases are made for structured data and do not handle images very well, this leads to increased overhead on a file system level (as the database will use more data to store the same images), and a performance decrease.