header( "Content-type: application/vnd.ms-excel" );
header( "Content-type: application/vnd.ms-excel; charset=utf-8");
header( "Content-Disposition: attachment; filename = invoice.xls" );
header( "Content-Description: PHP4 Generated Data" );
$sql = "select * from tblName order by reg_date desc";
$result = mysql_query($sql);
// 테이블 상단 만들기
$EXCEL_STR = "
<table border='1'>
<tr>
<td>번호</td>
<td>코드</td>
<td>내용</td>
</tr>";
while($row = mysql_fetch_array($result)) {
$EXCEL_STR .= "
<tr>
<td>".$row['idx']."</td>
<td>".$row['code']."</td>
<td>".$row['contents']."</td>
</tr>
";
}
$EXCEL_STR .= "</table>";
echo "<meta content=\"application/vnd.ms-excel; charset=UTF-8\" name=\"Content-type\"> ";
echo $EXCEL_STR;
?>
