1:1문의게시판 엑셀다운로드 문의 채택완료

</p>

<p> </p>

<p>==리스트 상단에 배치==</p>

<p>/skin/qa/basic/list.skin.php</p>

<p> </p>

<p><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></p>

<p> </p>

<p> </p>

<p> </p>

<p>==bbs/excel.php ==</p>

<p> </p>

<p> <?

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'>"); </p>

<p>include "_common.php";</p>

<p>$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;

}

?></p>

<p><table border="1">

    <tr>

        <th>입력시간</th>

        <th>여분필드1</th>

        <th>여분필드2</th>

        <th>여분필드3</th>

        <th>여분필드4</th>

        <th>여분필드5</th>

    </tr></p>

<p><?</p>

<p>$que = sql_query("SELECT * FROM qa_content_table ORDER BY qa_id DESC"); 

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

?></p>

<p>    <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></p>

<p>