Forums
This topic is locked
Image Upload to Database and Displaying image
Posted 14 Mar 2005 18:09:45
1
has voted
14 Mar 2005 18:09:45 Olatunde Baruwa posted:
I'm still a beginner and i have been encountering problems with database and front ends.The problem:
I want to know how to upload image to database and how to retrieve it to display.What are steps i'm supposed to take?I will be glad if i'm able to overcome this?
Thanks
Replies
Replied 14 Mar 2005 19:35:59
14 Mar 2005 19:35:59 Simon Martin replied:
There is a very handy extension on DMX zone Pure ASP Upload www.dmxzone.com/ShowDetail.asp?NewsId=1622 and used with Smart Image Processor www.dmxzone.com/showDetail.asp?TypeId=3&NewsId=3965 you should be able to upload images and make sure that you dont end up with huge 5mb bmp files clogging up your site.
Each extension has tutorials that will help you get up to speed on using them.
Generally speaking I would upload the image name to your database rather then trying to store the image in the database (if you want to look this up the data type is a BLOB) this will save bloating your DB unnecessarily. You would simply then return the image name in your recordset and use it in your <img src...>
Live the life you love
Love the life you live
~ ~ ~ ~ ~ ~ ~
<b>Simon Martin</b> - <i>DMXzone Manager</i>
<font size=1>[ Dreamweaver MX/MX2004 | ASP | SQL | XHTML/CSS | Web Accessibility ] </font id=size1>
Each extension has tutorials that will help you get up to speed on using them.
Generally speaking I would upload the image name to your database rather then trying to store the image in the database (if you want to look this up the data type is a BLOB) this will save bloating your DB unnecessarily. You would simply then return the image name in your recordset and use it in your <img src...>
Live the life you love
Love the life you live
~ ~ ~ ~ ~ ~ ~
<b>Simon Martin</b> - <i>DMXzone Manager</i>
<font size=1>[ Dreamweaver MX/MX2004 | ASP | SQL | XHTML/CSS | Web Accessibility ] </font id=size1>