API tools faq
paste
Advertisement
Guest User

index2

a guest
Apr 2nd, 2018
80
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.94 KB | None | 0 0
raw download clone embed print report
  1.  
  2. <?php
  3. header('Content-Type: text/html; charset=UTF-8');
  4.  
  5.  
  6. $dsn = "mysql:host=testelogin_db.mysql.dbaas.com.br;dbname=testelogin_db";
  7. $user= "testelogin_db";
  8. $pass= "teste123";
  9.  
  10.  
  11.  
  12.  
  13. try {
  14. $pdo = new PDO($dsn, $user, $pass);
  15.  
  16. } catch (Exception $error) {
  17. "conexao com banco invalido " . $error->getMessage() . "</br>";
  18.  
  19. }
  20.  
  21. //determina o numero de registros que serão mostrados na tela
  22. $maximo = 20;
  23. //armazenamos o valor da pagina atual
  24. $pagina = isset($_GET['page']) ? ($_GET['page']) : '1';
  25. //subtraimos 1, porque os registros sempre começam do 0 (zero), como num array
  26. $inicio = $page- 1;
  27. //multiplicamos a quantidade de registros da pagina pelo valor da pagina atual
  28. $inicio = $maximo * $inicio;
  29.  
  30. ?>
  31.  
  32.  
  33.  
  34. <?php
  35. $query = $pdo->select("SELECT COUNT(*) AS 'COL52' FROM `Deca`");
  36. $total = 52;
  37. if(count($query)){
  38. foreach ($query as $row) {
  39. //armazeno o total de registros da tabela para fazer a paginação
  40. $total = $row["'COL52'"];
  41. }
  42. }
  43.  
  44. $query = $pdo->select("SELECT * FROM `Deca` ORDER BY 'COL52' LIMIT $inicio,$maximo");
  45.  
  46. ?>
  47. <!Doctype html>
  48. <html>
  49. <head>
  50. <title>Tabela Deca </title>
  51.  
  52. <link rel="stylesheet" type="text/css" href="style/style.css">
  53. </head>
  54. <body>
  55. <div class="table">
  56. <table cellspacing="0">
  57. <thead>
  58. <tr>
  59. <td class="table-title">product_catalog</td>
  60. <td class="table-title">product_template</td>
  61. <td class="table-title">product_page_type</td>
  62. <td class="table-title">product_catalog_id</td>
  63. <td class="table-title">product_page</td>
  64. <td class="table-title">product_block</td>
  65. <td class="table-title">product_type</td>
  66. <td class="table-title">product_region</td>
  67. <td class="table-title">product_season</td>
  68. <td class="table-title">product_group</td>
  69. <td class="table-title">product_subgroup</td>
  70. <td class="table-title">product_line</td>
  71. <td class="table-title">product_list_cat</td>
  72. <td class="table-title">product_list_line</td>
  73. <td class="table-title">product_list_item</td>
  74. <td class="table-title">product_code_color</td>
  75. <td class="table-title">product_code</td>
  76. <td class="table-title">product_code_null</td>
  77. <td class="table-title">product_entr_water</td>
  78. <td class="table-title">product_exit_water</td>
  79. <td class="table-title">product_norma_1</td>
  80. <td class="table-title">product_norma_2</td>
  81. <td class="table-title">product_norma_3</td>
  82. <td class="table-title">product_organization</td>
  83. <td class="table-title">product_mca_1</td>
  84. <td class="table-title">product_mca_2</td>
  85. <td class="table-title">product_mca_3</td>
  86. <td class="table-title">product_icon_attr</td>
  87. <td class="table-title">product_text_attr</td>
  88. <td class="table-title">product_comp</td>
  89. <td class="table-title">product_featured_tech</td>
  90. <td class="table-title">product_pin_item</td>
  91. <td class="table-title">product_text_site</td>
  92. <td class="table-title">product_text_prize</td>
  93. <td class="table-title">product_descr</td>
  94. <td class="table-title">product_line_site</td>
  95. <td class="table-title">product_prod_incomp</td>
  96. <td class="table-title">product_line_incomp</td>
  97. <td class="table-title">product_no_pin_item</td>
  98. <td class="table-title">product_rec</td>
  99. <td class="table-title">product_icon_launch</td>
  100. <td class="table-title">product_proagua</td>
  101. <td class="table-title">product_press</td>
  102. <td class="table-title">product_icon_prize</td>
  103. <td class="table-title">product_color</td>
  104. <td class="table-title">product_exclusive</td>
  105. <td class="table-title">product_icon_acc</td>
  106. <td class="table-title">product_full_code</td>
  107. <td class="table-title">product_splash</td>
  108. <td class="table-title">FIT</td>
  109. <td class="table-title">update_date</td>
  110.  
  111. </tr>
  112. </thead>
  113.  
  114.  
  115.  
  116.  
  117. <tbody>
  118.  
  119. <?php
  120. $data = $query->fetchAll();
  121. foreach($data as $show){
  122. ?>
  123. <tr class="table-background">
  124.  
  125. <td class="table-body"><?php echo $show ['COL2']; ?></td>
  126. <td class="table-body"><?php echo $show ['COL2'] ?></td>
  127. <td class="table-body"><?php echo $show ['COL3']; ?></td>
  128. <td class="table-body"><?php echo $show ['COL4']; ?></td>
  129. <td class="table-body"><?php echo $show ['COL5']; ?></td>
  130. <td class="table-body"><?php echo $show ['COL6']; ?></td>
  131. <td class="table-body"><?php echo $show ['COL7']; ?></td>
  132. <td class="table-body"><?php echo $show ['COL8']; ?></td>
  133. <td class="table-body"><?php echo $show ['COL9']; ?></tth>
  134. <td class="table-body"><?php echo $show ['COL10']; ?></td>
  135. <td class="table-body"><?php echo $show ['COL11']; ?></tth>
  136. <td class="table-body"><?php echo $show ['COL12']; ?></td>
  137. <td class="table-body"><?php echo $show ['COL13']; ?></td>
  138. <td class="table-body"><?php echo $show ['COL14']; ?></td>
  139. <td class="table-body"><?php echo $show ['COL15']; ?></td>
  140. <td class="table-body"><?php echo $show ['COL16']; ?></td>
  141. <td class="table-body"><?php echo $show ['COL17']; ?></td>
  142. <td class="table-body"><?php echo $show ['COL18']; ?></td>
  143. <td class="table-body"><?php echo $show ['COL19']; ?></td>
  144. <td class="table-body"><?php echo $show ['COL20']; ?></td>
  145. <td class="table-body"><?php echo $show ['COL21']; ?></td>
  146. <td class="table-body"><?php echo $show ['COL22']; ?></td>
  147. <td class="table-body"><?php echo $show ['COL23']; ?></td>
  148. <td class="table-body"><?php echo $show ['COL24']; ?></td>
  149. <td class="table-body"><?php echo $show ['COL25']; ?></td>
  150. <td class="table-body"><?php echo $show ['COL26']; ?></td>
  151. <td class="table-body"><?php echo $show ['COL27']; ?></td>
  152. <td class="table-body"><?php echo $show ['COL28']; ?></td>
  153. <td class="table-body"><?php echo $show ['COL29']; ?></td>
  154. <td class="table-body"><?php echo $show ['COL30']; ?></td>
  155. <td class="table-body"><?php echo $show ['COL31']; ?></td>
  156. <td class="table-body"><?php echo $show ['COL32']; ?></td>
  157. <td class="table-body"><?php echo $show ['COL33']; ?></td>
  158. <td class="table-body"><?php echo $show ['COL34']; ?></td>
  159. <td class="table-body"><?php echo $show ['COL35']; ?></td>
  160. <td class="table-body"><?php echo $show ['COL36']; ?></td>
  161. <td class="table-body"><?php echo $show ['COL37']; ?></td>
  162. <td class="table-body"><?php echo $show ['COL38']; ?></td>
  163. <td class="table-body"><?php echo $show ['COL39']; ?></td>
  164. <td class="table-body"><?php echo $show ['COL40']; ?></td>
  165. <td class="table-body"><?php echo $show ['COL41']; ?></td>
  166. <td class="table-body"><?php echo $show ['COL42']; ?></td>
  167. <td class="table-body"><?php echo $show ['COL43']; ?></td>
  168. <td class="table-body"><?php echo $show ['COL44']; ?></td>
  169. <td class="table-body"><?php echo $show ['COL45']; ?></td>
  170. <td class="table-body"><?php echo $show ['COL46']; ?></td>
  171. <td class="table-body"><?php echo $show ['COL47']; ?></td>
  172. <td class="table-body"><?php echo $show ['COL48']; ?></td>
  173. <td class="table-body"><?php echo $show ['COL49']; ?></td>
  174. <td class="table-body"><?php echo $show ['COL50']; ?></td>
  175. <td class="table-body"><?php echo $show ['COL51']; ?></td>
  176. <td class="table-body"><?php echo $show ['COL52']; ?></td>
  177. </tr>
  178.  
  179. <?php
  180. }
  181. ?>
  182.  
  183.  
  184. </tbody>
  185. </table>
  186.  
  187. <?php
  188. //determina de quantos em quantos links serão adicionados e removidos
  189. $max_links = 25;
  190. //dados para os botões
  191. $previous = $pagina - 1;
  192. $next = $pagina + 1;
  193. //usa uma funcção "ceil" para arrendondar o numero pra cima, ex 1,01 será 2
  194. $pgs = ceil($total / $maximo);
  195. //se a tabela não for vazia, adiciona os botões
  196. if($pgs > 1 ){
  197. echo "<br/>";
  198. //botao anterior
  199. if($previous > 0){
  200. echo "<div id='botaoanterior'><a href=".$_SERVER['PHP_SELF']."?pagina=$previous><input type='submit' name='bt-enviar' id='bt-enviar' value='Anterior' class='button' /></a></div>";
  201. } else{
  202. echo "<div id='botaoanteriorDis'><a href=".$_SERVER['PHP_SELF']."?pagina=$previous><input type='submit' name='bt-enviar' id='bt-enviar' value='Anterior' class='button' disabled='disabled'/></a></div>";
  203. }
  204.  
  205. echo "<div id='numpaginacao'>";
  206. for($i=$pagina-$max_links; $i <= $pgs-1; $i++) {
  207. if ($i <= 0){
  208. //enquanto for negativo, não faz nada
  209. }else{
  210. //senão adiciona os links para outra pagina
  211. if($i != $pagina){
  212. if($i == $pgs){ //se for o final da pagina, coloca tres pontinhos
  213. echo "<a href=".$_SERVER['PHP_SELF']."?pagina=".($i).">$i</a> ...";
  214. }else{
  215. echo "<a href=".$_SERVER['PHP_SELF']."?pagina=".($i).">$i</a>";
  216. }
  217. } else{
  218. if($i == $pgs){ //se for o final da pagina, coloca tres pontinhos
  219. echo "<span class='current'> ".$i."</span> ...";
  220. }else{
  221. echo "<span class='current'> ".$i."</span>";
  222. }
  223. }
  224. }
  225. }
  226.  
  227. echo "</div>";
  228.  
  229. //botao proximo
  230. if($next <= $pgs){
  231. echo " <div id='botaoprox'><a href=".$_SERVER['PHP_SELF']."?pagina=$next><input type='submit' name='bt-enviar' id='bt-enviar' value='Proxima' class='button'/></a></div>";
  232. }else{
  233. echo " <div id='botaoproxDis'><a href=".$_SERVER['PHP_SELF']."?pagina=$next><input type='submit' name='bt-enviar' id='bt-enviar' value='Proxima' class='button' disabled='disabled'/></a></div>";
  234. }
  235.  
  236. }
  237.  
  238. ?>
  239.  
  240. </div>
  241. </body>
  242. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!