PHP/Mysql Flash problem!!!

phoenix211984

I am trying to write my own php mysql banner advertising system. i have written imported images to the mysql table and i have got the php code to return normal images files e.g .gif, .jpeg etc. for flash banners i know that the headers are different can anyone give me any advice on how to get the flash image with headers into a php webpage in dreamweaver. i guess the other way of doing it is putting the imported files into a folder and dynamically embedding them into the webpage. if anybody has any ideas or code example it would be much appreciated.

void_function

Content-type: application/x-shockwave-flash

However, the browser is responsible for recognizing the content, since you can't put a flash object into IMG tag. The very fact that you're embedding with <embed> and <object> tags tells the browser that they're dealing with a flash object.

So the code for presenting the banner on the screen needs to know in advance which object it fetches, and image or flash, and along with that inserts the ID for your script that returns the object itself from the database.

Although I suggest leaving the objects and images outside the database. Have their names like img1234.jpg where 1234 is the ID of the banner in the database (with all the metadata).

void_function

Simplest code for client-side page, files are static on the disc, not in database:

$id= getBannerId(); // get next banner ID here, randomly or whatever

$query= "SELECT type, url, title FROM banners WHERE id=$id LIMIT 1";
$res= mysql_query($query);
$obj= mysql_fetch_object($res);

// The "type" field contains image file extension or "flash" if it is a flash object

if ($obj->type=='flash') {
  // echo here the <embed> and <object> tags with whatever parameters
  // Naturally, you don't wrap into <a> tags, since flash should have its own internal onclick response
} else {
  echo "<a href=\"{$obj->url}\" title=\"{$obj->title}\"><img src=\"bannerimages/img{$id}.{$obj->type}\" alt=\"{$obj->title}\"/></a>\n";  // Remove the endtag if you don't output in XHTML
}