ESH/pdf_hygiene_list.php
2024-10-23 18:28:06 +05:30

48 lines
1.3 KiB
PHP

<?php
include ('pdf_header_reverse.php');
//include ('includes/config/config.php');
//include ('includes/functions.php');
// include('pop_up_top.php');
?>
<html>
<body>
<table width="100%" >
<tr><div style="font-size:12px">
<td width="25%" align="left"> Run Date : <?php echo date("d-M-Y"); ?></td>
<td width="50%" align="center" style="font-size:40px"><strong> Hygiene List</strong></td>
<td width="25%" align="left"> User : <?php echo $username ?></td>
</tr>
</table>
<table border="1">
<?php
$sql="select * from hygiene";
$result = mysqli_query($conn,$sql);
// echo $result;
$count = 1;
?><tr bgcolor="#eeeeee">
<th width=15%>Sr. No</th>
<th width=25%>Hygiene Parameter</th>
<th width=15%>Work Area Min Range</th>
<th width=15%>Work Area Max Range</th>
<th width=15%>Human Min Range</th>
<th width=15%>Human Max Range</th>
</tr><?php
$count = 0;
while ($rowOfHygiene = mysqli_fetch_array($result)) {
?><tr><td><?php echo ++$count ?></td><td><?php echo $rowOfHygiene['hygiene_parameter']?></td><td><?php echo $rowOfHygiene['work_area_min_range']?></td>
<td><?php echo $rowOfHygiene['work_area_max_range']?></td><td><?php echo $rowOfHygiene['human_min_range']?></td>
<td><?php echo $rowOfHygiene['human_max_range']?></td>
</tr><?php
}
?>
</table>
<?php
include('pdf_footer.php');
?>