php Echo swf file from mysql database

1,337 · September 23, 2013

Hi.

I am having trouble embedding a swf file from a database on a php page. I know how to embed a swf file using just php with the help of swfobject.js but I am having trouble being able to actually show the file from a db. I am not storing the actual file on the database but the path to the flash file (eg games/flashgame1.swf)

I am properly connected to the db so there is no problem there. The table is called games and has two columns for now: id | path

Here is my code:

<?php

 
require_once('config.php');
if (!session_id()) session_start();
?>

<!DOCTYPE html>
<html>
<head>
 
<meta content="text/html; charset=UTF-8" http-equiv="content-type"> <meta name="author" content="Onyx"> 
<link rel="stylesheet" type="text/css" href="<?php echo HTTP_STYLE;?>layout.css" /> 
<link href="<?php echo HTTP_IMAGES;?>favicon.ico"rel="icon" type="image/x-icon" />

</head>

<body>
<div id="wrapper2">   
<div id="container">

<?php $result = mysql_query("SELECT * FROM games");
while($row = mysql_fetch_array($result))  {               

$path = $row['1'];    
$id = $row['0'];    
$width = "546";    
$height = "431";    
$version = "9.0.0";          

}

echo "<script type=text/javascript src=swfobject.js></script>";
echo "<script type=text/javascript>";
echo "swfobject.embedSWF('$path','$id', '$width', '$height', '$version')";
echo "</script>"; ?>
 
</div>
</div>

</body>
</html>

Any ideas what i am doing wrong?

September 23, 2013

Change

echo "swfobject.embedSWF('$path','$id', '$width', '$height', '$version')";

to

echo "swfobject.embedSWF(" . $path . ", " . $id . ", " . $width . ", " . $height . ", " . $version . ")";

1,760 · September 23, 2013

Shouldnt it be mysql_fetch_assoc not array?

1,337 · September 23, 2013

Hey guys. Thanks for the immediate replies.

I tried bot suggestions but unfortunately the swf file still doesn't show up.

September 23, 2013

This

$path = $row['1'];    
$id = $row['0'];

To

$path = $row['path'];    
$id = $row['id'];

With the previous 2 changes.

Not related to the issue, but I would switch to using PDO instead of MySQL_*. Those functions are deprecated and insecure.

1,337 · September 23, 2013

Thanks nesl247.I tried the change you are suggesting as well but unfortunately no swf appears.

Just to be sure I created another column called image, storing paths to images and I can properly echo the image so I am connected to the DB and I have double checked the paths stored to the DB for the swf files are indeed correct.

I have no idea wth is going on.

* I know about the PDO.I am currently just trying to make things work and I will change later. :)

1,760 · September 23, 2013

Thanks nesl247.I tried the change you are suggesting as well but unfortunately no swf appears.

Just to be sure I created another column called image storing paths to images and I can properly echo the image so I am connected to the DB and I have double checked the paths stored to the DB for the swf files are indeed correct.

I have no idea wth is going on.

* I know about the PDO.I am currently just trying to make things work and I will change later. :)

Sounds like something is wrong with your swf helper then.

Oh just noticed you need quotes around your source file location too:

echo "<script src='swfobject.js'></script>";

OR
echo '<script src="swfobject.js"></script>';

And you dont need a script type in HTML5, it assumes its javascript.

2,549 · September 23, 2013

Sounds like something is wrong with your swf helper then.

Oh just noticed you need quotes around your source file location too:
echo "<script src='swfobject.js'></script>";

OR
echo '<script src="swfobject.js"></script>';
And you dont need a script type in HTML5, it assumes its javascript.

echo "<script src=\"swfobject.js\"></script>";

Using \" is better in my opinion in a lot of cases, most people even don't know about this :p

And quotes really aren't that necessary with simple filenames without spaces but yeah it's better to always use them ;)

Sign In

php Echo swf file from mysql database

Question

0nyX

Link to comment

Share on other sites

7 answers to this question

Recommended Posts

Harrison H.

Link to comment

Share on other sites

the better twin

Link to comment

Share on other sites

0nyX

Link to comment

Share on other sites

Harrison H.

Link to comment

Share on other sites

0nyX

Link to comment

Share on other sites

the better twin

Link to comment

Share on other sites

Seahorsepip Veteran

Link to comment

Share on other sites

Recently Browsing 0 members

Similar Content