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

27 lines
966 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=report_master.xls');
?>
<table border="1">
<?php
$sql="select * from report_master";
//echo $sql;
$result = @mysqli_query($conn,$sql);
//echo $result;
?><tr bgcolor="#eeeeee"><th width="10%">Report Id</th><th width="10%">Report Code</th><th width="6%">Report Name</th><th width="15%">Report Type</th><th width="15%">Report URL</th><th width="15%">Function Name</th></tr><?php
$i=0;
while($row=@mysqli_fetch_array($result)){
$i++;
?><tr><td><?php echo $i?></td><td><?php echo $row['report_code']?></td><td><?php echo $row['report_name']?></td><td><?php echo $row['report_type']?></td><td><?php echo $row['report_url']?></td><td><?php echo $row['fun_name']?></td></tr><?php
}
?>
</table>
<?php
//include('pdf_footer.php');
?>