<?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></th>
<th>Email</th>
<th>Date</th>
<!--<th>Actions</th>-->
</tr>
</thead>
<tbody>
<?php

    $sql = $conn->prepare("SELECT * FROM `subscribers` ORDER BY `id` DESC");
    $sql->execute(); 
         $i=1;
    if($sql->rowCount()>0){
    	$rows = $sql->fetchAll();
            foreach($rows as $rowh){
?>
<tr <?php echo $i; ?>>
<td><?php echo $i; ?></td>
<td><?php echo $rowh['email']; ?></td>
<td><?php $rowh['reg_dt'];?> </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'; ?>