1:1문의게시판 엑셀다운로드 문의

==리스트 상단에 배치==

/skin/qa/basic/list.skin.php

 

<button type="button" onclick="Excel()">엑셀 다운</button>
<script>
function Excel() { 
var fm = document.fboardlist; 
fm.target = "hiddenframe"; 
fm.action = "../bbs/excel.php?qa_1=<?=$qa_1;?>&qa_2=<?=$qa_2;?>&qa_3=<?=$qa_3;?>&qa_4=<?=$qa_4;?>&qa_5=<?=$qa_5;?>&qa_6=<?=$qa_6;?>&qa_7=<?=$qa_7;?>"; 
fm.method = "post"; 
fm.submit(); 
}
</script>

 

 

 

==bbs/excel.php ==

 

 <?
header("Content-type: application/vnd.ms-excel");  
header("Content-Disposition: attachment; filename=".date('ymd').".xls");
header("Content-Description: PHP5 Generated Data");
header("Content-charset=utf-8");
echo("<meta http-equiv='content-type' content='text/html; charset=utf-8'>"); 

include "_common.php";

$qa_1 = $_GET['qa_1'];
$qa_2 = $_GET['qa_2'];
$qa_3 = $_GET['qa_3'];
$qa_4 = $_GET['qa_4'];
$qa_5 = $_GET['qa_5'];
$qa_6 = $_GET['qa_6'];
$qa_7 = $_GET['qa_7'];
$wr_ip = $_GET['qa_ip'];
if($_POST['chk_qa_id']) {
$in = implode(", ", $_POST['chk_qa_id']);
$where = "WHERE qa_1=".$qa_1."&& qa_2=".$qa_2."&& qa_3=".$qa_3."&& qa_4=".$qa_4."&& qa_5=".$qa_5."&& qa_6=".$qa_6."&& qa_7=".$qa_7;
}
?>

<table border="1">
    <tr>
        <th>입력시간</th>
        <th>여분필드1</th>
        <th>여분필드2</th>
        <th>여분필드3</th>
        <th>여분필드4</th>
        <th>여분필드5</th>
    </tr>

<?

$que = sql_query("SELECT * FROM qa_content_table ORDER BY qa_id DESC"); 
while($row = sql_fetch_array($que)) {
?>

    <tr>
        <td><?=$row['qa_datetime']?></td>
        <td><?=$row['qa_1']?></td>
        <td><?=$row['qa_2']?></td>
        <td><?=$row['qa_3']?></td>
        <td><?=$row['qa_4']?></td>
        <td><?=$row['qa_5']?></td>
    </tr>
<?
}
?>
</table>