JezK
Edit File: news_management.php
<?php include('admin_functions.php'); if($_SESSION['username']=='') { echo "<script>location.replace('index.php');</script>" ; } $admin=new adm_functions(); $newsdata = $admin->get_news_post(); //print_r($newsdata);exit; $newsdata_active = $admin->get_news_postactive(); $news_data = ''; $i =1; //<td>'.$val['owner'].'</td> foreach($newsdata as $k=>$val){ $news_data .= ' <tr><td>'.$i.'</td> <td style="word-break: break-all;">'.$val['title'].'</td> <td>'.$val['postdate'].'</td> <td><a href="news_management_view.php?id='.$val['id'].'"><input type="button" class="btn btn-success" value="View"></a> <a href="news_management_edit.php?id='.$val['id'].'"><input type="button" class="btn btn-info" value="Edit"></a> <a href="news_management_delete.php?id='.$val['id'].'"><input type="button" class="btn btn-danger" value="Delete" onclick="return confirm_delete()"></a>'; if($val['block_news'] =="0"){ $news_data .='<a type="button" href="newsblock.php?id='.$val['id'].'&status=1" class="btn btn-primary">Lock</a>'; } else{ $news_data .='<a type="button" class="btn btn-danger" href="newsblock.php?id='.$val['id'].'&status=0">Unlock</a>'; } $news_data .='</td> </tr>'; $i++; } $currentPage='news_management'; include"header.php" ?> <div class="main-panel"> <nav class="navbar navbar-default"> <div class="container-fluid"> <div class="navbar-header"> <button type="button" class="navbar-toggle"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar bar1"></span> <span class="icon-bar bar2"></span> <span class="icon-bar bar3"></span> </button> <a class="navbar-brand" href="#">News Management</a> </div> </div> <div class="collapse navbar-collapse"> </div> </nav> <div class="content"> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div class="col-md-6" style="margin-bottom: 35px;"> <p>Total News Posted:<?php echo count($newsdata); ?></p> <p>Total News Active:<?php echo $newsdata_active; ?></p> </div> <div class="col-md-6"> <!-- <a href="news_filtration.php"><button class="btn btn-default pull-right" >News Filtration</button></a> --> <a href="post_news.php"><button class="btn btn-default pull-right" style="margin-right:10px;">Post News</button></a> </div> <div class="content table-responsive table-full-width"> <table class="table table-striped" id="example"> <thead> <th>S.No</th> <th style="width:300px;">News Title</th> <th>Posted Date & Time</th> <!-- <th>Owner</th> --> <th>Action</th> </thead> <tbody> <?php echo $news_data; ?> </tbody> </table> </div> </div> </div> </div> </div> <?php include"footer.php" ?> <script> $(document).ready(function() { $('#example').DataTable(); }) function confirm_delete() { return confirm('Are you sure to delete this News?'); } </script> <link href="https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css" rel="stylesheet"> <script src="//code.jquery.com/jquery-1.12.4.js"></script> <script src="https://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"></script>