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

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

            $sekil_sorgu = $db->query("select * from sifarisler where id='$idd'")->fetch(PDO::FETCH_ASSOC);
            unlink('../imgupload/' . $sekil_sorgu['resim']);
            $indi = $db->query("delete from sifarisler 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">Sifarişlə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>Növu</th>
                                    <th>Qiyməti</th>
                                    <th>Telefonu</th>
                                    <th>Gmailı</th>
                                    <th>Notu</th>
                                    <th>Tarixi</th>
                                    <th>Əməliyyat</th>
                                </tr>
                            </thead>


                            <tbody>

                                <?php
                                $cek = $db->query("select * from sifarisler order by id desc")->fetchAll(PDO::FETCH_ASSOC);
                                foreach ($cek as $goster) {
                                    $urun = $db->query("select * from mehsullar where id='{$goster["urun"]}'")->fetch(PDO::FETCH_ASSOC);
                                ?>
                                    <tr>
                                        <td><?= $goster["id"] ?></td>
                                        <td><?= $goster["adsoyad"] ?></td>
                                        <td><a href="mehsul-elavesi?islem=duzenle&id=<?= $urun["id"] ?>" target="_blank"><?= $urun["adi"] ?></a> <br>görmək üçün klikləyin</td>
                                        <td><?= $goster["fiyat"] ?>₼</td>
                                        <td><?= $goster["telefon"] ?></td>
                                        <td><?= $goster["eposta"] ?></td>
                                        <td><?= $goster["adres"] ?></td>
                                        <td><?= $goster["tarih"] ?></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>