<?php

if (isset($_GET['sill'])) {

$id = intval($_GET['sill']);
$verisil = $DB->prepare("delete from hizmetler where id='$id'");
$verisil->execute(array($id));

if ($verisil) {

$not = ' <div class="alert alert-warning">
<button class="close" data-dismiss="alert"><i class="pci-cross pci-circle"></i></button>
<strong>Veri Silindi !</strong>
</div>' ;
}}


?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Hizmetler
</h1>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.html"><i class="fa fa-home"></i> Anasayfa</a></li>

<li class="breadcrumb-item active">Hizmetler</li>
</ol>
<?=$not?>
</section>

<!-- Main content -->
<section class="content">

<div class="row">
<div class="col-12">

<div class="box box-solid bg-dark">

<!-- /.box-header -->
<div class="box-body">
<div class="table-responsive">

<a href="hizmetlerekle.html" class="btn btn-block btn-warning btn-lg">Hizmet Ekle</a>


<table id="example" class="table table-bordered table-hover display nowrap margin-top-10 w-p100">
<thead>
<tr>
<th>SIRASI</th>
<th>HİZMET ADI</th>
<th>RESİM</th>
<th>HİT</th>
<th>DURUM</th>
<th>TARİH</th>
<th>DÜZENLE</th>
</tr>
</thead>
<tbody>


<?php


$sayfa = intval(@$_GET['sayfa']);
if (!$sayfa) {
$sayfa = 1;
}

$bak = $DB->prepare("select * from hizmetler ");
$bak->execute(array());
$toplam= $bak->rowCount();
$limit = 100000;
$goster = $sayfa*$limit-$limit;
$sayfasayisi = ceil($toplam/$limit);
$forlimit = 2;
$dill= $_SESSION['dil'];




$pr = $DB->query("select * from hizmetler where dil='$dill' ORDER BY sira ASC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
foreach ($pr as $tr) {

?>




<tr>
<td><?php echo $tr['sira']?></td>
<td><?php echo $tr['baslik']?></td>
<td><img height="40px" width="80px" src="../images/hizmetler/<?php echo $tr['resim']?>"></td>
<td><?php echo $tr['hit']?></td>
<td>

<?php if($tr['durum']=='1'){?>
<div class="label label-success">Aktif</div>
<?php } else { ?>
<div class="label label-danger">Pasif</div>
<?php } ?>


</td>
<td><?php echo $tr['tarih']?></td>

<td>
<a onclick="return confirm('Silmek istediğinize emin misiniz ?')" href="?sill=<?php echo $tr['id']; ?>" class="btn btn-sm btn-danger" data-toggle="tooltip" data-original-title="Sil"><i class="ti-trash" aria-hidden="true"></i></a>
<a href="hizmetlerekle.html?ok=gn&id=<?php echo $tr['id']?>" class="btn btn-sm btn-success" data-toggle="tooltip" data-original-title="Düzenle"><i class="fa fa-edit" aria-hidden="true"></i></a>






</tr>



<?php } ?>




</tbody>

</table>
</div>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->



</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->