calling images from a database??

[shadiadi]

MM I obviously have no idea about this any pointers please.

I have just resized and added a thumbnail to my database and now i am tring to call it from the database on a page to be read and it is just displaying aload of nonsense data??

ÔuK‰ ½¼Žõ*HÂ{tà`àg'$pLúgÂ?µ1—VF!p|¢0@ žƒŒôã=8ÁäŸ7†2Ê8iÔÅâ§í9ɹ&ÚkšêMZÎV÷ŸÆÓÑ·m~j5ò\¦U18¼\'^1n(ûõ[j.ÑI¶µm>k;nôÓâ°Þ'ñÇÙ-¡™·2 v:üăî€Î:“ÛŸ`ð—ìÿ©ê —‚´Jçsd

the page is full of it like above??

This is what I am using to call it.

<td>
<?
$query = "SELECT thumbnail FROM uploads where intProductID=$adid"; 
$result = MYSQL_QUERY($query); 
$data = MYSQL_RESULT($result,0,"thumbnail");

?>  

<img src="<?=$data?>" />
</td>

[sandthipe]

i prefer to store only the filename in the database (VARCHAR 255) and store the image itself in the file system. then you can query the database for the filename and construct your img src with the information:

<img src='../images/<?php echo $filename;?>' />

as for thumbnails, you can either use the simple method of adjusting the width and height in the img tag or a more advanced method such as a function to resize the image

[shadiadi]

I already did all the upload resize save to database stuff dont really want to have to go back and start again lol

[bradgrafelman]

If you still want to store the images in the database, then you'll have to modify your script structure.

You can't simply include the image data in-line with the HTML. (Okay, you can if you base64 encode it and use a special version of the IMG tag, but this is rarely used).

Instead, you need to do something like:

<img src="image.php?id=123">

and then have an image.php script that does something like what you have above; query the DB, get the image data, output the appropriate Content-Type header using [man]header/man, and then echo out the image data.