Displaying BLOB from Database - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

rene.miller3 · 07-18-2011, 03:32 PM

Hello I am new to this forum and would greatly appreciate any help. I am trying to display a BLOB from my database onto a webpage, but I have no clue how to do this. My current code displays the name of the BLOB, not the BLOB itself. Here is the code:

<html>

<?php
$con = mysql_connect("mysql17.000webhost.com","a2870045_r ayman3","hawaii" );

mysql_select_db("a2870045_picture", $con);

$result = mysql_query("SELECT * FROM Art ORDER BY RAND() LIMIT 1");

$row= mysql_fetch_array($result);

$file = $row["File"];
mysql_close($con);
?>
<center><?=$file?></center>
</html>

Again, any help would be appreciated. If you need clarification, please let me know.

Rukbat · 09-16-2011, 04:18 PM

You first have to write the data ($file, assuming that the data really is the graphic file, not just its name) to a file. Then include an <img> tag in your HTML that points to that file.

You could also use PHP's image processing library, but that would take a bit of studying.

Keeping graphics in a database is bad programming. Keep the file names in the database and keep the graphics in files on the hard drive. Then you just write the <img> link using the returned name:

echo '<img src="'.$file.'" />';