Inserting images

derekburrows

I have a page that is displaying information from a database but I also want to display an image. In the database I have a field for thumbnail which is the image I want to display on the display page. Being new to this I'm stumped. How do I get the image to show up on the display page? I've told the database where the thumbnail is but as I figured out this is not really how to do it.

Thanks

niroshan

Hi derekburrows,

How the image is stored in the table? as binary format (field type = blob) or the image URL (field type = varchar) ?

Regards,
niroshan

derekburrows

I have it stored as an image URL, varchar.

niroshan

Hi derekburrows,
If its the URl then easy. Just read the table get the url into a variable and use it with an image tag to display the image.

<?php
$imgUrl = 'URL taken from the table'
?>
<img src="<?php echo  $imgUrl; ?>" width="" height="" />

Hope this helps,
Regards,
Niroshan

derekburrows

Great, thanks

derekburrows

Another question. So I have that code but not sure how to connect it to the database file. The image url is under thumbnail, I have thumbnail, then thumbnail width and thumbnail height. After $imgUrl = 'what goes here?

Thanks

niroshan

Hi derekburrows,

So I have that code but not sure how to connect it to the database file.

what do you mean? Do you know how to connect to the database and fetch the records from a table?

Regards,
niroshan

derekburrows

Thanks for the reply. I got it sorted out finally. Was just a bit unclear about one thing and its now working