'S','š'=>'s','Ð'=>'Dj','ð'=>'dj','Ž'=>'Z','ž'=>'z','?'=>'C','?'=>'c','?'=>'C','?'=>'c','À'=>'A','Á'=>'A','Â'=>'A','Ã'=>'i','Ä'=>'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','Ç'=>'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'); $link=$conecta; include('../conectar/conexion-num.php'); $linkk=$conectaa; /**/ require_once('../conectar/consultas.php'); include("../reemplazar.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(); ?>
| |
||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
![]() Noticias del Centro de Conocimiento
$page=(isset($_REQUEST['page']))?$_REQUEST['page']:1;
$maxrows=4;//numero de registros por pagina
$start=(($page-1)*$maxrows);
/**/
$consulta="SELECT SQL_CALC_FOUND_ROWS * FROM noticias WHERE EMPRESA_ID='8' AND WEB='1' LIMIT $start,$maxrows ";
$results = mysqli_query($link,$consulta) or die(mysqli_error());
//SQL_CALC_FOUND_ROWS es para que mysql cuente todos los resultados encontrados
$rtotal=mysqli_query($link,"SELECT FOUND_ROWS()");
if($rtotal=(mysqli_fetch_array($rtotal,MYSQLI_BOTH))) {
$found_rows=$rtotal[0];//numero total de rows encontrados
$num_rows=mysqli_num_rows($results);//numero de rows encontrados solo en esta pagina
}
/************************blog news***************************/
$consultaa="SELECT SQL_CALC_FOUND_ROWS * FROM bb7_posts WHERE post_type='post' and post_status='publish' ORDER BY post_date DESC LIMIT $start,$maxrows ";
$resultss = mysqli_query($linkk,$consultaa) or die(mysqli_error());
$rtotall=mysqli_query($linkk,"SELECT FOUND_ROWS()");
if($rtotall=(mysqli_fetch_array($rtotall,MYSQLI_BOTH))) {
$found_rowss=$rtotall[0];//numero total de rows encontrados
$num_rowss=mysqli_num_rows($resultss);//numero de rows encontrados solo en esta pagina
}
/*************************************************************/
$found_rows=$found_rows+$found_rowss;
/* GENERANDO las variables para paginar */
$pagvars=array();
if(isset($found_rows)&&$found_rows>0) {
$pagvars['total']=$found_rows;
$pagvars['page']=$page;
$pagvars['xpage']=$maxrows;
$pagvars['limit']=6;//numero maximo de links a paginas a mostrar en la pagination
$pagvars['startindex']=$start;
$pagvars['model']='noticias.php?page=<-p-a-g-e->';
}
/* MOSTRANDO LOS RESULTADOS */
/**/
echo "
"; /* MOSTRANDO LA PAGINATION */ echo ""; ?> 0){$totalpages++;} $medio=intval($limit/2); if(($limit%2)>0){$medio++;} if($totalpages<=$limit){ $start=1;$end=$totalpages; } else if($totalpages-$page<=$medio){ $end=$totalpages;$start=$totalpages-$limit+1; }else if($page<=$medio){ $start=1;$end=$start+$limit-1; }else{ $start=$page-$medio+1;$end=$start+$limit-1; } $items=array(); for($i=$start;$i<=$end;$i++){ $item[]=array(); $item['href']=str_ireplace('<-p-a-g-e->',$i, $model); $item['page']=$i; $items[]=$item; } $pagination['pages']=$items; if($page>1){ $item[]=array(); $item['href']=str_ireplace('<-p-a-g-e->',$page-1, $model); $item['page']=$page-1; $pagination['back']=$item; } if($totalpages-$page>0){ $item[]=array(); $item['href']=str_ireplace('<-p-a-g-e->',$page+1, $model); $item['page']=$page+1; $pagination['next']=$item; } return $pagination; } ?>
$url_ajuste="../"; include("../include/menu-bottom.php"); ?>
|
||||||||||||||
|
||||||||||||||
| Copyright (c) 2011 | numerica.mx | All rights reserved |
|
||||||||||||||