Displaying video from MySQL database?

john1704

Hello,

I'm building a video upload database for a project I'm working on, and needed some help.

Now, all of the scripts are in place. Everything works perfectly, except for one tiny thing: the video doesn't display.

Here is how it's setup: one file, view.php?id=ID_HERE displays the video and shows related information, such as filesize, name, and file type. That page has an embed tag that links to another file, video.avi?id=ID_HERE. This id number corresponds with what the view.avi?id=ID_HERE. Now, when I go to view.avi?id=ID_HERE, it downloads perfectly, but when I go to view it on view.php?id=ID_HERE, the video doesn't display properly. Here is how it is:

The video is an avi file, by the way. The embed tag wouldn't take a PHP file for the src attribute. However, I have it so avi files on that directory are parsed as PHP files, just so the stupid embed tag would work. But it doesn't! This is how it displays:

http://www.johninteractive.net/files/uploadedfiles/windowsmediaerror.PNG

Can anybody tell me what's wrong with displaying the avi file from MySQL and how to fix it?

Thanks.

rsmith

Did you actually store the video in the database? If so you should consider uploading the file and storing the PATH in the database, then reference the path in your scripts. This is a) a best-practice and b) keeps the size of your db from growing out of control

sheephat

I asume that the browser is tring to load "video.avi?id=1" the file, where as if you changed it to video.php?id=1 and the video.php file defines the location of the file.