Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.83 KB | None | 0 0
  1. <?php
  2. require("conexao.php");
  3. require("init.php");
  4.  
  5. $itens_por_pagina1 = 5;
  6.  
  7. $pagina1 = intval($_GET['pagina1']);
  8.  
  9. $query1 = "SELECT * FROM raddb.Grupo ORDER BY Discricao ASC LIMIT $pagina1, $itens_por_pagina1";
  10.  
  11. $result1 = $conn->query($query1) or die($conn->error);
  12.  
  13. $produto1 = $result1->fetch_assoc();
  14.  
  15. $num1 = $result1->num_rows;
  16.  
  17. $num_total1 = $conn->query("SELECT * FROM raddb.Grupo ORDER BY Discricao ASC")->num_rows;
  18.  
  19. $num_paginas1 = ceil($num_total1/$itens_por_pagina1);
  20.  
  21. <div class="table-responsive" id="employee_table1">
  22. <?php if($num1 > 0){ ?>
  23. <table class="table table-hover table-striped lista-clientes1">
  24. <legend><b>Grupos</b></legend>
  25. <tr>
  26. <span class="glyphicon glyphicon-filter" data-toggle="modal" data-original-title="Filter"></span><input type="text" class="input-search1" alt="lista-clientes1"/>
  27. <th width="25%">Grupo</th>
  28. <th width="30%">Ações</th>
  29. </tr>
  30. <?php do{ ?>
  31. <tr>
  32. <td><?php echo $produto1["Discricao"]; ?></td>
  33. <td><button type="button" name="view1" id="<?php echo $produto1["Id"]; ?>" data-toggle="modal" href="#dataModal1" class="btn btn-warning btn-sm view_data1" /><span class="glyphicon glyphicon-edit"></span></button></td>
  34. </tr>
  35. <?php } while($produto1 = $result1->fetch_assoc()); ?>
  36. </table>
  37. <nav>
  38. <ul class="pagination">
  39. <li>
  40. <a href="index.php/novoutilizador?pagina1=0" aria-label="Previous">
  41. <span aria-hidden="true">&laquo;</span>
  42. </a>
  43. </li>
  44. <?php
  45. for($i=0;$i<$num_paginas1;$i++){
  46. $estilo = "";
  47. if($pagina1 == $i)
  48. $estilo = "class="active"";
  49. ?>
  50. <li <?php echo $estilo; ?> ><a href="index.php/novoutilizador?pagina1=<?php echo $i; ?>"><?php echo $i+1; ?></a></li>
  51. <?php } ?>
  52. <li>
  53. <a href="index.php/novoutilizador?pagina1=<?php echo $num_paginas1-1; ?>" aria-label="Next">
  54. <span aria-hidden="true">&raquo;</span>
  55. </a>
  56. </li>
  57. </ul>
  58. </nav>
  59. <?php } ?>
  60. </div>
  61. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement