<a href="/down.php?>">[리스트 다운로드]</a>
===============down.php========================
<?
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=Excel.xls");
header("Content-Description: PHP4 Generated Data");
$sql = "쿼리문입력'";
$stmt = mysql_query($sql, $connect);
$num = mysql_num_rows($stmt);
?>
<meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
<table border="1" cellpadding="1" cellspacing="0">
<tr>
<td><b>NO</b></td>
<td><b>제목</b></td>
<td><b>작성자</b></td>
<td><b>날짜</b></td>
<td><b>조회수</b></td>
</tr>
<?
for($i = 0; $i < $num; $i++)
{
$res = mysql_fetch_array($stmt);
$j++;
echo "<tr><td>$j</td><td>$res[subject]</td><td>$res[name]</td><td>$res[date]</td><td>$res[hit]</td></tr>";
}
flush();
usleep(1);
?>
</table>
댓글 없음:
댓글 쓰기