how to store and manipulate images in database?
EmailShowing comments 1 to 4 of total 4 on page 1 of 1
sampuraRank: 107
hi..
in my current project, i want to store the image of users using my database. can anyone tell me how to store, update and delete these images?
im usin java as front end and sql as back end.
pradeepRank: 26
You'll have to keep a table for keeping the image details, say like, user_images. And you should have a folder in your server for keeping these image files. You can identify each file by giving the imageId as the filename. That will make sure it stays unique. The user details table should have a field that specifies the imageId for that particular user.
- If the image is edited then update the imageId field in image table with the new details.
- If it is deleted then remove the imageId from the user details table.
SajivRank: 24
check BFILE or BLOB
robinalexRank: 1
See this articles:
http://www.databasejournal.com/features/mssql/article.php/3719221/Storing-Images-and-BLOB-files-in-SQL-Server.htm
http://www.sqlteam.com/article/images-and-sql-server
Other than this, you can also chek out "PureASP upload" which has some sample codes to upload binary files to database:
http://www.motobit.com/help/scptutl/upload.asp