if(!headers_sent() && ''==session_id()){ session_start(); } $reemplazar = array('Š'=>'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;//Conexion_bd();//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']; $SUBCTLG=$_GET['IDSUBCTLG'];//recibimos el nombre del subtacatalogo si lo hay if(empty($SUBCTLG)){ $ID_CT=$_GET['ID'];//asignamos el nombre del subcatalogo a la variable $id_ct $CTLG=$_GET['IDCG'];//obtenemos el catalogo $ID=$_GET['ID'];//obtenemos el subcatalogo }else{ $ID_CT=$_GET['IDSUBCTLG']; $ID=$_GET['IDSUBCTLG'];//$SUBCTLG $CTLG=$_GET['IDCG']; $CAT=$_GET['ID']; } include("../reemplazar.php"); $subctlg_url_seo = strtolower($ID); $subctlg_url_seo = preg_replace('#[^a-z0-9/]+#', ' ', $subctlg_url_seo); //CONSULTA A SUBCATALOGO PARA OBTENER IDCATALOGO $QRY_SUBCTLG="SELECT * FROM subcatalogos WHERE SUBCTLG_SEO='$subctlg_url_seo' AND EMPRESA_ID='8' AND WEB='1' "; $RESULT_SUBCTLG=mysqli_query($link,$QRY_SUBCTLG) or die(mysqli_error()); $REG_SUBCTLG=mysqli_fetch_assoc($RESULT_SUBCTLG); $ID_CTLG=$REG_SUBCTLG['ID_CTLG']; $ID_SUBCTLG=$REG_SUBCTLG['ID_SUBCTLG']; //echo $ID_CTLG; //CONSULTA A CATALOGO PARA OBTENER NOMBRE DEL CATALOGO EN BASE AL ID OBTENIDO DE SUBCATALOGO $QRY_CTLG="SELECT * FROM catalogo WHERE ID_CATALOG='$ID_CTLG' AND EMPRESA_ID='8' AND WEB='1'"; $RESULT_CTLG=mysqli_query($link,$QRY_CTLG) or die(mysqli_error()); $REG_CTLG=mysqli_fetch_assoc($RESULT_CTLG); $IDCG_U=$REG_CTLG['NOMBRE_CATALOGO']; $IDCG_U = strtr ( $IDCG_U , $reemplazar ); $IDCG_U = URLencode(htmlentities($IDCG_U,ENT_QUOTES)); $ID_U=$REG_SUBCTLG['NOMBRE_SUBCTLG']; $ID_U = strtr ( $ID_U , $reemplazar ); $ID_U = URLencode(htmlentities($ID_U,ENT_QUOTES)); $ID_CAT=$CAT; $ID_CAT = strtr ( $ID_CAT , $reemplazar ); $ID_CAT = URLencode(htmlentities($ID_CAT,ENT_QUOTES)); /******************encontramos categorias del subcatalogo***************/ $QRY_CATS="SELECT * FROM categorias WHERE ID_CTLG='$ID_CTLG' AND ID_SUBCTLG='$ID_SUBCTLG' AND EMPRESA_ID='8' AND WEB='1'"; $RESULT_QRY_CATS=mysqli_query($link,$QRY_CATS) or die(mysqli_error()); ?>
include("../analytics-head.php"); ?>| |
||
|---|---|---|
|
Inicio >
Catalogos >
";
?>
echo $REG_CTLG['NOMBRE_CATALOGO'];
?>
>
echo "";
?>
echo $REG_SUBCTLG['NOMBRE_SUBCTLG'];
?>
>
if(!empty($SUBCTLG)){
echo "";
?>
$CAT=strtr ( $CAT,"-"," ");
echo $CAT;
?>
}
?>
".$REG_SUBCTLG['NOMBRE_SUBCTLG'].""; echo " ".$REG_SUBCTLG['DESCRIPCION_SUBCTLG']." "; echo ""; //$sql= "SELECT SQL_CALC_FOUND_ROWS * FROM categorias WHERE ID_CTLG='$ID_CTLG' AND ID_SUBCTLG='$ID_SUBCTLG' LIMIT $offset, $limit"; $sql= "SELECT SQL_CALC_FOUND_ROWS * FROM categorias WHERE ID_CTLG='$ID_CTLG' AND ID_SUBCTLG='$ID_SUBCTLG' AND EMPRESA_ID='8' AND WEB='1' LIMIT $offset, $limit"; $sqlTotal = "SELECT FOUND_ROWS() as total"; $rs = mysqli_query($link,$sql); $rsTotal = mysqli_query($link,$sqlTotal); $rowTotal = mysqli_fetch_assoc($rsTotal); // Total de registros sin limit $total = $rowTotal["total"]; }else{ //$cat_url_seo = preg_replace('#[^a-z0-9/]+#', ' ', $cat_url_seo); $cat_url_seo = strtolower($CAT); $cat_url_seo=strtr ( $cat_url_seo," ","-"); $QRY_CAT="SELECT * FROM categorias WHERE CATEGORIA_SEO='$cat_url_seo' AND EMPRESA_ID='8' AND WEB='1'"; $RESULT_CAT=mysqli_query($link,$QRY_CAT) or die(mysqli_error()); $REG_CAT=mysqli_fetch_assoc($RESULT_CAT); $ID_CAT=$REG_CAT['ID_CATEGORIA']; $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"; $rs = mysqli_query($link,$sql); $rsTotal = mysqli_query($link,$sqlTotal); $rowTotal = mysqli_fetch_assoc($rsTotal); // Total de registros sin limit $total = $rowTotal["total"]; //mostramos titulo y descripcion de la categoria seleccionada echo " ![]() ".strtr($REG_CAT['NOM_CATEGORIA'],$reemplazar_title).""; echo " ".$REG_CAT['DESCRIPCION_CAT']." "; echo ""; } ?>
//contenido a mostrar ya sea las categorias del subcatalogo o las subcategorias de las categorias del subcatalogo
if(empty($SUBCTLG))
{
//mostramos las categorias del subcatalogo seleccionado
while($registro=mysqli_fetch_array($rs,MYSQLI_ASSOC))
//while($registro=mysqli_fetch_array($RESULT_QRY_CATS,MYSQLI_ASSOC))
{
$IDCG=$registro['ID_CTLG'];
$qry1="SELECT * FROM catalogo WHERE ID_CATALOG='$IDCG' AND EMPRESA_ID='8' AND WEB='1' ";
$resultQRY = mysqli_query($link,$qry1) or die(mysqli_error());
while($registroQRY=mysqli_fetch_array($resultQRY,MYSQLI_ASSOC))
{
$nomb_catgo=$registroQRY['NOMBRE_CATALOGO'];
}
$nomb_catgo = strtr ($nomb_catgo , $reemplazar );
$nomb_catgo = URLencode(htmlentities($nomb_catgo,ENT_QUOTES));
$ID_SUBCTLG=$REG_SUBCTLG['NOMBRE_SUBCTLG'];
$ID_SUBCTLG = strtr ($ID_SUBCTLG , $reemplazar );
$ID_SUBCTLG = URLencode(htmlentities($ID_SUBCTLG,ENT_QUOTES));
$reemplazar = array('Š'=>'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');
//include("../reemplazar.php");
$categos=$registro['NOM_CATEGORIA'];
//$ID_U = preg_replace('[^a-z0-9/]', '', $categos);
$ID_U = strtr ( $categos , $reemplazar );
$CATEGO_TITLE = strtr ( $categos , $reemplazar_title );
//$ID_U = URLencode(htmlentities($ID_U,ENT_QUOTES));
echo " ";
}
}//cerramos if
?>
";
echo " ";
/*
echo "";
*/
echo "".$registro['DESCRIP_CAT']." "; echo ""; }//fin de while }else{ //mostramos las subcategorias de la categoria seleccionada while($registro=mysqli_fetch_array($rs,MYSQLI_ASSOC)) { $qry1="SELECT * FROM categorias WHERE ID_CATEGORIA='$ID_CAT' AND EMPRESA_ID='8' AND WEB='1' "; $resultQRY = mysqli_query($link,$qry1) or die(mysqli_error()); while($registroQRY=mysqli_fetch_array($resultQRY,MYSQLI_ASSOC)) { $nomb_cat=$registroQRY['NOM_CATEGORIA']; } //NOMBRE CATALOGO $ID_CTLG=$CTLG; $ID_CTLG = strtr ($ID_CTLG , $reemplazar ); $ID_CTLG = URLencode(htmlentities($ID_CTLG,ENT_QUOTES)); //NOMBRE SUBCATALOGO $ID_SUBCTLG=$SUBCTLG; $ID_SUBCTLG = strtr ($ID_SUBCTLG , $reemplazar ); //$ID_SUBCTLG = URLencode(htmlentities($ID_SUBCTLG,ENT_QUOTES)); //NOMBRE CATEGORIA $nomb_cat = strtr ($CAT , $reemplazar ); $nomb_cat = URLencode(htmlentities($nomb_cat,ENT_QUOTES)); //NOMBRE SUBCATEGORIA $ID=$registro['NOM_SUBCATEGORIA']; $ID_SUBCATEGO=strtr($registro['NOM_SUBCATEGORIA'],$reemplazar_title); $ID = strtr ( $ID , $reemplazar ); //$ID = URLencode(htmlentities($ID,ENT_QUOTES)); echo " ";
echo " ";
echo "".$registro['DESCRIPCION_SUBCAT']." ".$registro['NOM_SUBCATEGORIA']." ".$registro['DESCRIPCION_SUBCAT']." "; //} 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 |
|
||