>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> $_SESSION['variables_url']=$_SERVER['QUERY_STRING']; $titulo="titulo_".$idioma; $contenido="contenido_".$idioma; $texto_alterno="alterno_".$idioma; //EMPIEZA EL CODIGO DE PAGINACION--------------------------------------------------------- $ruta=$_SERVER['SCRIPT_FILENAME']; $arrelo_ruta_archivo=explode("public_html",$ruta); $url_ruta=$arrelo_ruta_archivo[1]; $arreglo_nombre_script=$arrelo_ruta_archivo=explode("/",$ruta); $elemento=count($arreglo_nombre_script)-1; $nombre_archivo=$arreglo_nombre_script[$elemento]; $variables_url="&idioma=$idioma"; $tbl_name="forsua_blog.faqs"; //your table name $ordenar=" ORDER BY id DESC"; // How many adjacent pages should be shown on each side? $adjacents = 3; $parte_where = " WHERE tipo='blog' AND publicar='si' AND en_todos_listados<>'si'"; /* First get total number of rows in data table. If you have a WHERE clause in your query, make sure you mirror it here. */ $query = "SELECT COUNT(*) as num FROM $tbl_name".$parte_where.$ordenar; //echo "QUERY 64: ".$query.""; $resul_tot_pages=mysqli_query($dbh,$query); $total_pages = mysqli_fetch_array($resul_tot_pages); $total_pages = $total_pages[num]; /* Setup vars for query. */ $targetpage = $nombre_archivo; //your file name (the name of this file) $limit = 16; //how many items to show per page $page = $_GET['page']; if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; //if no page var is given, set start to 0 /* Get data. */ $sql="SELECT id, fecha_publicar, texto_adjunto, archivo_adjunto, etiquetas, $titulo,$contenido, fotogrande, $texto_alterno FROM $tbl_name ".$parte_where.$ordenar." LIMIT $start, $limit"; //echo "

".$sql."

"; $_SESSION['sql_para_calculo']="SELECT * FROM forsua_blog.$tbl_name ".$parte_where; $result = mysqli_query($dbh,$sql); echo mysqli_error($dbh); $hay_notas=mysqli_num_rows($result); //echo $_SESSION['sql_para_calculo']."

"; /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 /* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once. */ $pagination = ""; if($lastpage > 1) { //$pagination .= "

"; //previous button if ($page > 1) $pagination.= "<< $anterior"; else $pagination.= "< $anterior"; //pages if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= "..."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= "..."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } //close to end; only hide early pages else { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } } } //next button if ($page < $counter - 1) $pagination.= "$siguiente >>"; else $pagination.= "$siguiente >"; //$pagination.= "
\n"; } //echo $sql."

"; //echo $query."

"; //TERMINA EL CODIGO DE PAGINACION----------------------------------------------------------- ?> FORSUA - Formación Superior en Alimentos

Noticias de la Industria Alimentaria y de la Hospitalidad