<?php
include "header.php";
?>
<?php
if(isset($_POST['submit'])){
    $VeriSiralaD = $_POST['VeriSirala']; 
}
?>

<div class="card m-b-30">
                                    <div class="card-body">
                                        <style>
                                            div.sirala {
                                              position: absolute;
                                              right: 1px;
                                              width: 200px;
                                              height: 10px;
                                          }
                                      } 
                                  </style>                               

                                
                                <h4 class="mt-0 header-title">Kazananlar</h4>
                                <p class="text-muted m-b-30 font-14">Kazananları buradan görüntüleyebilirsiniz.</p>
                                <form action="" method="post">
                                    <table id="datatable" class="table table-bordered">
                                        
                                        <thead>
                                            <tr>
                                                <th>Tarih</th>
                                                <th>Kullanıcı</th>
                                                <th>Ödül</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php

                                            $rowsPerPage = 10;

                                            $pageNum = 1;

                                            if(isset($_GET['sayfa']))
                                            {
                                                $pageNum = $_GET['sayfa'];
                                            }
                                            $offset = ($pageNum - 1) * $rowsPerPage;
                                            $query = "SELECT count(*) FROM hediyeler";
                                            $s = $db->query($query);
                                            $total_results = $s->fetchColumn();
                                            $total_pages = ceil($total_results/$rowsPerPage);

                                            foreach($db->query("SELECT * FROM hediyeler ORDER BY id DESC $VeriSiralaD Limit $offset, $rowsPerPage") as $listele) {

                                                ?>

                                                <tr class="tr-shadow">
                                                    <?php echo "<td>{$listele['tarih']}</td>";?>
                                                    <?php echo "<td>{$listele['kullanici']}</td>";?>
                                                    <?php echo "<td>{$listele['hediye']}</td>";?>


                                                </form>

                                            </tr>
                                        <?php } ?>
                                    </tbody>
                                </table>
                                <nav>
                                    <ul class="pagination">
                                        <li class="page-item"><a class="page-link" href="<?php if($pageNum <= 1){ echo 'javascript:void(0);'; } else { echo "?sayfa=".($pageNum - 1); } ?>">İlk Sayfa</a></li>
                                        <li class="page-item"><a class="page-link" href="<?php if($pageNum >= $total_pages){ echo 'javascript:void(0);'; } else { echo "?sayfa=".($pageNum + 1); } ?>">Daha Fazla Kayıt</a></li>
                                    </ul>
                                </nav>
                            </div>
                            
                        </div>
                    </div>
                </div>

            </div>

        </div>

    </div>

<?php
include "footer.php";
?>