How to read flash image from MySQL

Volitics

Hello.

I'm trying to read a flash file from a MySQL database. The following works ok for a gif image but won't work with a flash.

I would appreciate if someone could shed some light on it.

$Query = "SELECT BinData,FileType FROM Table";
$Result = @ mysql_query($Query);

$Data = @ mysql_result($Result,0,"BinData");
$Type = @ mysql_result($Result,0,"FileType");

Header( "Content-type: $Type");

// if $Type is "image/gif" then <img src="$Data"> outputs image.
// Note the $Data is jibberish in the source code but gif image outputs ok.

// if $Type is "application/x-shockwave-flash" it will still output
// the jibberish (like for the gif) but the flash won't display on the page.

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
  codebase="http://active.macromedia.com/flash4/cabs/swflash.cab#version=4,0,0,0"
  id="Menu" width="468" height="60">
  <param name="movie" value="<?php echo $Data;?>">
  <param name="quality" value="high">
  <param name="bgcolor" value="#FFFFFF">
  <embed name="Menu" src="<?php echo $Data;?>" quality="high" bgcolor="#FFFFFF"
    width="468" height="60"
    type="application/x-shockwave-flash"
    pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">
  </embed>
</object>

dgrinberg

You cant directly add the movie data into the HTML like that, as the browser doesn't know how to interpret that information.

What you need to do in the HTML is call a different PHP page.

For example:

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
  codebase="http://active.macromedia.com/flash4/cabs/swflash.cab#version=4,0,0,0"
  id="Menu" width="468" height="60">
  <param name="movie" value="movie.php?id=1234">
  <param name="quality" value="high">
  <param name="bgcolor" value="#FFFFFF">
  <embed name="Menu" src="movie.php?id=1234" quality="high" bgcolor="#FFFFFF"
    width="468" height="60"
    type="application/x-shockwave-flash"
    pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">
  </embed>
</object>

And then in movie.php you output the movie data.

 $Query = "SELECT BinData,FileType FROM Table WHERE id=".$_GET['id'];
$Result = @ mysql_query($Query);

$Data = @ mysql_result($Result,0,"BinData");
$Type = @ mysql_result($Result,0,"FileType");

Header( "Content-type: $Type"); 

echo $Data;

HTH

Volitics

dgrinberg;

Thanks for the help. You're right. I got it working.

Yesterday afternoon when I first started tinkering with it the flash was working. Then it quit working. I thought I might have been mistaken about it working earlier. I was beginning to wonder if the idea was even workable.

Thanks again for the help.