JezK

Edit File: smsreport_admin.php

<?php 
include('admin_functions.php');
 	if($_SESSION['username']=='')
	{
		echo "<script>location.replace('index.php');</script>" ;
	}   
    
	$admin=new adm_functions();
	$sms = $admin->get_smsReportsFromAdmin();
	$i=1;
	$smsdata = '';
    foreach($sms as $k=>$val){
		if($val['reportDate']!='') $dt=date("m-d-Y H:m:i",strtotime($val['reportDate']));
		else
		$dt='';
		$smsdata .=' <tr>
						<td>'.$i.'</td>
						<td>'.$val['phonenumber'].'</td>
						<td>'.$val['otp'].'</td>
						<td>'.$val['name'].'</td>
						<td>'.$dt.'</td>
						<td>'.$val['state'].'<br/>'.$val['district'].'<br/>'.$val['mandal'].'<br/>'.$val['city'].'</td>
					</tr>';
					$i++;
	}
    $currentPage='smsreport_admin';
    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="#">Sms Report Notice</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="pull-right"><p>Total Users:50</p></div>
					 <div class="content table-responsive table-full-width">
                                <table id="example" class="display table table-striped">
                                    <thead>
                                        <th>S.No</th>
                                        <th>Mobile Number</th>
                                        <th>OTP</th>
                                    	<th>Name</th>
                                    	<th>Date & Time</th>
                                    	<th>Address</th>
                                    	</thead>
                                    <tbody>
										<?php echo $smsdata ;?>
                                    </tbody>
                                </table>

</div>
					</div>
                </div>
            </div>
        </div>
   <?php include"footer.php" ?>
<script>
$(document).ready(function() {
    $('#example').DataTable();
})
</script>
  <link href="https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css" rel="stylesheet">