[PHP] DB 내용 엑셀 다운로드

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;  
?>