<?php
session_start();
$email = $_SESSION["email"];
if(!isset($_SESSION["email"])){
  header("location: index.php");
}
include("../connection.php");
include 'header.php';
include 'sidebar.php'; 
?>
<div class="page-wrapper">
<div class="content container-fluid">

<div class="page-header">
<div class="row">
<div class="col">
<h3 class="page-title">Blog Table</h3>
<ul class="breadcrumb">
<li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>&nbsp; /
<li class="breadcrumb-item active">Blog Table</li>
</ul>
</div>
<div class="col-auto text-end float-end ms-auto">
<a href="add-blog.php" class="btn btn-outline-primary me-2"><i class="fas fa-plus"></i> Add</a>
</div>
</div>
</div>

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

<div class="card-body">
<div class="table-responsive">
<table class="datatable table table-stripped">
<thead>
<tr>
<th>Image</th>
<th>Title</th>
<th>Description</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php

    $sql = $conn->prepare("SELECT * FROM `blog` ORDER BY `id` DESC");
    $sql->execute(); 
         $i=1;
    if($sql->rowCount()>0){
    	$rows = $sql->fetchAll();
            foreach($rows as $rowh){
?>
<tr <?php echo $i; ?>>
<td><img height="60" width="90" lass="img-responsive" alt="Event" src="../uploads/<?php echo $rowh['img']; ?>"/></td>
<td><?php echo $rowh['blog_name']; ?></td>
<td><?php $text = $rowh['description'];
          if(strlen($text)>0):
                            $text=substr($text,0,85);
              echo html_entity_decode($text); 
          endif; ?>
            
          </td>

<td><a href="edit-blog.php?id=<?=$rowh['id']?>" class="btn btn-sm bg-success-light me-2">
<i class="fas fa-pen"></i>
</a>
<a onClick="return confirm('Do you want to delete this blog <?=$rowh["blog_name"];?>');" href="delete-blog.php?id=<?=$rowh['id']?>" class="btn btn-sm bg-danger-light">
<i class="fas fa-trash"></i>
</a></td>
</tr>
<?php
$i++; 
}
}
 ?>

</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include 'footer.php'; ?>