<?php
  $ebultensorgu = $baglanti->prepare("SELECT * FROM  urunler  order by urun_sira ASC ");
  $ebultensorgu->execute();

  while ($ebultensonuc = $ebultensorgu->fetch()) {

    $id = $ebultensonuc['id'];
    $urun_baslik = $ebultensonuc['urun_baslik'];
    $kategori_id = $ebultensonuc['kategori_id'];

    $check = $dbh->query("SELECT * FROM category WHERE id = '".$kategori_id."' ", PDO::FETCH_ASSOC);
    if ($check->rowCount()) {
      foreach ($check as $check) {
      }

      $kategori = $check["category_name"];
    }

    ?>

    <td><?php echo $uruncek['urun_baslik'] ?></td>
    <td><?php echo $uruncek['urun_aciklama'] ?></td>
    <td><?php echo $uruncek['urun_fiyat'] ?> ₺</td>
    <td><?php echo $uruncek['urun_sira'] ?></td>
    <td><?=$kategori?>




    <td><span class="r-3 badge badge-info ">                        
      <?php if ($uruncek['urun_durum']=="1") {
       echo "Aktif";
     }elseif($uruncek['urun_durum']=="0"){
       echo "Pasif";
     } ?>
     <td>
       <a href="urun-duzenle?id=<?php echo $uruncek['urun_id'] ?>"><i class="icon-pencil"></i></a>
     </td>
   </tr>
   <?php } ?>