<div class="content">
    <div class="container">

        <?php
        if ($_GET['sil']) {
            $idd = $_GET['sil'];

            $sekil_sorgu = $db->query("select * from sehifeler where id='$idd'")->fetch(PDO::FETCH_ASSOC);
            unlink('../imgupload/' . $sekil_sorgu['resim']);
            $indi = $db->query("delete from sehifeler where id='$idd'")->fetch(PDO::FETCH_ASSOC);
        }
        ?>
        <div class="row">
            <div class="col-md-12">
                <div class="panel panel-primary">
                    <div class="panel-heading">
                        <h3 class="panel-title">Səhifə listələ</h3>
                    </div>
                    <div class="panel-body">

                        <table id="datatable-buttons" class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>Id</th>
                                    <th>Adı</th>
                                    <th>Şəkili</th>
                                    <th>Hit</th>
                                    <th>Əlavə tarixi</th>
                                    <th>Vəziyyəti</th>
                                    <th>Əməliyyat</th>
                                </tr>
                            </thead>


                            <tbody>

                                <?php
                                $cek = $db->query("select * from sehifeler where lan='{$dilsec["id"]}'  order by id desc")->fetchAll(PDO::FETCH_ASSOC);
                                foreach ($cek as $goster) {
                                ?>
                                    <tr>
                                        <td><?= $goster["id"] ?></td>
                                        <td><?= $goster["adi"] ?></td>
                                        <td><img src="../imgupload/<?= $goster["resim"] ?>" width="150"></td>
                                        <td><?= $goster["hit"] ?></td>
                                        <td><?= $goster["eklenme_tarihi"] ?></td>
                                        <td><?php if ($goster["veziyyeti"] == 0) {
                                                echo 'Aktiv';
                                            } else {
                                                echo 'Passiv';
                                            } ?></td>

                                        <td>

                                            <div class="btn-group">
                                                <a href="sehife-elavesi?islem=duzenle&id=<?= $goster["id"] ?>" class="btn btn-default waves-effect">Düzəliş et</a>
                                                <a href="?sil=<?= $goster["id"] ?>" class="btn btn-default waves-effect">Sil</a>

                                            </div>

                                        </td>

                                    </tr>
                                <?php } ?>
                            </tbody>
                        </table>

                    </div>
                </div>
            </div>

        </div>
    </div>

</div>