Hi,
this is my first post and perhaps I am not seeing this or the fact that Ive never really programmed in flash before but I am trying to include a Variable from PHP which queries a database with a dynamic file…
Obviously I have marked out passwords with “*”
Here is My Php file to display the variables I need
<?
include '../system/sqlconnect.php';
//LOADER CLASS This connects the database, the Dynamic file
// first lets connect to our database
$dbcnx = @mysql_connect("localhost","****","*****");
$dbselect = @mysql_select_db("database");
if ((!$dbcnx) || (!$dbselect)) { echo "Can't connect to database"; }
// next, we must query for a list of titles, files and links. The Title Videoid sets the unique file to be
//played and is Database function which we must combine with the Player.
$query = "SELECT videoid FROM database_video";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
//cool now play the bad *** file
$videoid= '{player.videoid}'+ $;
$localmode= '{player.localmode}';
$user= '{video.user}';
$r_id='{player.r_id}';
while($row = mysql_fetch_array($result)){
echo " $videoid=[player.videoid]";
}
?>
Next We have my Flash File
/* first We must create a new instance of the LoadVars object */
myVars = new LoadVars();
// call the load method to load my php page
myVars.load("./index.php", "POST");
// once vars have been loaded, we will have these variables:
myVars.videoid // "Video ID"
// Set the flashvars
Stage.align = "TL";
var width = "280";
var height = "315";
var autostart = "true";
function foo()
{
var file= ("./system/cache/videos/" +_root.videoid + ".mp3");
}
var file= "http://www.drakewire.com/system/cache/videos/" + $videoid + ".mp3";
// Start the player
var mpl = new com.drake.players.player(this.player);
What I need to do is have the flash file pull in videoid which is a string on a dynamic link from the page where the player resides. VideoID is dynamically created in the Mysql Database…
Can anyone help and tell me how to get this dynamically into the flash file?
Three days of searching everywhere and still havent found an answer
