Mysql and .swf files....

Codes here !

Moderators: macek, egami, gesf

Sleeping_Sloth
New php-forum User
New php-forum User
Posts: 9
Joined: Wed Jan 08, 2003 2:43 pm

Mysql and .swf files....

Postby Sleeping_Sloth » Tue Mar 18, 2003 8:40 am

Hey everyone...

Does anyone have any experience storing.swf files in a Mysql database? (or any database for that matter...)

I can store the files as LONGBLOBs, they store fine, the problem is calling them back out again - because they're referenced in the HTML OBJECT tag TWICE- once to place the file, and once to insert the data, I can't get HTML to accept the retrieved BLOBs.

a) does this make sense to anybody?
b) can anyone offer a solution to this problem?

All input warmly welcomed! :)

Thanks all,

Sleeping_Sloth

User avatar
Redcircle
Moderator
Moderator
Posts: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact:

Postby Redcircle » Tue Mar 18, 2003 10:06 am

post some code so we can see what you are doing.

Sleeping_Sloth
New php-forum User
New php-forum User
Posts: 9
Joined: Wed Jan 08, 2003 2:43 pm

Postby Sleeping_Sloth » Tue Mar 18, 2003 3:40 pm

This is the latest attempt... I've dropped the <OBJECT> tag, but even with just the <EMBED> tag, this just dumps binary data onto the screen. This is the only php in the html page that is supposed to show the flash...(and I know the flash is stored in the database...)

$doesit="SELECT Flash_aaah FROM Tutorial WHERE Tutorial_Id='Tut1'";
$result = mysql_query($doesit);
$tut= @mysql_result($result,0,"Flash_aaah");

print"<embed src=\"$tut" quality=\"high\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\"776\" height=\"368\"></embed>";

Hope this offers some idea of what I'm up to....

Thanks... Sleeping_Sloth

Xerpher
New php-forum User
New php-forum User
Posts: 164
Joined: Tue Aug 27, 2002 8:25 pm
Location: Ontario, Canada
Contact:

Postby Xerpher » Tue Mar 18, 2003 4:06 pm

Wouldn't you have to relatively do the same thing that we discussed here?


Return to “mySQL & php coding”

Who is online

Users browsing this forum: No registered users and 1 guest