LordNik

Mysqli pagination results

Apr 17th, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.77 KB | None | 0 0
  1. // TOTAL DE LINHAS DA CONSULTA
  2. $tabela="noticias";
  3. $sql="SELECT * FROM $tabela ORDER BY id DESC";
  4. $query=$conecta->query($sql);
  5. $total=$query->num_rows;
  6. $query->free();
  7.  
  8. $paginas = filter_input(INPUT_GET, 'pagina', FILTER_SANITIZE_SPECIAL_CHARS);
  9. $valors = filter_input(INPUT_GET, 'valor', FILTER_SANITIZE_SPECIAL_CHARS);
  10.  
  11. $paginas = strip_tags($_GET['pagina']);
  12. $valors = strip_tags($_GET['valor']);
  13.  
  14. $paginas = $conecta->real_escape_string($_GET['pagina']);
  15. $valors = $conecta->real_escape_string($_GET['valor']);
  16.  
  17. // NÃO ALTERAR ABAIXO
  18. if(@$paginas=="") {
  19. $pagina="1";
  20. } else {
  21. $pagina=$paginas;
  22. }
  23. $maximo=4;
  24. if(@$paginas=="" || @$paginas=="1") {
  25. $valor = 0;
  26. } else {
  27. $valor = $valors;
  28. }
  29. $inicio=$pagina-1;
  30. $inicio=$maximo*$inicio;
  31. // NÃO ALTERAR ACIMA
  32.  
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment