AYUDA - Extrayendo y mostrando Flash

T4ke0veR · #1 (**permalink**) 30/01/2008, 08:13

Saludos tengo un pequeño problema al subir y extraer archivos .swf de la base de datos.
Estos suben perfectamente pero al extraerlos en la pagina destino me dice q no se pudo cargar la pelicula
aqui les muestro

Código PHP:

  <?php require_once('Connections/incomed.php'); ?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 

{

  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 
  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

$colname_Recordset1 = "-1";

if (isset($_GET['id'])) {

  $colname_Recordset1 = $_GET['id'];

}

mysql_select_db($database_incomed, $incomed);

$query_Recordset1 = sprintf("SELECT * FROM productos WHERE id = %s", GetSQLValueString($colname_Recordset1, "int"));

$Recordset1 = mysql_query($query_Recordset1, $incomed) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<!-- saved from url=(0014)about:internet -->

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>..// I N C O M E D //..</title>

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

<style type="text/css">td img {display: block;}body {

    background-image: url(images/fondofondo.jpg);

}

</style>

<!--Fireworks CS3 Dreamweaver CS3 target.  Created Wed Dec 19 10:36:51 GMT-0400 2007-->

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>

<link href="css/estilos.css" rel="stylesheet" type="text/css" />

</head>

<body bgcolor="#ffffff">

<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">

<!-- fwtable fwsrc="interno3.png" fwpage="ficha prod" fwbase="ficha_prod.gif" fwstyle="Dreamweaver" fwdocid = "365333443" fwnested="0" -->

  <tr>

   <td width="9"><img src="spacer.gif" width="9" height="1" border="0" alt="" /></td>

   <td width="177"><img src="spacer.gif" width="177" height="1" border="0" alt="" /></td>

   <td width="8"><img src="spacer.gif" width="8" height="1" border="0" alt="" /></td>

   <td width="265"><img src="spacer.gif" width="265" height="1" border="0" alt="" /></td>

   <td width="22"><img src="spacer.gif" width="21" height="1" border="0" alt="" /></td>

   <td width="82"><img src="spacer.gif" width="80" height="1" border="0" alt="" /></td>

   <td width="3"><img src="spacer.gif" width="3" height="1" border="0" alt="" /></td>

   <td width="81"><img src="spacer.gif" width="79" height="1" border="0" alt="" /></td>

   <td width="3"><img src="spacer.gif" width="3" height="1" border="0" alt="" /></td>

   <td width="82"><img src="spacer.gif" width="80" height="1" border="0" alt="" /></td>

   <td width="13"><img src="spacer.gif" width="13" height="1" border="0" alt="" /></td>

   <td width="12"><img src="spacer.gif" width="12" height="1" border="0" alt="" /></td>

   <td><img src="spacer.gif" width="10" height="1" border="0" alt="" /></td>

   <td width="4"><img src="spacer.gif" width="1" height="1" border="0" alt="" /></td>

  </tr>

 
  <tr>

   <td rowspan="15" bgcolor="#FFFFFF">&nbsp;</td>

   <td colspan="11" rowspan="2" bgcolor="#FFFFFF"><img name="ficha_prod_r1_c3" src="images/banner.jpg" width="741" height="152" border="0" id="ficha_prod_r1_c3" alt="" /></td>

   <td width="12" rowspan="15" bgcolor="#FFFFFF">&nbsp;</td>

   <td><img src="spacer.gif" width="1" height="41" border="0" alt="" /></td>

  </tr>

  <tr>

   <td><img src="spacer.gif" width="1" height="111" border="0" alt="" /></td>

  </tr>

  <tr>

   <td height="6" colspan="11" bgcolor="#FFFFFF"></td>

   <td><img src="spacer.gif" width="1" height="6" border="0" alt="" /></td>

  </tr>

  <tr>

   <td rowspan="4" bgcolor="#FFFFFF"><img name="ficha_prod_r4_c3" src="images/menu.jpg" width="177" height="208" border="0" id="ficha_prod_r4_c3" alt="" /></td>

   <td rowspan="12" bgcolor="#FFFFFF">&nbsp;</td>

   <td colspan="9" bgcolor="#FFFFFF"><img name="ficha_prod_r4_c5" src="images/titulo_prod.gif" width="556" height="56" border="0" id="ficha_prod_r4_c5" alt="" /></td>

   <td><img src="spacer.gif" width="1" height="56" border="0" alt="" /></td>

  </tr>

  <tr>

   <td height="6" colspan="9" bgcolor="#FFFFFF"></td>

   <td><img src="spacer.gif" width="1" height="6" border="0" alt="" /></td>

  </tr>

  <tr>

   <td height="17" colspan="9" bgcolor="ffffff">&nbsp;</td>

   <td><img src="spacer.gif" width="1" height="17" border="0" alt="" /></td>

  </tr>

  <tr>

   <td width="256" rowspan="9" valign="top" bgcolor="ffffff"><table width="100%" border="0" cellspacing="0" cellpadding="0">

     <tr>

       <td width="3%" class="tituloINDEX">&nbsp;</td>

       <td width="97%" class="tituloINDEX"><?php echo $row_Recordset1['titulo']; ?></td>

     </tr>

     <tr>

       <td colspan="2">&nbsp;</td>

     </tr>

     <tr>

       <td colspan="2" class="textoINDEX"><div align="justify"><?php echo $row_Recordset1['comen']; ?></div></td>

     </tr>

   </table></td>

   <td colspan="8" rowspan="3" valign="top" bgcolor="#D8D8CC"><script type="text/javascript">

AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','300','height','237','src','images/<?php echo $row_Recordset1['flash']; ?>','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','images/<?php echo $row_Recordset1['flash']; ?>' ); //end AC code

</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="300" height="237">

     <param name="movie" value="images/<?php echo $row_Recordset1['flash']; ?>" />

     <param name="quality" value="high" />

     <embed src="images/<?php echo $row_Recordset1['flash']; ?>" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="300" height="237"></embed>

   </object></noscript></td>

   <td><img src="spacer.gif" width="1" height="129" border="0" alt="" /></td>

  </tr>

  <tr>

   <td height="8" bgcolor="#FFFFFF"></td>

   <td><img src="spacer.gif" width="1" height="8" border="0" alt="" /></td>

  </tr>

  <tr>

   <td rowspan="7" bgcolor="#FFFFFF"><img name="ficha_prod_r9_c3" src="images/banner_prod.gif" width="177" height="302" border="0" id="ficha_prod_r9_c3" alt="" /></td>

   <td><img src="spacer.gif" width="1" height="80" border="0" alt="" /></td>

  </tr>

  

    <td height="112" colspan="8" rowspan="4" bgcolor="#D8D8CC"><table width="257" border="0" align="center" cellpadding="0" cellspacing="0">

      <tr>

        <td><?php         $producto_id=$row_Recordset1['id']; 

                                include('img_inc.php');

 ?></td>

      </tr>

    </table></td>

    <td height="5">&nbsp;</td>

 

  <tr>

   <td height="5"><img src="spacer.gif" width="1" height="53" border="0" alt="" /></td>

  </tr>

  <tr>

   <td height="3"><img src="spacer.gif" width="1" height="3" border="0" alt="" /></td>

  </tr>

  <tr>

    <td><img src="spacer.gif" width="1" height="53" border="0" alt="" /></td>

  </tr>

  <tr>

   <td colspan="7" bgcolor="#D8D8CC">&nbsp;</td>

   <td bgcolor="#D8D8CC">&nbsp;</td>

   <td><img src="spacer.gif" width="1" height="28" border="0" alt="" /></td>

  </tr>

  <tr>

   <td colspan="7" bgcolor="#FFFFFF">&nbsp;</td>

   <td bgcolor="#FFFFFF">&nbsp;</td>

   <td><img src="spacer.gif" width="1" height="85" border="0" alt="" /></td>

  </tr>

  <tr>

   <td height="9" colspan="13" bgcolor="#FFFFFF"></td>

   <td><img src="spacer.gif" width="1" height="9" border="0" alt="" /></td>

  </tr>

  <tr>

   <td colspan="13" valign="top"><p style="margin:0px"></p></td>

   <td><img src="spacer.gif" width="1" height="8" border="0" alt="" /></td>

  </tr>

  <tr>

   <td bgcolor="#FFFFFF">&nbsp;</td>

   <td colspan="11" bgcolor="#FFFFFF"><img name="ficha_prod_r17_c3" src="images/abajofon.jpg" width="741" height="40" border="0" id="ficha_prod_r17_c3" alt="" /></td>

   <td bgcolor="#FFFFFF">&nbsp;</td>

   <td><img src="spacer.gif" width="1" height="40" border="0" alt="" /></td>

  </tr>

</table>

z

</body>

</html>

<?php

mysql_free_result($Recordset1);

?>

GatorV · #2 (**permalink**) 30/01/2008, 09:30

¿Ya comprobaste que la ruta del swf sea la correcta?, es decir que cuando se imprime el código HTML, ves el código fuente y ¿ves la ruta al swf correctamente?

Saludos.

T4ke0veR · #3 (**permalink**) 30/01/2008, 09:59

ok .... por lo que veo las rutas estan bien ahora fijate.... hice uno d esta manera
include:

Código PHP:

  <?php include('Connections/incomed.php');

 
@$cat=$_REQUEST['id'];

 
$fotos = array();

        $sql="SELECT  *  FROM flash where id_pro=".$producto_id."";

mysql_select_db ('incomed');

    $sql_exec=mysql_query($sql);

    ?>

    <table width="300" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr>

    <td><script type="text/javascript">AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','300','height','237','src','images/<?php echo $row_Recordset1['flash']; ?>','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','images2/<?php echo $row_Recordset1['flash']; ?>' ); //end AC code

</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="300" height="237">

     <param name="movie" value="images2/<?php echo $row_Recordset1['flash']; ?>" />

     <param name="quality" value="high" />

     <embed src="images2/<?php echo $row_Recordset1['flash']; ?>" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="300" height="237"></embed>

   </object></td>

  </tr>

</table>

y en la pagina donde hago el include declaro

Código PHP:

  <?php         $producto_id=$row_Recordset1['id']; 

                                include('inc_flash.php');

 ?>