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

23 lines
897 B
PHP

<?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=injury_list.xls');
?>
<table class="col-sm-offset-5" border="1">
<?php
$sql="select injury_type_id,injury_type_name,injury_type_code,injury_type_desc from injury_type";
//echo $sql;
$result = mysqli_query($conn,$sql);
//echo $result;
?><tr><th>Injury Id</th><th>Injury Name</th><th>Injury Code</th><th>Injury Description</th></tr><?php
while($rowOfEmployee=mysqli_fetch_array($result)){
?><tr><td><?php echo $rowOfEmployee['injury_type_id']?></td><td><?php echo $rowOfEmployee['injury_type_name']?></td><td><?php echo $rowOfEmployee['injury_type_code']?></td><td><?php echo $rowOfEmployee['injury_type_desc']?></td></tr><?php
}
?>
</table>
<?php
include('pdf_footer.php');
?>