<?php
include 'header.php';
include 'topbar.php';
include 'sidebar.php';
$hizmetsor=$db->prepare("SELECT * from hizmetler order by hizmet_id DESC");
$hizmetsor->execute(array(0));
?>
<!-- ============================================================== -->
<!-- Content Start -->
<!-- ============================================================== -->
<section class="main-content container">
<div class="page-header">
<h2>Hizmet İşlemleri</h2>
</div>
<div class="row">
<!-- İLETİŞİM MESAJLARI -->
<div class="col-md-12">
<div class="card">
<div class="card-heading card-default">
<div class="pull-right mt-10">
<a href="hizmet-ekle.php" class="btn btn-primary btn-icon"><i class="fa fa-plus"></i> Hizmet Ekle</a>
</div>
Hizmetler
</div>
<div class="card-block">
<table id="datatable1" class="table table-striped dt-responsive nowrap table-hover">
<thead>
<tr>
<th class="text-left">
<strong>Hizmet id</strong>
</th>
<th class="text-left">
<strong>Hizmet Resim</strong>
</th>
<th class="text-left">
<strong>Hizmet Adı</strong>
</th>
<th class="text-left">
<strong>Hizmet İçerik</strong>
</th>
<th class="text-left">
<strong>Resimler</strong>
</th>
<th class="text-center">
<strong>İşlemler</strong>
</th>
</tr>
</thead>
<tbody>
<?php
while ($hizmetcek=$hizmetsor->fetch(PDO::FETCH_ASSOC)) {
$hizmeticerik=mb_substr(strip_tags($hizmetcek['hizmet_icerik']), 0, 40, 'UTF-8')."...";
$resimsor=$db->prepare("SELECT * from resimh where resim_urun=:resim_id Limit 1");
$resimsor->execute(array(
'resim_id' => $hizmetcek['hizmet_id']
));
?>
<tr>
<td><?php echo $hizmetcek['hizmet_id']; ?></td>
<?php while ($resimcek=$resimsor->fetch(PDO::FETCH_ASSOC)) { ?>
<td><img style="max-height: 40px;max-width: 40px;" src="<?php echo $resimcek['resim_link']; ?>"></td>
<?php } ?>
<td><?php echo $hizmetcek['hizmet_baslik']; ?></td>
<td><?php echo $hizmeticerik; ?></td>
<td class="text-center">
<a href="hizmet-resim-duzenle.php?hizmet_id=<?php echo $hizmetcek['hizmet_id']; ?>" class="btn btn-primary btn-icon"><i class="icon-picture"></i> Resim Ayarları</a>
</td>
<td class="text-center">
<a href="hizmet-duzenle.php?hizmet_id=<?php echo $hizmetcek['hizmet_id']; ?>" title="Düzenle" class="btn btn-sm btn-success"><i class="fa fa-edit"></i></a>
<a href="controller/function.php?hizmetsil=ok&hizmet_id=<?php echo $hizmetcek['hizmet_id']; ?>" title="Sil" class="btn btn-sm btn-danger"><i class="fa fa-trash"></i></a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<!-- İLETİŞİM MESAJLARI -->
</div>

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