PHP/MySQL Flash

thekidscareya

I have this PHP/MySQL code

 
<html>
<head>
<title>Clips</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php
# Get MySQL details
include 'conf_global.php';

# Define connection to MySQL server
$connection = mysql_connect($INFO['sql_host'],$INFO['sql_pass'],$INFO['sql_user']) or die("Cannot connect to MySQL server.");

# Connect to Database
mysql_select_db($INFO['sql_database'],$connection) or die("Cannot connect to database.");

# Rename Variable
$id = $GET['id'];

# Rename Table Prefix
$INFO['sql_tbl_prefix'] = $prefix;

# Define query to get movie file name
$sql = "SELECT * FROM {$prefix}clips WHERE `ClipID` = '".$id."'";

# Get Movie File Name
$query = mysql_query($sql) or die("Cannot perform query.");

# Make Query into an array
while($row = mysql_fetch_array($query))
	{
	# Rename Clip Details
	$row['Filename'] = $clip;
	$row['Category'] = $cat;
	$row['Name'] = $name;

# Rename what size to play clip in
$row['Width'] = $width;
$row['Height'] = $height;
}
?>
<div align="left">Category: <?php echo "$cat"; ?><br>
</div>
<div align=center>
  PLAYING <strong><?php echo "$name"; ?></strong> 

<br>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="<?php echo "$width"; ?>" height="<?php echo "$height"; ?>">
  <param name="movie" value="<?php echo "clips.swf?play={$clip}"; ?>">
  <param name="quality" value="high">
  <embed src="<?php echo "clips.swf?play={$clip}"; ?>" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="<?php echo "$width"; ?>" height="<?php echo "$height"; ?>"></embed></object>
</div>
</body>
</html>

If you read the code, you will pretty much see what I'm trying to do. I don't know Flash MX very well, but I do know some SwishMax. I have both pieces of software and I was wondering if someone would be kind enough to show me how I should exactly make clips.swf so that it would work with this script.

I'm trying to base this off of IPB 1.3.1 as a mod for a clip gallery.

Thanks for all your help in advance. I really appreciate it.

Chris_Evans

Hi there,
Ok, first off:

    # Rename Clip Details 
    $row['Filename'] = $clip; 
    $row['Category'] = $cat; 
    $row['Name'] = $name; 

# Rename what size to play clip in 
$row['Width'] = $width; 
$row['Height'] = $height;

...should be:

    # Rename Clip Details 
    $clip = $row['Filename'];
    $cat = $row['Category'];
    etc etc etc

Second - if I'm not mistaken you're just trying to load a different movie each time.

If this is the case, just do this:

<embed src="<?php echo "$clip"; ?>"

That will work perfectly! 🙂 At least, assuming I understood you correctly, since I'm working from the names of your fields etc.