전체검색

사이트 내 전체검색

회사소개

[복사본] 자유게시판



PRODUCT

인증서

엑셀다운로드

페이지 정보

profile_image
작성자 최고관리자
댓글 0건 조회 28회 작성일 25-12-13 09:39

본문

fffffffffff
<?php
include_once('./_common.php');

if (!$is_admin) alert('관리자만 접근 가능합니다.');

$bo_table = 'co02_2';

header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=co02_2_list.xls");

echo "<meta charset='utf-8'>";
echo "<table border='1'>";

echo "<tr>
    <th>Company Name </th>
    <th>Finst name </th>
    <th>Surname </th>
    <th>Gender </th>
    <th>Nationality </th>
    <th>Need VISA </th>
    <th>Allergies </th>
    <th>Vegetarian</th>
    <th>Arrival / Departure</th>
    <th>19 (The):</th>
    <th>20  (Wed):</th>
    <th>21 (Thu):</th>
</tr>";

$sql = " SELECT * FROM {$g5['write_prefix']}{$bo_table}
        WHERE wr_is_comment = 0
        ORDER BY wr_datetime DESC ";
$result = sql_query($sql);

while ($row = sql_fetch_array($result)) {

 

    echo "<tr>";
    echo "<td>{$row['wr_1']}</td>";
    echo "<td>{$row['wr_name']}</td>";

    echo "<td>{$row['wr_3']}</td>";
    echo "<td>{$row['wr_4']}</td>";
    echo "<td>{$row['wr_5']}</td>";

    echo "<td>{$row['wr_7']}</td>";
    echo "<td>{$row['wr_8']}</td>";
    echo "<td>{$row['wr_9']}</td>";
    echo "<td>{$row['wr_10']}</td>";
    
echo "<td>".($row['wr_11'] ? $row['wr_11'] : '미선택')."</td>";
echo "<td>".($row['wr_12'] ? $row['wr_12'] : '미선택')."</td>";
echo "<td>".($row['wr_13'] ? $row['wr_13'] : '미선택')."</td>";

 
    echo "</tr>";
}

echo "</table>";
?>


 <?php if ($is_admin) { ?>
 

    <a href="/adm/board_excel_co02_2.php" class="btn btn_02">
        co02_2 엑셀 다운로드
    </a>
<?php } ?>

첨부파일

댓글목록

등록된 댓글이 없습니다.