'S','š'=>'s','Ð'=>'Dj','ð'=>'dj','Ž'=>'Z','ž'=>'z','?'=>'C','?'=>'c','?'=>'C','?'=>'c','À'=>'A','Á'=>'A','Â'=>'A','Ã'=>'A','Ä'=>'A','Å'=>'A','Æ'=>'A','Ç'=>'C','È'=>'E','É'=>'E','Ê'=>'E','Ë'=>'E','Ì'=>'I','Í'=>'I','Î'=>'I','Ï'=>'I','Ñ'=>'N','Ò'=>'O','Ó'=>'O','Ô'=>'O','Õ'=>'O','Ö'=>'O','Ø'=>'O','Ù'=>'U','Ú'=>'U','Û'=>'U','Ü'=>'U','Ý'=>'Y','Þ'=>'B','ß'=>'Ss','à'=>'a','á'=>'a','â'=>'a','ã'=>'i','ä'=>'a','å'=>'a','æ'=>'a','ç'=>'c','è'=>'e','é'=>'e','ê'=>'e','ë'=>'e','ì'=>'i','í'=>'i','î'=>'i','ï'=>'i','ð'=>'o','ñ'=>'n','ò'=>'o','ó'=>'o','ô'=>'o','õ'=>'o','ö'=>'o','ø'=>'o','ù'=>'u','ú'=>'u','û'=>'u','ý'=>'y','ý'=>'y','þ'=>'b','ÿ'=>'y','?'=>'R','?'=>'r','á'=>'a','ó'=>'o','ú'=>'u','é'=>'e','Ã'=>'i',"ú" => "u","á" => "a", "é" => "e", "í" => "i" , "ó" => "o", "ú" => "u", "¡" => "","!" => "","@" => "", "#" => "", "$" => "", "%" => "", "^" => "", "&" => "", "*" => "", "(" => "", ")" => "", "[" => "", "]" => "", "{" => "", "}" => "", "¿" => "", "?" => "", "<" => "", ">" => ""," " => "-","." => "","," => "",'Ã�'=>'A','ñ'=>'n'); $reemplazar_title = array('Š'=>'S','š'=>'s','Ð'=>'Dj','ð'=>'dj','Ž'=>'Z','ž'=>'z','?'=>'C','?'=>'c','?'=>'C','?'=>'c','À'=>'Á','Â'=>'A','Ã'=>'A','Ä'=>'A','Å'=>'A','Æ'=>'A','Ç'=>'C','È'=>'É','Ê'=>'E','Ë'=>'E','Ì'=>'Í','Î'=>'I','Ï'=>'I','Ñ'=>'N','Ò'=>'Ó','Ô'=>'O','Õ'=>'O','Ö'=>'O','Ø'=>'O','Ù'=>'Ú','Û'=>'U','Ü'=>'U','Ý'=>'Y','Þ'=>'B','ß'=>'Ss','à'=>'á','â'=>'a','ã'=>'i','ä'=>'a','å'=>'a','æ'=>'a','ç'=>'c','è'=>'é','ê'=>'e','ë'=>'e','ì'=>'i','í'=>'i','î'=>'i','ï'=>'i','ð'=>'o','ñ'=>'n','ò'=>'o','ó'=>'o','ô'=>'o','õ'=>'o','ö'=>'o','ø'=>'o','ù'=>'ú','ú'=>'u','û'=>'u','ý'=>'y','ý'=>'y','þ'=>'b','ÿ'=>'y','?'=>'R','?'=>'r','á'=>'á','ó'=>'ó','ú'=>'ú','é'=>'é','Ã'=>'í',"á" => "a", "é" => "e", "í" => "i" , "ó" => "o", "ú" => "u", "¡" => "","!" => "","@" => "", "#" => "", "$" => "", "%" => "", "^" => "", "&" => "", "*" => "", "(" => "", ")" => "", "[" => "", "]" => "", "{" => "", "}" => "", "¿" => "", "?" => "", "<" => "", ">" => "","." => "","," => "",'Ã�'=>'A','ñ'=>'n'); include("../conectar/conexion.php"); //llamo al archivo de conexion, lo incluyo $link=$conecta; //invoco el metodo de conexion require_once('../conectar/consultas.php'); /**PARA OBTENER LA URL DE LA PAGINA*/ function getUrl() { $s = empty($_SERVER["HTTPS"]) ? '' : ($_SERVER["HTTPS"] == "on") ? "s" : ""; $protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/") . $s; $port = ($_SERVER["SERVER_PORT"] == "80") ? "" : (":".$_SERVER["SERVER_PORT"]); return $protocol . "://" . $_SERVER['SERVER_NAME'] . $port . $_SERVER['REQUEST_URI']; } function strleft($s1, $s2) { return substr($s1, 0, strpos($s1, $s2)); } $url = getUrl(); //echo $url; /*SESSION PARA LAS MONEDAS, CONVERTIR MONEDA*/ if ($_POST['currency'] )/*SI SE RECIBIO ALGO? ENTONCES ASIGNAR LO RECIBIO A LA VARIABLE $MONEDA*/ { $moneda=$_POST['currency']; } else /*NO SE RECIBIO NADA (NO HAY $POST)*/ { /*PREGUNTAR HAY SESSION*/ if(!isset($_SESSION['moneda'])) {/*NO HAY SESSION*/ $moneda="MXN"; $_SESSION['moneda']=$moneda; } else { $moneda=$_SESSION['moneda']; } } /*COMPARAR LO QUE SE TIENE EN LA SESSION CON LA VARIABLE MONEDA*/ if($moneda!=$_SESSION['moneda']) {/*NO ES LO MISMO*/ $_SESSION['moneda']=$moneda; } //Ultima variable de moneda $smoneda=$_SESSION['moneda']; /*Consultar la base de datos*/ $consultaprecio="SELECT * FROM monedas WHERE valor= '$smoneda'"; $resultadoprecio = mysqli_query($link,$consultaprecio) or die(mysql_error()); $monedanom1=$resultadoprecio->fetch_assoc(); $monedanom=$monedanom1['moneda']; $monedaprecio1=mysqli_fetch_assoc($resultadoprecio); $monedaprecio=$monedaprecio1['precio']; if(!isset($_SESSION['monprecio'])) { $_SESSION['monprecio']=$monedaprecio; } else { $_SESSION['monprecio']=$monedaprecio; } $sprecio=$_SESSION['monprecio']; /*-*/ include("../reemplazar.php"); //$reemplazar = array( "Á" => "A", "É" => "E", "Í" => "I", "Ó" => "O", "Ú"=>"U", "á" => "a", "é" => "e", "í" => "i", "ó" => "o", "ú" => "u","á" => "a", "é" => "e", "í" => "i" , "ó" => "o", "ú" => "u", "Ñ" => "N", "ñ" => "n", "ñ" => "n", "¡" => "-", "!" => "-", "@" => "-", "#" => "-", "$" => "-", "%" => "-", "^" => "-", "&" => "-", "*" => "-", "(" => "-", ")" => "-", "[" => "-", "]" => "-", "{" => "-", "}" => "-", "¿" => "-", "?" => "-", "<" => "-", ">" => "-"); /*-*/ $nomb_catgo=$_GET['IDCG']; //echo $nomb_catgo; $ID=$_GET['ID']; //echo $ID; $ID_U=$ID; $ID_U=strtr($ID,$reemplazar); $ID_U = URLencode(htmlentities($ID,ENT_QUOTES)); $IDCG_U=$nomb_catgo; $IDCG_U=strtr($nomb_catgo,$reemplazar); $IDCG_U = URLencode(htmlentities($IDCG_U,ENT_QUOTES)); //hacemos amigable la busqueda a la base de datos y eliminamos todos los '-' $catego_seo = strtolower($ID); //$catego_seo = preg_replace('#[^a-z0-9/]+#', ' ', $catego_seo); $catego_seo=strtr ( $catego_seo," ","-"); $consulta_cat="SELECT* FROM categorias WHERE CATEGORIA_SEO='$catego_seo' AND EMPRESA_ID='8' AND WEB='1'"; $resultado_cat= mysqli_query($link,$consulta_cat) or die(mysql_error()); $registro_cat= mysqli_fetch_assoc($resultado_cat); $ID_CAT=$registro_cat['ID_CATEGORIA']; //echo $ID_CAT; $cat=$registro_cat['NOM_CATEGORIA']; $IDCTLG=$registro_cat['ID_CTLG']; //echo $IDCTLG; $ID_TP=$registro_cat['ID_TIP']; $descat=$registro_cat['DESCRIPCION_CAT']; $meta_title=$registro_cat['META_TITLE']; $meta_descrip=$registro_cat['META_DESCRIP']; $meta_key=$registro_cat['META_KEY']; //si hay mas de una subcategoria en una categoria $ID_CATALOGOC=$registro_meta['ID_CAT']; //$IDCG=$_GET['IDCG']; //obtengo el id del catalogo de la opcion uqe haya se;lecionado //consulto el catalogo $ctlg_seo = strtolower($nomb_catgo); //$ctlg_seo = preg_replace('#[^a-z0-9/]+#', ' ', $ctlg_seo); $ctlg_seo=strtr ( $ctlg_seo," ","-"); $consultar="SELECT * FROM catalogo WHERE TITULO='$ctlg_seo' AND EMPRESA_ID='8' AND WEB='1'"; $result = mysqli_query($link,$consultar) or die(mysql_error()); $registros= mysqli_fetch_assoc($result); $nombr=$registros['NOMBRE_CATALOGO']; $titul=$registros['NOMBRE_CATALOGO']; ?>
include("../analytics-head.php"); ?>| |
||||||
|---|---|---|---|---|---|---|
|
Inicio
>
Catalogos
>
";
echo" ";
//codigo que muestra el menu del catalogo
if(empty($IDCG))
{ echo $registros['NOMBRE_CATALOGO'];
}
else
{echo 'Catalogo '.$nomb_catgo.'';}
?>
>
";
?>
*/
echo "
// maximo por pagina
$limit = 5;
// pagina pedida
$pag = (int) $_GET["pag"];
if ($pag < 1)
{
$pag = 1;
}
$offset = ($pag-1) * $limit;
// muestro datos de subcategoria y de producto
//consulto todas las subcategorias que pertenecen a tal categoria
/*
$sql= "SELECT SQL_CALC_FOUND_ROWS subcategorias.ID_CAT, subcategorias.ID_SUBCATEGORIA, subcategorias.IMAGEN_M, subcategorias.ALT_FOTO_SUBCAT, subcategorias.DESCRIPCION_SUBCAT,subcategorias.NOM_SUBCATEGORIA, productos.ID_PROD, productos.NOMBRE_PROD, productos.ID_SUBCAT,productos.ID_CAT FROM subcategorias inner join productos on subcategorias.ID_SUBCATEGORIA=productos.ID_SUBCAT WHERE subcategorias.ID_CAT='$ID_CAT' AND productos.EMPRESA_ID='8' AND productos.WEB='1' LIMIT $offset, $limit";
$sqlTotal = "SELECT FOUND_ROWS() as total";
$rs = mysql_query($sql,$link);
$rsTotal = mysql_query($sqlTotal,$link);
$rowTotal = mysql_fetch_assoc($rsTotal);
// Total de registros sin limit
$total = $rowTotal["total"];
*/
//$total=$registro_meta["total"];
//significa que la variable idsubcat esta vacia, por lo tanto el usuario selecciono una categoria.
//consultamos los meta de la UNICA subcategoria que pertenece a la categoria seleccionada por el usuario
$consulta_meta = "SELECT SQL_CALC_FOUND_ROWS * FROM subcategorias WHERE ID_CAT='$ID_CAT' AND EMPRESA_ID='8' AND WEB='1' LIMIT $offset, $limit";
//$consulta_meta = "SELECT * FROM subcategorias WHERE ID_CAT='$ID_CAT' AND EMPRESA_ID='8' AND WEB='1' LIMIT $offset, $limit";
$resultado_metas= mysqli_query($link,$consulta_meta);
$sqlTotal = "SELECT FOUND_ROWS() as total";
$rsTotal = mysqli_query($link,$sqlTotal);
$rowTotal = mysqli_fetch_assoc($rsTotal);
/*
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM subcategorias WHERE ID_CAT='$ID_CAT' AND EMPRESA_ID='8' AND WEB='1' LIMIT $offset, $limit";
$sqlTotal = "SELECT FOUND_ROWS() as total";
$rss = mysql_query($sql);
$rsTotal = mysql_query($sqlTotal);
$rowTotal = mysql_fetch_assoc($rsTotal);
*/
?>
![]() ".$registro_cat['NOM_CATEGORIA'].""; echo " ".$registro_cat['DESCRIPCION_CAT']." "; /*--->*/ ?>
//echo "
Indice de Productos del Catalogo
$i"; } echo implode(" << Página >> ", $links); ?>
$url_ajuste="../"; include("../include/menu-bottom.php"); ?>
|
||||||
|
||||||
| Copyright (c) 2011 | numerica.mx | All rights reserved |
|
||||||