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

40 lines
1.1 KiB
PHP

<?php
header("Content-type:application/octet-stream");
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=excel_task_list.xls");
header("Pragma: no-cache");
header("Expires: 0");
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
?>
<?php
include('includes/config/config.php');
include('includes/functions.php')
//include('pop_up_top.php');
?>
<body>
</table>
<table border="1">
<?php
$sql_task=base64_decode($filterkey);
error_log("query: ".$sql_task);
$results_task = @mysqli_query($conn, $sql_task);
//echo $result;
?><tr bgcolor='#eeeeee'><th width=10%>S.no</th><th width=30%>Task Name</th><th width=30%>Task Discription</th><th width=20%>Frequency Type</th><th width=20%>OHC Type</th>
</tr><?php
while ($row = @mysqli_fetch_assoc($results_task)) {
extract ( $row );
$task_id=$row['task_id'];
$count = $count + 1;
?><tr><td><?=$count?></td><td><?= $row['task_name']?></td><td><?= $row['task_description']?></td><td><?=$row['frequency_name']?></td><td><?=$row['ohc_type_name']?></td>
</tr><?php
}
?>
</table>
</body>