PHP with GNU 엑셀 다운로드
페이지 정보
- 작성자후야
- 조회 : 185
- 작성일 : 2021-05-26 13:59
본문
게시판 엑셀 다운로드 예제
<?php
include_once('./_common.php');
echo '<meta charset="utf-8">';
$sql_common = " from {$write_table} ";
$sql_search = " where (1) ";
if ($stx) {
$sql_search .= " and ( ";
switch ($sfl) {
case 'mb_point' :
$sql_search .= " ({$sfl} >= '{$stx}') ";
break;
case 'mb_level' :
$sql_search .= " ({$sfl} = '{$stx}') ";
break;
case 'mb_tel' :
case 'mb_hp' :
$sql_search .= " ({$sfl} like '%{$stx}') ";
break;
default :
$sql_search .= " ({$sfl} like '{$stx}%') ";
break;
}
$sql_search .= " ) ";
}
$sql_search .= " and mb_level >= 2 ";
if(!$sst)
$sst = "wr_num, wr_reply";
if ($sst) {
$sql_order = " order by {$sst} {$sod} ";
}
$sql = " select * {$sql_common} {$sql_search} {$sql_order} ";
$result = sql_query($sql);
header("Content-Type: application/vnd.ms-excel");
header("Content-Type: application/x-msexcel");
header("Content-Disposition: attachment; filename=".G5_TIME_YMDHIS."_excel.xls");
header("Content-Description: PHP4 Generated Data" );
//header("Content-charset=utf-8");
?>
<html>
<head>
</head>
<body bgcolor="#FFFFFF">
<table border="1" style="table-layout:fixed">
<tr align="center">
<td>column1</td>
<td>column2</td>
<td>column3</td>
<td>column4</td>
<td>column5</td>
<td>column6</td>
<td>column7</td>
<td>column8</td>
<td>column9</td>
<td>column10</td>
</tr>
<?php for ($i=0; $row=sql_fetch_array($result); $i++) { ?>
<tr>
<td><?php echo $row['wr_1'];?></td>
<td><?php echo $row['wr_2'];?></td>
<td><?php echo $row['wr_3'];?></td>
<td><?php echo $row['wr_4'];?></td>
<td><?php echo $row['wr_5'];?></td>
<td><?php echo $row['wr_6'];?></td>
<td><?php echo $row['wr_7'];?></td>
<td><?php echo $row['wr_8'];?></td>
<td><?php echo $row['wr_9'];?></td>
<td><?php echo $row['wr_10'];?></td>
</tr>
<?php }
sql_free_result($result);
?>
</table>
</body>
</html>
- 이전글그누보드 댓글 에디터 적용 2021.06.29
- 다음글관리자 비밀번호 설정(SQL) 2021.05.18