Reading Flash SWF from MySQL?

halex

Hello!

I have MySQL table with primary key "id" and with second column of blob type called "flash_movie". In that second column is saved Flash SWF file (as byte sequence) and I need to read content of that column (by passed "id") and to display that Flashmovie.
I have a problem doing that. How I can create a Flash preview for these SWF movies stored in database?

If I am not wrong this is for displaying FLASH. I need to fill "flash_object_id", "movie_url" so I would put as "flash_object_id" id value from database and as "movie_url" url to SWF movie stored in "flash_movie" field in database. How to do this?

<object id="flash_object_id" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"  codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,0,0" id="104314749518" width="120" height="60">
<param name="movie"  value="movie_url" />
<param name="quality" value="high"/>
<embed src="movie_url" quality="high" swLiveConnect="false" width="120" height="60" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">
</embed>
</object>

spstieng

Do you HAVE to save the flash files in the DB?

Couldn't you just save them on the server and just put the file name in the second table field? (movie_url)

Then again, what do I know. Just sounds more logical to me.

halex

Hello,

That is true that it would be easy if I could have SWF files. But I don't have it and the SFW files are in database. Database is not mine. I need to use these bytes and to display that as Flash movie in preview page.

Problem is when I give URL in OBJECT (PARAM) tag that goes to some page I need on that page load SWF from database. How to make that file Header?