Insert Audio, Video and Image - Very Urgent

[sathysudha]

Friends
I am developing a form in that im having the following.

1. ID
2. animalphoto (image file)
3. animalsound (sound file ie.,wav or other)
4. animalvideo (avi or mpeg)
5. remarks

the user will enter the id and they will select the image,sound and video also they will enter the remarks.

now how can i store all the above five in the server and when they request a page i have to display all the entered values.

my doubt is how can i store the image,sound and video in a server or in a database and how can i retrieve those.

I know how to store the normal data's in the database but i dont know how to store the image,sound and video file in the server or in a database. Also i want to know how can i retrieve it when the user request it.

pls help in this matter as soon as possible.

thanks

[lillu]

Hi,

This is a great tutorial on storing images in a database using ASP.

http://www.sagas.net/asp/show.aspx?abcd=93

What I know is that it's best not to store images in the database, rather, store only a reference to the image in the database, ie, a text field
containing "c:\wwwroot\images\pic1.jpg"

[CardboardHammer]

If you're using ASP.NET and a DBMS at least as good as SQL Server, you could be better served storing the files within the database itself, as you wouldn't have to worry about trying to avoid filename collisions, and other reasons... Probably goes beyond the scope of what you're doing, but just figured I'd float it out there...

[CTempleman]

Are you working from a pre-defined selection of images and animal sounds? Or are you allowing them to "upload" these from files?

If you working with presets I would just store a reference to each file under the specific ID.

If you allowing them to upload, you would want to consider using a upload object that allows you to rename the file before it is placed on the server (depending on your host), this way you avoid file name collision and so on. You could even just make the user have a specific login that uploads to a particular folder. Most of this would be easy to code in ASP or ASP.NET.


Originally posted by sathysudha
Friends
I am developing a form in that im having the following.

1. ID
2. animalphoto (image file)
3. animalsound (sound file ie.,wav or other)
4. animalvideo (avi or mpeg)
5. remarks

the user will enter the id and they will select the image,sound and video also they will enter the remarks.

now how can i store all the above five in the server and when they request a page i have to display all the entered values.

my doubt is how can i store the image,sound and video in a server or in a database and how can i retrieve those.

I know how to store the normal data's in the database but i dont know how to store the image,sound and video file in the server or in a database. Also i want to know how can i retrieve it when the user request it.

pls help in this matter as soon as possible.

thanks