File manager

File manager - Edit - /home/autoph/public_html/tasks/xlsFiles.tar

Back
csvSubGroup_list.php��0000644��00000001376�15025030247�0010577 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_sub_group WHERE deleted=0 ORDER BY sub_group_name ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'ID, CODE,NAME,DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo $row['id'].",".$row['sub_group_code'].",".$row['sub_group_name'].",".$row['sub_group_desc']."\n"; } } ?>��.htaccess��0000644��00000000030�15025030247�0006331 0��ustar�00��DirectoryIndex index.php��xlsEmployee_list.php��0000644��00000002343�15025030247�0010616 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_employee_data WHERE deleted=0 ORDER BY last_name ASC"; $count=0; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptEmployeeList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>NO</th> <th>EMP.ID</th> <th>COMPANY</th> <th>BRANCH</th> <th>DEPARTMENT</th> <th>FIRSTNAME</th> <th>LASTNAME</th> <th>POSITION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ $count = $count + 1; echo "<tr> <td>".$count."</td> <td>".$row['emp_id']."</td> <td>".$row['comp_id']."</td> <td>".$row['branch_id']."</td> <td>".$row['department_id']."</td> <td>".$row['first_name']."</td> <td>".$row['last_name']."</td> <td>".$row['position']."</td> </tr>"; } } echo '</table>'; ?> ��xlsDepartment_list.php��0000644��00000002004�15025030247�0011134 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_department_tbl WHERE deleted=0 ORDER BY dept_code ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptBranchList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>ID</th> <th>DIV. ID</th> <th>DEPT. CODE</th> <th>DEPT. NAME</th> <th>DEPT. DESCRIPTION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo "<tr><td>".$row['id']."</td> <td>".$row['div_code']."</td> <td>".$row['dept_code']."</td> <td>".$row['dept_name']."</td> <td>".$row['dept_desc']."</td> </tr>"; } } echo '</table>'; ?>��csvBranchKRA_list.php��0000644��00000001503�15025030247�0010554 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM kra_branch_tbl WHERE deleted=0 ORDER BY kra_name ASC"; $count =0; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'NO, MAIN KRA,KRA CODE,KRA NAME, DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ $count = $count + 1; echo $count . ",". $row['comp_kra_id'].",".$row['kra_code'].",".$row['kra_name'].",".$row['kra_description']."\n"; } } ?> ��csvCompany_list.php��0000644��00000001370�15025030247�0010431 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM vts_company WHERE deleted=0 ORDER BY comp_name ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'ID, CODE,NAME,DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo $row['comp_id'].",".$row['comp_group_code'].",".$row['comp_area_code'].",".$row['comp_code']."\n"; } } ?>��index.php��0000644��00000000113�15025030247�0006355 0��ustar�00��<?php header("Location: ../index.php"); /* Redirect browser / exit(); ?>��csvGroupKRA_list.php��0000644��00000001355�15025030247�0010460 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT FROM kra_group_tbl WHERE deleted=0 ORDER BY kra_code ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'ID, CODE,NAME,DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo $row['id'].",".$row['kra_code'].",".$row['kra_name'].",".$row['kra_description']."\n"; } } ?>��csvDivision_list.php��0000644��00000001471�15025030247�0010611 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_division_tbl WHERE deleted=0 ORDER BY division_code ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'ID, GROUP ID, DIVISION CODE,COMPANY NAME, DIVISION DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo $row['id'].",".$row['sub_grp_id'].",".$row['division_code'].",".$row['division_name'].",".$row['division_desc']."\n"; } } ?>��csvArea_list.php��0000644��00000001332�15025030247�0007671 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_area_tbl WHERE deleted=0 ORDER BY id ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'ID, CODE,NAME,DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo $row['id'].",".$row['code'].",".$row['name'].",".$row['description']."\n"; } } ?>��xlsCompany_list.php��0000644��00000001754�15025030247�0010452 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM vts_company WHERE comp_status=1 ORDER BY comp_name ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>ID 1</th> <th>CODE 2</th> <th>NAME</th> <th>DESCRIPTION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo "<tr><td>".$row['comp_id']."</td> <td>".$row['comp_group_code']."</td> <td>".$row['comp_area_code']."</td> <td>".$row['comp_code']."</td> <td>".$row['comp_name']."</td> </tr>"; } } echo '</table>'; ?>��xlsUnit_list.php��0000644��00000001773�15025030247�0007764 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_unit_tbl WHERE deleted=1 ORDER BY unit_code ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptBranchList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>ID</th> <th>DEPT. ID</th> <th>UNIT CODE</th> <th>UNIT NAME</th> <th>UNIT DESCRIPTION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo "<tr><td>".$row['id']."</td> <td>".$row['dept_id']."</td> <td>".$row['unit_code']."</td> <td>".$row['unit_name']."</td> <td>".$row['unit_desc']."</td> </tr>"; } } echo '</table>'; ?>��xlsDivision_list.php��0000644��00000002025�15025030247�0010620 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_division_tbl WHERE deleted=0 ORDER BY division_code ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>ID</th> <th>GROUP 2</th> <th>DIVISION CODE</th> <th>DIVISION NAME</th> <th>DIVISION DESC.</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo "<tr><td>".$row['id']."</td> <td>".$row['sub_grp_id']."</td> <td>".$row['division_code']."</td> <td>".$row['division_name']."</td> <td>".$row['division_desc']."</td> </tr>"; } } echo '</table>'; ?>��xlsGroupKRA_list.php��0000644��00000001675�15025030247�0010500 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM kra_group_tbl WHERE deleted=0 ORDER BY kra_code ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>ID</th> <th>KRA CODE</th> <th>KRA NAME</th> <th>KRA DESCRIPTION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo "<tr><td>".$row['id']."</td> <td>".$row['kra_code']."</td> <td>".$row['kra_name']."</td> <td>".$row['kra_description']."</td> </tr>"; } } echo '</table>'; ?>��csvBranch_list.php��0000644��00000001372�15025030247�0010222 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM vts_dealerships WHERE deal_status=1 ORDER BY deal_id ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptBranchList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'ID, COMP ID, DEAL CODE,DEAL NAME'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo $row['deal_id'].",".$row['comp_id'].",".$row['deal_code'].",".$row['deal_name']."\n"; } } ?>��xlsBranchKRA_list.php��0000644��00000002043�15025030247�0010567 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM kra_branch_tbl WHERE deleted=0 ORDER BY kra_code ASC"; $count = 0; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>NO</th> <th>MAIN KRA</th> <th>KRA CODE</th> <th>KRA NAME</th> <th>KRA DESCRIPTION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ $count = $count + 1; echo "<tr><td>".$count."</td> <td>".$row['comp_kra_id']."</td> <td>".$row['kra_code']."</td> <td>".$row['kra_name']."</td> <td>".$row['kra_description']."</td> </tr>"; } } echo '</table>'; ?>��csvEmployee_list.php��0000644��00000001624�15025030247�0010604 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_employee_data WHERE deleted=0 ORDER BY last_name ASC"; $count = 0; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'NO, EMP. ID, COMPANY,BRANCH, DEPARTMENT, FIRSTNAME, LASTNAME,POSITION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ $count = $count + 1; while($row = mysqli_fetch_array($getArea)){ echo $count. ",".$row['emp_id'].",".$row['comp_id'].",".$row['branch_id'].",".$row['department_id'].",".$row['first_name'].",".$row['last_name'].",".$row['position']."\n"; } } ?> ��csvUnit_list.php��0000644��00000001430�15025030247�0007737 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_unit_tbl WHERE deleted=1 ORDER BY unit_code ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptBranchList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'ID, DEPT. ID, UNIT CODE,UNIT NAME,UNIT DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo $row['id'].",".$row['dept_id'].",".$row['unit_code'].",".$row['unit_name'].",".$row['unit_desc']."\n"; } } ?>��xlsArea_List.php��0000644��00000001644�15025030247�0007652 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_area_tbl WHERE deleted=0 ORDER BY name ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>ID 1</th> <th>CODE 2</th> <th>NAME</th> <th>DESCRIPTION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo "<tr><td>".$row['id']."</td> <td>".$row['code']."</td> <td>".$row['name']."</td> <td>".$row['description']."</td> </tr>"; } } echo '</table>'; ?>��xlsSubGroup_list.php��0000644��00000001733�15025030247�0010607 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_sub_group WHERE deleted=0 ORDER BY sub_group_name ASC"; $count = 0; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>ID 1</th> <th>CODE 2</th> <th>NAME</th> <th>DESCRIPTION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ $count = $count + 1; while($row = mysqli_fetch_array($getArea)){ echo "<tr><td>".$count."</td> <td>".$row['sub_group_code']."</td> <td>".$row['sub_group_name']."</td> <td>".$row['sub_group_desc']."</td> </tr>"; } } echo '</table>'; ?>��xlsDivisionGroupKRA_list.php��0000644��00000001774�15025030247�0012205 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM kra_group_division WHERE deleted=0 ORDER BY kra_code ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>ID</th> <th>WEIGHT</th> <th>KRA CODE</th> <th>KRA NAME</th> <th>KRA DESCRIPTION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo "<tr><td>".$row['id']."</td> <td>".$row['weight']."</td> <td>".$row['kra_code']."</td> <td>".$row['kra_name']."</td> <td>".$row['kra_description']."</td> </tr>"; } } echo '</table>'; ?>��xlsBranch_list.php��0000644��00000001675�15025030247�0010243 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM vts_dealerships WHERE deal_status=1 ORDER BY deal_id ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptBranchList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>ID</th> <th>COMP ID</th> <th>DEAL CODE</th> <th>DEAL NAME</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo "<tr><td>".$row['deal_id']."</td> <td>".$row['comp_id']."</td> <td>".$row['deal_code']."</td> <td>".$row['deal_name']."</td> </tr>"; } } echo '</table>'; ?>��csvCompanyKRA_list.php��0000644��00000001501�15025030247�0010763 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM kra_comp_detl WHERE deleted=0 ORDER BY kra_name ASC"; $count =0; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'NO, MAIN KRA,KRA CODE,KRA NAME, DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ $count = $count + 1; echo $count . ",". $row['grp_kra_id'].",".$row['kra_code'].",".$row['kra_name'].",".$row['kra_description']."\n"; } } ?> ��csvDivisionGroupKRA_list.php��0000644��00000001500�15025030247�0012155 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM kra_group_division WHERE deleted=0 ORDER BY kra_name ASC"; $count =0; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'NO, WEIGHT,KRA CODE,KRA NAME, DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ $count = $count + 1; echo $count . ",". $row['weight'].",".$row['kra_code'].",".$row['kra_name'].",".$row['kra_description']."\n"; } } ?> ��error_log��0000644��00000041444�15025030247�0006466 0��ustar�00��[18-Oct-2023 10:51:12 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 5 [18-Oct-2023 10:51:12 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 6 [18-Oct-2023 10:51:12 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 7 [18-Oct-2023 10:51:12 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 8 [19-Oct-2023 14:00:13 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 5 [19-Oct-2023 14:00:13 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 6 [19-Oct-2023 14:00:13 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 7 [19-Oct-2023 14:00:13 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 8 [19-Oct-2023 14:56:06 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [19-Oct-2023 14:56:06 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [19-Oct-2023 14:56:06 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [19-Oct-2023 14:56:06 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [19-Oct-2023 14:56:08 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [19-Oct-2023 14:56:08 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [19-Oct-2023 14:56:08 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [19-Oct-2023 14:56:08 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [19-Oct-2023 14:56:17 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [19-Oct-2023 14:56:17 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [19-Oct-2023 14:56:17 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [19-Oct-2023 14:56:17 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [19-Oct-2023 14:56:42 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 5 [19-Oct-2023 14:56:42 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 6 [19-Oct-2023 14:56:42 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 7 [19-Oct-2023 14:56:42 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 8 [19-Oct-2023 14:56:46 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [19-Oct-2023 14:56:46 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [19-Oct-2023 14:56:46 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [19-Oct-2023 14:56:46 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [19-Oct-2023 14:56:47 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [19-Oct-2023 14:56:47 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [19-Oct-2023 14:56:47 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [19-Oct-2023 14:56:47 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [19-Oct-2023 15:26:23 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [19-Oct-2023 15:26:23 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [19-Oct-2023 15:26:23 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [19-Oct-2023 15:26:23 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [19-Oct-2023 15:27:53 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [19-Oct-2023 15:27:53 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [19-Oct-2023 15:27:53 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [19-Oct-2023 15:27:53 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [19-Oct-2023 15:28:51 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 5 [19-Oct-2023 15:28:51 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 6 [19-Oct-2023 15:28:51 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 7 [19-Oct-2023 15:28:51 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 8 [19-Oct-2023 15:28:51 Asia/Singapore] PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 16 [19-Oct-2023 16:05:20 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [19-Oct-2023 16:05:20 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [19-Oct-2023 16:05:20 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [19-Oct-2023 16:05:20 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [19-Oct-2023 16:06:39 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [19-Oct-2023 16:06:39 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [19-Oct-2023 16:06:39 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [19-Oct-2023 16:06:39 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [20-Oct-2023 09:19:25 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 5 [20-Oct-2023 09:19:25 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 6 [20-Oct-2023 09:19:25 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 7 [20-Oct-2023 09:19:25 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 8 [20-Oct-2023 09:24:55 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 5 [20-Oct-2023 09:24:55 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 6 [20-Oct-2023 09:24:55 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 7 [20-Oct-2023 09:24:55 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 8 [20-Oct-2023 09:24:55 Asia/Singapore] PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/autoph/public_html/pms_v1/xlsFiles/csvCompany_list.php on line 16 [20-Oct-2023 09:25:43 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 5 [20-Oct-2023 09:25:43 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 6 [20-Oct-2023 09:25:43 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 7 [20-Oct-2023 09:25:43 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/csvArea_list.php on line 8 [20-Oct-2023 11:04:21 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [20-Oct-2023 11:04:21 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [20-Oct-2023 11:04:21 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [20-Oct-2023 11:04:21 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 [20-Oct-2023 11:04:42 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 5 [20-Oct-2023 11:04:42 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 6 [20-Oct-2023 11:04:42 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 7 [20-Oct-2023 11:04:42 Asia/Singapore] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/autoph/cfg/conn.php:17) in /home/autoph/public_html/pms_v1/xlsFiles/xlsCompany_list.php on line 8 ��csvDepartment_list.php��0000644��00000001437�15025030247�0011132 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM pms_department_tbl WHERE deleted=0 ORDER BY dept_code ASC"; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptBranchList.csv"); header("Pragma: no-cache"); header("Expires: 0"); //make the column headers what you want in whatever order you want echo 'ID, DIV. ID, DEPT. CODE,DEPT. NAME,DEPT DESCRIPTION'."\n"; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ echo $row['id'].",".$row['div_code'].",".$row['dept_code'].",".$row['dept_name'].",".$row['dept_desc']."\n"; } } ?> ��xlsCompanyKRA_list.php��0000644��00000002041�15025030247�0010776 0��ustar�00��<?php include_once("../../../cfg/conn.php"); $sql ="SELECT * FROM kra_comp_detl WHERE deleted=0 ORDER BY kra_code ASC"; $count = 0; header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=rptAreaList.xls"); header("Pragma: no-cache"); header("Expires: 0"); echo '<table border="1">'; //make the column headers what you want in whatever order you want echo '<tr> <th>NO</th> <th>MAIN KRA</th> <th>KRA CODE</th> <th>KRA NAME</th> <th>KRA DESCRIPTION</th> </tr>'; //loop the query data to the table in same order as the headers $getArea = mysqli_query($conn,$sql); $statRow = mysqli_num_rows($getArea); if($statRow > 0){ while($row = mysqli_fetch_array($getArea)){ $count = $count + 1; echo "<tr><td>".$count."</td> <td>".$row['grp_kra_id']."</td> <td>".$row['kra_code']."</td> <td>".$row['kra_name']."</td> <td>".$row['kra_description']."</td> </tr>"; } } echo '</table>'; ?>��

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings