All,

I have stored a WMV Video file in a Blob format in a MySQL database.

What I want to do now is to be able to insert a link into a Object class so I can stream the video. You know the embeded Windows Media Players.

Would this be possible?

Yes, Put a link to a file that has a WMV video file header, then echo the information from the database. For example:

PHP Code:

// We'll be outputting a WMV
header('Content-type: application/wmv');

// It will be called downloaded.wmv
header('Content-Disposition: attachment; filename="downloaded.wmv"');

// Now echo the contents
echo "Info from database"; 


Thats not 100% correct, but a good start

Here is what I have so far

PHP Code:

$query = "SELECT * FROM video"; 
$result  = mysql_query($query) or die('Error, query failed'); 
$row = mysql_fetch_array( $result ); 

    header("Content-Disposition: attachment; filename=$row[videoname]"); 
    header("Content-length: $row[size]"); 
    header("Content-type: $row[type]"); 


The row - videoname is the actual file name so i.e. thisismyvideo.wmv
The size row is how big the file size is. The Type stores the type of file the video is so video/x-ms-wmv.

Then finaly there is another row (not mentioned above) called 'content' that is the actual BLOB.

Just confused where I should go next. Should I include the row 'content' (the blob) in the above somewhere?

Because what I need to do is get it so I can stream it via this:

<OBJECT id="VIDEO" width="320" height="240" 
    style="position:absolute; left:0;top:0;" 
    CLASSID="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6" 
    type="application/x-oleobject"> 
    <PARAM NAME="URL" VALUE=">URL HERE"> 
    <PARAM NAME="SendPlayStateChangeEvents" VALUE="True"> 
    <PARAM NAME="AutoStart" VALUE="True"> 
    <PARAM name="uiMode" value="none"> 
    <PARAM name="PlayCount" value="9999"> 
</OBJECT

Put a link in that code above where it says "<PARAM NAME="URL" VALUE="URL HERE">
" to a file that runs the #1 code.

That won't work because there is no "URL" as such. The video is stored as a BLOB in the MySQL Database. If I echo the BLOB ('content' row) then it just displays lots and lots and lots of numbers and characters.

I'm just not sure how to basicaly convert it back from BLOB into a URL Form so it can be streamed.

Any ideas?