Viewing file:  asignar-filtro-categoria.php (2.03 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
$pagina_actual="administrar-publicidades";
$categoria_actual="publicidades";
require_once("includes/config.php");
require_once("includes/funciones.php");
if (isset($_GET["id"])){
$id=$_GET["id"];
}
if (isset($_POST["id"])){
$id=$_POST["id"];
}
if (count($_POST)>0) {
$result = $mysqli->query("
DELETE FROM renglon_categoria_filtro
WHERE id_categoria='$id'");
foreach ($_POST as $clave => $valor){
$result=$mysqli->query("
INSERT INTO renglon_categoria_filtro (id_categoria, id_filtro)
VALUES ('$id','$clave')
");
}
header('Location: administrar-categorias-clientes.php');
}
$filtros_activos = $mysqli->query("
SELECT id_filtro
FROM renglon_categoria_filtro
WHERE id_categoria='$id'");
$array_filtros_activos=array();
while ($filtro = mysqli_fetch_assoc($filtros_activos)){
$array_filtros_activos[$filtro["id_filtro"]]="si";
}
$filtros = $mysqli->query("
SELECT nombre, id
FROM filtro
ORDER BY nombre
");
?>
<div class="modal-content">
<form method="post" action="asignar-filtro-categoria.php">
<input type="hidden" name="id" value="<?=$id?>">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title"></h4>
</div>
<div class="modal-body">
<div class="form-group">
<label>Filtros</label>
</div>
<div class="lista_checkbox clearfix">
<? while ($item = mysqli_fetch_assoc($filtros)){?>
<div class="form-group">
<label>
<input class="form-control" name="<?=$item["id"]?>" type="checkbox" <?=isset($array_filtros_activos[$item["id"]])?"checked":""?>><?=utf8_encode($item["nombre"])?>
</label>
</div>
<? }?>
</div>
</div>
<div class="modal-footer">
<a href="#" class="btn btn-white" data-dismiss="modal">Cerrar</a>
<input type="submit" class="btn btn-primary" value="Asignar">
</div>
</form>
</div><!-- /.modal-content -->
|