Untitled

<!Doctype html>
<html>
<head>
<title>Tabela Deca </title>
<?php
header('Content-Type: text/html; charset=UTF-8');


$dsn = "mysql:host=testelogin_db.mysql.dbaas.com.br;dbname=testelogin_db";
$user= "testelogin_db";
$pass= "teste123";


try {
    $pdo = new PDO($dsn, $user, $pass);

} catch (Exception $error) {
     "conexao com banco invalido " . $error->getMessage() . "</br>";

}
$i = 1;
$query = $pdo->query("SELECT * FROM `Deca` LIMIT 20", PDO::FETCH_ASSOC);
$query_pg = $pdo->query("SELECT * FROM `Deca`", PDO::FETCH_ASSOC);
$count = $query_pg->rowcount();
$calculate = ceil(($count/100)*10);
echo $calculate;

if(isset($_GET['page']) == $i){
	$url = $_GET['page'];
	$mody = $url*10-10;
	echo $mody;
	$query = $pdo->query("SELECT * FROM `Deca` LIMIT 20 OFFSET $mody", PDO::FETCH_ASSOC);

}
?>

<link rel="stylesheet" type="text/css" href="style/style.css">
</head>
<body>
<div class="table">
<table cellspacing="0">
<thead>
<tr>
<td class="table-title">product_catalog</td>
<td class="table-title">product_template</td>
<td class="table-title">product_page_type</td>
<td class="table-title">product_catalog_id</td>
<td class="table-title">product_page</td>
<td class="table-title">product_block</td>
<td class="table-title">product_type</td>
<td class="table-title">product_region</td>
<td class="table-title">product_season</td>
<td class="table-title">product_group</td>
<td class="table-title">product_subgroup</td>
<td class="table-title">product_line</td>
<td class="table-title">product_list_cat</td>
<td class="table-title">product_list_line</td>
<td class="table-title">product_list_item</td>
<td class="table-title">product_code_color</td>
<td class="table-title">product_code</td>
<td class="table-title">product_code_null</td>
<td class="table-title">product_entr_water</td>
<td class="table-title">product_exit_water</td>
<td class="table-title">product_norma_1</td>
<td class="table-title">product_norma_2</td>
<td class="table-title">product_norma_3</td>
<td class="table-title">product_organization</td>
<td class="table-title">product_mca_1</td>
<td class="table-title">product_mca_2</td>
<td class="table-title">product_mca_3</td>
<td class="table-title">product_icon_attr</td>
<td class="table-title">product_text_attr</td>
<td class="table-title">product_comp</td>
<td class="table-title">product_featured_tech</td>
<td class="table-title">product_pin_item</td>
<td class="table-title">product_text_site</td>
<td class="table-title">product_text_prize</td>
<td class="table-title">product_descr</td>
<td class="table-title">product_line_site</td>
<td class="table-title">product_prod_incomp</td>
<td class="table-title">product_line_incomp</td>
<td class="table-title">product_no_pin_item</td>
<td class="table-title">product_rec</td>
<td class="table-title">product_icon_launch</td>
<td class="table-title">product_proagua</td>
<td class="table-title">product_press</td>
<td class="table-title">product_icon_prize</td>
<td class="table-title">product_color</td>
<td class="table-title">product_exclusive</td>
<td class="table-title">product_icon_acc</td>
<td class="table-title">product_full_code</td>
<td class="table-title">product_splash</td>
<td class="table-title">FIT</td>
<td class="table-title">update_date</td>

</tr>
</thead>


<tbody>

