Video & voice files - MYSQL

[JuniorOnline]

Hello all,

Are there any websites that describe what's needed in order to setup a database that accepts video files? How do i got about uploading the files into the database and display them on the web for people to download and view?

thanks
Tala

[mikesmith76]

i personally wouldn't upload any file content into a database. instead simply upload the video file to a secure part of your server and put the filename into the database. when someone wants to view a file access the database to get the filename, and fetch that file from the secure area.

[JuniorOnline]

aha!! i didnt think of that.
if the person used the location of the file to view the video, do they view the vedio as part of the page? or externally it uploads and open in the person's video player?

thanks again
T

[mikesmith76]

If you had the video files in a publicly accessible place then yes they could view the video directly, i'm guessing this isn't what you want?

You could upload the videos to a directory outside the document root and then read the contents of the file using a script. You would then add a check to see if the script is being called directly, or as part of your main page.

Looking at the sites in your signature i see you are using ASP.NET. If so I haven't got around to playing with that yet so I couldn't give you any code examples, i'm sure someone here must know some though.

[JuniorOnline]

thanks Mike, I am looking into designing another site in PHP, apache and mysql :)