<?php
include "header.php";
include "sidebar.php";
?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>Blog List
<a href="add-blog.php" class="btn btn-primary pull-right" style="margin-top:-5px;"><i class="fa fa-plus"></i> Add Post</a>
</h1>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-sm-12">
<div class="box">
<div class="box-body">
<?php if(isset($_SESSION['msg']) && $_SESSION['msg']=='data_uploaded') { ?>
<div class="row">
<div class="col-sm-6">
<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
Post Added successfully!!.
</div>
</div>
</div>
<?php
$_SESSION['msg'] = '';
} ?>
<?php if(isset($_SESSION['msg']) && $_SESSION['msg']=='data_updated') { ?>
<div class="row">
<div class="col-sm-6">
<div class="alert alert-warning alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
Post Updated successfully!!.
</div>
</div>
</div>
<?php
$_SESSION['msg'] = '';
}
?>
<?php if(isset($_SESSION['msg']) && $_SESSION['msg']=='status_changed') { ?>
<div class="row">
<div class="col-sm-6">
<div class="alert alert-info alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
Post Status changed successfully!!.
</div>
</div>
</div>
<?php
$_SESSION['msg'] = '';
} ?>
<?php if(isset($_SESSION['msg']) && $_SESSION['msg']=='delete_data') { ?>
<div class="row">
<div class="col-sm-6">
<div class="alert alert-danger alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
Post Deleted !!.
</div>
</div>
</div>
<?php
$_SESSION['msg'] = '';
} ?>
<table id="employee-role-table" class="table table-bordered table-striped">
<thead>
<tr>
<th># Sr. No.</th>
<th>Title</th>
<th>Date</th>
<th>Image</th>
<th>Author</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$fetch_blog=mysqli_query($con,"SELECT * FROM `ahq_blog` ORDER BY `blog_id` DESC") or die(mysqli_error($con));
$i=1;
if(mysqli_num_rows($fetch_blog)>0) {
while($data = mysqli_fetch_array($fetch_blog)) {
?>
<tr>
<td><?php echo $i;?></td>
<td><?php echo $data['title'];?></td>
<td><?php echo date('d-m-Y',strtotime($data['blog_date']));?></td>
<?php $blogImg = "BlogImg";?>
<td><?php $imgfileSource = ".." . DIRECTORY_SEPARATOR . $blogImg . DIRECTORY_SEPARATOR . $data['image'];
if(file_exists($imgfileSource)){ ?>
<img src="<?php echo $imgfileSource; ?>" style="width:100px; height:100px;" /><?php } ?>
</td>
<td><?php echo $data['author'];?></td>
<td>
<?php if($data['status']=="1"){?>
<a title="Click here to Disable Record" class="show-pointer"><span class="label label-success statusButton" id="<?php echo base64_encode($data['blog_id']);?>">Active</span></a>
<?php }
if($data['status']=="0"){?>
<a title="Click here to Active This Record" class="show-pointer"><span class="label label-warning statusButton" id="<?php echo base64_encode($data['blog_id']);?>">Deactive</span></a>
<?php }?>
</td>
<td>
<a href="edit-blog.php?id=<?php echo base64_encode($data['blog_id']); ?>" class="btn btn-warning" title="Edit"><i class="fa fa-pencil"> Edit</i></a>
<a title="Click here to Delete This Record" class="show-pointer"><span class="btn btn-danger deleteButton" id="<?php echo base64_encode($data['blog_id']);?>"><i class="fa fa-trash"> Delete</i></span></a>
</td>
</tr>
<?php
$i++;
} }
?>
</tbody>
</table>
</div><!-- /.box-body -->
</div><!-- /.box -->
</div>
</div>
</section>
</div>
<script>
$(".statusButton").click(function() {
var dataid = $(this).attr('id');
if(confirm("Do you really want to change the status of this record?")) {
window.location = "blog-process.php?action=status&id="+dataid;
}
});
$(".deleteButton").click(function() {
var dataid = $(this).attr('id');
if(confirm("Do you really want to delete this record?")) {
window.location = "blog-process.php?action=delete&id="+dataid;
}
});
$(function () {
$('#employee-role-table').DataTable({
"paging": true,
"lengthChange": true,
"searching": true,
"ordering": true,
"info": true,
"autoWidth": false
});
});
</script>
<?php
include "footer.php";
?>