Administrador de slider problema

josebr1991 · #1 (**permalink**) 03/08/2013, 18:34

Hola, tengo dos problemas realmente, el primero que las fotos no se visualizan en miniatura en la lista principal de sliders

Código:

http://reparotuordenador.com/_admin/slider_lista.php

el segundo que al añadir un slider en todos aparece las dos misma fotos añadidas en todos, o se modifican la mismas en todos, no se que estoy haciendo mal

el codigo del slider_edit

Código:

<?php require_once('../Connections/conexionreparo1.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $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;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE tblslider SET strImagenGrande=%s, strImagenPequena=%s, strTitulo=%s, srtSubtitulo=%s, strMenu=%s, strLink=%s, intOrden=%s, intEstado=%s WHERE idContador=%s",
                       GetSQLValueString($_POST['strImagenGrande'], "text"),
                       GetSQLValueString($_POST['strImagenPequena'], "text"),
                       GetSQLValueString($_POST['strTitulo'], "text"),
                       GetSQLValueString($_POST['srtSubtitulo'], "text"),
                       GetSQLValueString($_POST['strMenu'], "text"),
                       GetSQLValueString($_POST['strLink'], "text"),
                       GetSQLValueString($_POST['intOrden'], "int"),
                       GetSQLValueString($_POST['intEstado'], "int"),
                       GetSQLValueString($_POST['idContador'], "int"));

  mysql_select_db($database_conexionreparo1, $conexionreparo1);
  $Result1 = mysql_query($updateSQL, $conexionreparo1) or die(mysql_error());

  $updateGoTo = "slider_lista.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE tblslider SET strImagenGrande=%s, strImagenPequena=%s, strTitulo=%s, srtSubtitulo=%s, strMenu=%s, strLink=%s, intOrden=%s, intEstado=%s WHERE idContador=%s",
                       GetSQLValueString($_POST['strImagenGrande'], "text"),
                       GetSQLValueString($_POST['strImagenPequena'], "text"),
                       GetSQLValueString($_POST['strTitulo'], "text"),
                       GetSQLValueString($_POST['srtSubtitulo'], "text"),
                       GetSQLValueString($_POST['strMenu'], "text"),
                       GetSQLValueString($_POST['strLink'], "text"),
                       GetSQLValueString($_POST['intOrden'], "int"),
                       GetSQLValueString($_POST['intEstado'], "int"),
                       GetSQLValueString($_POST['idContador'], "int"));

  mysql_select_db($database_conexionreparo1, $conexionreparo1);
  $Result1 = mysql_query($updateSQL, $conexionreparo1) or die(mysql_error());

  $updateGoTo = "slider_lista.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

mysql_select_db($database_conexionreparo1, $conexionreparo1);
$query_Recordset1 = "SELECT * FROM tblslider";
$Recordset1 = mysql_query($query_Recordset1, $conexionreparo1) 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">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/plantilladmin.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Administraci&oacute;n Reparo</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<link href="../css/estiloadmin.css" rel="stylesheet" type="text/css" />
</head>

<body>

<div class="container">
  <div class="header"><?php include("../includes/cabecera_admin.php"); ?></div>
  <div class="sidebar1"><?php include("../includes/menuizquierda_admin.php"); ?>

    <p>&nbsp;</p>
    <!-- end .sidebar1 --></div>
  <div class="content"><!-- InstanceBeginEditable name="Partederechaadmin" -->
  
    <script>
function subirimagen(nombrecampo)
{
self.name = 'opener';
remote = open('gestionimagen.php?campo='+nombrecampo, 'remote', 'with=400, height=150, location=no, scrollbars=yes, menubars=no, toolbars=no, resizable=yes, fullscreen=no, status=yes');
remote.focus();
}
</script>
    <h1>Editar Publicidad</h1>
    <p>&nbsp;</p>
    <form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
      <table align="center">
        <tr valign="baseline">
          <td width="131" align="right" nowrap="nowrap">Imagen Grande:</td>
          <td width="353"><p>
            <input type="text" name="strImagenGrande" value="<?php echo htmlentities($row_Recordset1['strImagenGrande'], ENT_COMPAT, 'iso-8859-1'); ?>" size="25" />
            <input type= "button" name="button" id="button" value="Subir Imagen" onclick="javascript:subirimagen('strImagenGrande');"/>
          (734x250px)</p></td>
        </tr>
        <tr valign="baseline">
          <td nowrap="nowrap" align="right">Imagen Peque&ntilde;a:</td>
          <td><input type="text" name="strImagenPequena" value="<?php echo htmlentities($row_Recordset1['strImagenPequena'], ENT_COMPAT, 'iso-8859-1'); ?>" size="25" />
          <input type= "button" name="button2" id="button2" value="Subir Imagen" onclick="javascript:subirimagen('strImagenPequena');"/>
          (80x50px)</td>
        </tr>
        <tr valign="baseline">
          <td nowrap="nowrap" align="right">StrTitulo:</td>
          <td><input type="text" name="strTitulo" value="<?php echo htmlentities($row_Recordset1['strTitulo'], ENT_COMPAT, 'iso-8859-1'); ?>" size="32" /></td>
        </tr>
        <tr valign="baseline">
          <td nowrap="nowrap" align="right">SrtSubtitulo:</td>
          <td><input type="text" name="srtSubtitulo" value="<?php echo htmlentities($row_Recordset1['srtSubtitulo'], ENT_COMPAT, 'iso-8859-1'); ?>" size="32" /></td>
        </tr>
        <tr valign="baseline">
          <td nowrap="nowrap" align="right">StrMenu:</td>
          <td><input type="text" name="strMenu" value="<?php echo htmlentities($row_Recordset1['strMenu'], ENT_COMPAT, 'iso-8859-1'); ?>" size="32" /></td>
        </tr>
        <tr valign="baseline">
          <td nowrap="nowrap" align="right">StrLink:</td>
          <td><input type="text" name="strLink" value="<?php echo htmlentities($row_Recordset1['strLink'], ENT_COMPAT, 'iso-8859-1'); ?>" size="32" /></td>
        </tr>
        <tr valign="baseline">
          <td nowrap="nowrap" align="right">IntOrden:</td>
          <td><input type="text" name="intOrden" value="<?php echo htmlentities($row_Recordset1['intOrden'], ENT_COMPAT, 'iso-8859-1'); ?>" size="32" /></td>
        </tr>
        <tr valign="baseline">
          <td nowrap="nowrap" align="right">IntEstado:</td>
          <td><select name="intEstado">
            <option value="1" <?php if (!(strcmp(1, htmlentities($row_Recordset1['intEstado'], ENT_COMPAT, 'iso-8859-1')))) {echo "SELECTED";} ?>>Activo</option>
            <option value="0" <?php if (!(strcmp(0, htmlentities($row_Recordset1['intEstado'], ENT_COMPAT, 'iso-8859-1')))) {echo "SELECTED";} ?>>Desactivado</option>
          </select></td>
        </tr>
        <tr valign="baseline">
          <td nowrap="nowrap" align="right">&nbsp;</td>
          <td><input type="submit" value="Actualizar registro" /></td>
        </tr>
      </table>
      <input type="hidden" name="MM_update" value="form1" />
      <input type="hidden" name="idContador" value="<?php echo $row_Recordset1['idContador']; ?>" />
    </form>
    <p>&nbsp;</p>
<p>&nbsp;</p>
  <!-- InstanceEndEditable -->
  
    <!-- end .content --></div>
  <div class="footer"><?php include("../includes/pie_admin.php"); ?>
    </div>
  <!-- end .container --></div>
</body>
<!-- InstanceEnd --></html>