59 lines
1.7 KiB
PHP
59 lines
1.7 KiB
PHP
<?php
|
|
include('pdf_header.php');
|
|
?>
|
|
|
|
<html>
|
|
<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />
|
|
<body>
|
|
|
|
<table width="100%" >
|
|
|
|
<tr><div style="font-size:12px">
|
|
<td width="33%" align="left"> Run Date : <?php echo date("d-M-Y"); ?></td>
|
|
<td width="34%" align="center" style="font-size:17px"><strong>USER REPORT</strong></td>
|
|
<td width="33%" align="right"> User : <?php echo $username ?></td>
|
|
</tr>
|
|
</table>
|
|
<hr>
|
|
|
|
<table width="100%" border="1">
|
|
<tr bgcolor="#eeeeee" ><strong>
|
|
<td width="5%" align="center" >Sr</td>
|
|
<td width="5%" align="center">UID</td>
|
|
<td width="20%" align="left">User</td>
|
|
<td width="35%" align="left">Email</td>
|
|
<td width="20%" align="left">User Role</td>
|
|
<td width="15%" align="left">Status</td>
|
|
</tr></strong>
|
|
<?php
|
|
$count=1;
|
|
$sql="SELECT user_name,user_id, email,status, user_id as txt_user_id, b.role_name as role_name, remarks FROM tbl_users a, role_master b where a.role_id=b.role_id ORDER BY a.user_name ASC";
|
|
$result = mysqli_query($conn,$sql);
|
|
while($row=@mysqli_fetch_array($result))
|
|
{
|
|
extract($row);
|
|
?>
|
|
<tr class="bdr_td">
|
|
<td align="center" class="bdr_td"><?php echo $count?></td>
|
|
<td align="center" class="bdr_td"><?php echo $user_id?></td>
|
|
<td align="left" class="bdr_td"><?php echo $user_name?></td>
|
|
<td align="left" class="bdr_td"><?php echo $email?></td>
|
|
<td align="left" class="bdr_td"><?php echo $role_name?></td>
|
|
<?php if($status=='1'){
|
|
$status="Active";
|
|
}else{
|
|
$status="Inactive";
|
|
}?>
|
|
<td align="left" class="bdr_td"><?php echo $status?></td>
|
|
</tr>
|
|
<?php
|
|
$count++;
|
|
}
|
|
?>
|
|
</table>
|
|
|
|
</body>
|
|
</html>
|
|
<?php
|
|
include('pdf_footer.php');
|
|
?>
|