ESH/excel_medicine_timing.php

23 lines
703 B
PHP
Raw Permalink Normal View History

2024-10-23 18:28:06 +05:30
<?php //include('pdf_header.php');
include('includes/config/config.php');
//include('pop_up_top.php');
header('Content-Type: application/force-download');
header('Content-disposition: attachment; filename=excel_medicine.xls');
?>
<table border="1">
<?php
$sql="select timing_id,timing_description,medicine_timing from medicine_timings";
//echo $sql;
$result = mysqli_query($conn,$sql);
?><tr><th>Medicine Timing </th><th>Timing Description</th></tr><?php
while($rowOfEmployee=mysqli_fetch_array($result)){
?><tr><td><?php echo $rowOfEmployee['medicine_timing']?></td><td><?php echo $rowOfEmployee['timing_description']?></td>
</tr><?php
}
?>
</table>
<?php
//include('pdf_footer.php');
?>