<div class="content">
    <div class="container">
        <?php
        if ($_GET['sil']) {
            $idd = $_GET['sil'];
            $sekil_sorgu = $db->query("select * from elaqegelen where id='$idd'")->fetch(PDO::FETCH_ASSOC);
            unlink('../sekiler/' . $sekil_sorgu['resim']);
            $indi = $db->query("delete from elaqegelen 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">Online görüşdən gələnlər</h3>
                    </div>
                    <div class="panel-body">
                        <table id="datatable-buttons" class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>Id</th>
                                    <th>Ad Soyad</th>
                                    <th>Mövzu</th>
                                    <th>Telefon</th>
                                    <th>Gmail</th>
                                    <th>Həkim</th>
                                    <th>Mesaj</th>
                                    <th>Online görüş tarixi</th>
                                    <th>mesajın tarixi</th>
                                    <th>Əməliyyat</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $cek = $db->query("select * from elaqegelen order by id desc")->fetchAll(PDO::FETCH_ASSOC);
                                foreach ($cek as $goster) {
                                ?>
                                    <tr>
                                        <td><?= $goster["id"] ?></td>
                                        <td><?= $goster["adsoyad"] ?></td>
                                        <td><?= $goster["konu"] ?></td>
                                        <td><?= $goster["telefon"] ?></td>
                                        <td><?= $goster["email"] ?></td>
                                        <td><?= $goster["doktor"] ?></td>
                                        <td><?= $goster["mesaj"] ?></td>
                                        <td><?= $goster["tarih"] ?></td>
                                        <td><?= $goster["gonderimtarih"] ?></td>
                                        <td>
                                            <div class="btn-group">
                                                <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>