<?php
$data = $query->fetchAll();
foreach($data as $show){
?>
 <tr class="table-background">

<td class="table-body"><?php echo $show ['COL2']; ?></td>
<td class="table-body"><?php echo $show ['COL2'] ?></td>
<td class="table-body"><?php echo $show ['COL3']; ?></td>
<td class="table-body"><?php echo $show ['COL4']; ?></td>
<td class="table-body"><?php echo $show ['COL5']; ?></td>
<td class="table-body"><?php echo $show ['COL6']; ?></td>
<td class="table-body"><?php echo $show ['COL7']; ?></td>
<td class="table-body"><?php echo $show ['COL8']; ?></td>
<td class="table-body"><?php echo $show ['COL9']; ?></tth>
<td class="table-body"><?php echo $show ['COL10']; ?></td>
<td class="table-body"><?php echo $show ['COL11']; ?></tth>
<td class="table-body"><?php echo $show ['COL12']; ?></td>
<td class="table-body"><?php echo $show ['COL13']; ?></td>
<td class="table-body"><?php echo $show ['COL14']; ?></td>
<td class="table-body"><?php echo $show ['COL15']; ?></td>
<td class="table-body"><?php echo $show ['COL16']; ?></td>
<td class="table-body"><?php echo $show ['COL17']; ?></td>
<td class="table-body"><?php echo $show ['COL18']; ?></td>
<td class="table-body"><?php echo $show ['COL19']; ?></td>
<td class="table-body"><?php echo $show ['COL20']; ?></td>
<td class="table-body"><?php echo $show ['COL21']; ?></td>
<td class="table-body"><?php echo $show ['COL22']; ?></td>
<td class="table-body"><?php echo $show ['COL23']; ?></td>
<td class="table-body"><?php echo $show ['COL24']; ?></td>
<td class="table-body"><?php echo $show ['COL25']; ?></td>
<td class="table-body"><?php echo $show ['COL26']; ?></td>
<td class="table-body"><?php echo $show ['COL27']; ?></td>
<td class="table-body"><?php echo $show ['COL28']; ?></td>
<td class="table-body"><?php echo $show ['COL29']; ?></td>
<td class="table-body"><?php echo $show ['COL30']; ?></td>
<td class="table-body"><?php echo $show ['COL31']; ?></td>
<td class="table-body"><?php echo $show ['COL32']; ?></td>
<td class="table-body"><?php echo $show ['COL33']; ?></td>
<td class="table-body"><?php echo $show ['COL34']; ?></td>
<td class="table-body"><?php echo $show ['COL35']; ?></td>
<td class="table-body"><?php echo $show ['COL36']; ?></td>
<td class="table-body"><?php echo $show ['COL37']; ?></td>
<td class="table-body"><?php echo $show ['COL38']; ?></td>
<td class="table-body"><?php echo $show ['COL39']; ?></td>
<td class="table-body"><?php echo $show ['COL40']; ?></td>
<td class="table-body"><?php echo $show ['COL41']; ?></td>
<td class="table-body"><?php echo $show ['COL42']; ?></td>
<td class="table-body"><?php echo $show ['COL43']; ?></td>
<td class="table-body"><?php echo $show ['COL44']; ?></td>
<td class="table-body"><?php echo $show ['COL45']; ?></td>
<td class="table-body"><?php echo $show ['COL46']; ?></td>
<td class="table-body"><?php echo $show ['COL47']; ?></td>
<td class="table-body"><?php echo $show ['COL48']; ?></td>
<td class="table-body"><?php echo $show ['COL49']; ?></td>
<td class="table-body"><?php echo $show ['COL50']; ?></td>
<td class="table-body"><?php echo $show ['COL51']; ?></td>
<td class="table-body"><?php echo $show ['COL52']; ?></td>
</tr>

<?php
}
?>


</tbody>
</table>

<?php

    $page_back = $_GET['page'] - 1;
    $page_go = $_GET['page'] - 1;
    $btn_value = $_GET['page'];

    if($GET['page'] != 1){
      echo "<a href='?page = $page_back' class = 'btn_pg'></a>";

    }
    while($i <= $calculate){
      echo "<a href='?page = $i' class ='btn_pg'>$i</a>";
      $i++;
      if($i > 15){
        echo "<a class = 'btn_pg'>...</a>";
        if ($_GET['page'] > 16){
        echo "<a href='?page = $btn_value' class ='btn_pg'>$btn_value</a>";
      }else{
        echo "<a href='?page = 16' class ='btn_pg'>16</a>";
      }

        if($_GET['page'] < $calculate){
        echo "<a href='?page = $page_go' class = 'btn_pg'>>></a>";

        }
        break;

      }
}
 ?>

 </div>
 </body>
 </html>