'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()); ?> Catalogo <? echo $ID_CT; ?>
logo numerica
Contáctanos carrito

Ver Carrito
carrito
Moneda "; //funcion para que se envíe cuando se seleccione. echo ""; while ($regmoneda = $resultadomoneda->fetch_row()) { echo""; } ?>
 

Inicio > Catalogos > "; ?> > "; ?> > "; ?>

".$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 "img_titulo

".strtr($REG_CAT['NOM_CATEGORIA'],$reemplazar_title)."


"; echo "

".$REG_CAT['DESCRIPCION_CAT']."

"; echo "
"; } ?>
'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 "
"; echo "
"; echo "

".$registro['NOM_CATEGORIA']."

"; echo "

".$registro[

"; echo "
"; echo "

".$registro['DESCRIP_CAT']."

".$CATEGO_TITLE."

"; echo "
"; /* echo "
"; echo "
"; ?>

".$registro['NOM_CATEGORIA']."

"; ?>

".$registro[

"; ?>

"; ?>

".$registro['DESCRIP_CAT']."

".$registro['NOM_CATEGORIA']."

"; echo "

cotizar"; ?>

"; */ 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 "

".$ID."

"; /* if(empty($ID_SUBCTLG)){ echo "

".$registro[

"; echo "
"; echo "

".$registro['DESCRIPCION_SUBCAT']."

".$registro['NOM_SUBCATEGORIA']."

"; }else{ */ echo "

".$registro[

"; echo "
"; echo "

".$registro['DESCRIPCION_SUBCAT']."

".$ID_SUBCATEGO."

"; //} echo "
"; } }//cerramos if ?>
Indice de Productos del Catalogo
$i"; } echo implode(" << Página >> ", $links); ?>

 


 

 



 
| Copyright (c) 2011 | numerica.mx | All rights reserved |