엑셀저장
본문
아래 코드 좀 봐주세요
목록을 엑셀로 저장해야 되겠는데 안되네요
어느분이 올리신것 동작이 안되서 약간 바꾸었는데 안되네요
제목은 엑셀로 출력이 되는데 데이터가 출력이 안되요
고수님들의 조언 부탁드립니다
답변 5
=============list.skin.php 소스=============
<a href="#null" id="btn_excel">엑셀다운</a>
$(function(){
$("#btn_excel").click(function(){
location.href="<?=$board_skin_url?>/board_excel.php?bo_table=<?=$bo_table?>";
return false;
});
});
skin 폴더내에 board_excel.php 파일 추가
=============board_excel.php 소스=============
<?
include_once("./_common.php");
echo '<meta charset="utf-8">';
if($member[mb_level] < 8){
alert("잘못된 접근입니다");
}
@Header("Content-type: application/vnd.ms-excel");
@Header("Content-type: charset=utf-8");
@header("Content-Disposition: attachment; filename=app_".date("YmdHis").".xls");
@Header("Content-Description: PHP4 Generated Data");
@Header("Pragma: no-cache");
@Header("Expires: 0");
$sql_common = " from $g5[write_prefix]$bo_table ";
if (!$sst) {
$sst = "wr_num, wr_reply";
$sod = "";
}
$sql_order = " order by {$sst} {$sod} ";
$sql = " select * {$sql_common} {$sql_search} {$sql_order} ";
$rowList = getList($sql);
?>
<table border="1">
<tr>
<th>성명</th>
<th>연령</th>
<th>회사명</th>
<th>성별</th>
<th>참관일</th>
<th>주소(우편번호)</th>
<th>주소</th>
<th>휴대전화</th>
<th>SMS수신동의</th>
<th>이메일</th>
<th>이메일수신동의</th>
<th>관심분야</th>
<th>참관목적</th>
<th>참관경로</th>
<th>등록일</th>
</tr>
<?
$j = 1;
foreach($rowList as $list) {
$write = $list;
$arr_wr_6 = @explode("|", $write[wr_6]);
?>
<tr>
<td class=""><?=$write[wr_1]?></td>
<td class=""><?=$write[wr_2]?></td>
<td class=""><?=$write[wr_3]?></td>
<td class=""><?=$write[wr_4]?></td>
<td class=""><?=$write[wr_5]?></td>
<td class=""><?=$arr_wr_6[0]?></td>
<td class=""><?=$arr_wr_6[1]?> <?=$arr_wr_6[2]?></td>
<td class=""><?=$write[wr_14]?>-<?=$write[wr_15]?>-<?=$write[wr_16]?></td>
<td class=""><?=$write[wr_8]?></td>
<td class=""><?=$write[wr_9]?></td>
<td class=""><?=$write[wr_10]?></td>
<td class=""><?=$write[wr_11]?></td>
<td class=""><?=$write[wr_12]?></td>
<td class=""><?=$write[wr_13]?></td>
<td class=""><?=$write[wr_datetime]?></td>
</tr>
<? $j++;} // end for ?>
</table>
감사합니다 지금 코드를 올리려고 했는데 답변을 주셨네요
해볼게요
아래부분을 여분필드를 사용할건데 어떻게 해야되지요
여기서 막히네요
<?
$j = 1;
foreach($rowList as $list) {
$write = $list;
$arr_wr_6 = @explode("|", $write[wr_6]);
?>
< tr>
<td class=""><?=$write[wr_1]?></td>
<td class=""><?=$write[wr_2]?></td>
<td class=""><?=$write[wr_3]?></td>
<td class=""><?=$write[wr_4]?></td>
<td class=""><?=$write[wr_5]?></td>
<td class=""><?=$arr_wr_6[0]?></td>
<td class=""><?=$arr_wr_6[1]?> <?=$arr_wr_6[2]?></td>
<td class=""><?=$write[wr_14]?>-<?=$write[wr_15]?>-<?=$write[wr_16]?></td>
<td class=""><?=$write[wr_8]?></td>
<td class=""><?=$write[wr_9]?></td>
<td class=""><?=$write[wr_10]?></td>
<td class=""><?=$write[wr_11]?></td>
<td class=""><?=$write[wr_12]?></td>
<td class=""><?=$write[wr_13]?></td>
<td class=""><?=$write[wr_datetime]?></td>
< /tr>
<? $j++;} // end for ?>
< /table>
board_excel.php 를 아래 소스로 바꿔보세요.
또한 해당 스킨폴더에 _common.php 를 만들어야 합니다.
_common.php 소스
<?php
include_once('../../../common.php');
if(isset($default['de_shop_layout_use']) && $default['de_shop_layout_use']) {
if (!defined('G5_USE_SHOP') || !G5_USE_SHOP)
die('<p>쇼핑몰 설치 후 이용해 주십시오.</p>');
define('_SHOP_', true);
}
?>
<?
include_once("./_common.php");
echo '<meta charset="utf-8">';
if($member[mb_level] < 8){
alert("잘못된 접근입니다");
}
@Header("Content-type: application/vnd.ms-excel");
@Header("Content-type: charset=utf-8");
@header("Content-Disposition: attachment; filename=app_".date("YmdHis").".xls");
@Header("Content-Description: PHP4 Generated Data");
@Header("Pragma: no-cache");
@Header("Expires: 0");
$sql_common = " from $g5[write_prefix]$bo_table ";
if (!$sst) {
$sst = "wr_num, wr_reply";
$sod = "";
}
$sql_order = " order by {$sst} {$sod} ";
$sql = " select * {$sql_common} {$sql_search} {$sql_order} ";
$result = sql_query($sql);
?>
<table border="1">
<tr>
<th>성명</th>
<th>연령</th>
<th>회사명</th>
<th>성별</th>
<th>참관일</th>
<th>주소(우편번호)</th>
<th>주소</th>
<th>휴대전화</th>
<th>SMS수신동의</th>
<th>이메일</th>
<th>이메일수신동의</th>
<th>관심분야</th>
<th>참관목적</th>
<th>참관경로</th>
<th>등록일</th>
</tr>
<?
$j = 1;
for ($i=0; $row=sql_fetch_array($result); $i++) {
$write = $row;
$arr_wr_6 = @explode("|", $write[wr_6]);
?>
<tr>
<td class=""><?=$write[wr_1]?></td>
<td class=""><?=$write[wr_2]?></td>
<td class=""><?=$write[wr_3]?></td>
<td class=""><?=$write[wr_4]?></td>
<td class=""><?=$write[wr_5]?></td>
<td class=""><?=$arr_wr_6[0]?></td>
<td class=""><?=$arr_wr_6[1]?> <?=$arr_wr_6[2]?></td>
<td class=""><?=$write[wr_14]?>-<?=$write[wr_15]?>-<?=$write[wr_16]?></td>
<td class=""><?=$write[wr_8]?></td>
<td class=""><?=$write[wr_9]?></td>
<td class=""><?=$write[wr_10]?></td>
<td class=""><?=$write[wr_11]?></td>
<td class=""><?=$write[wr_12]?></td>
<td class=""><?=$write[wr_13]?></td>
<td class=""><?=$write[wr_datetime]?></td>
</tr>
<? $j++;} // end for ?>
</table>
관심가져 주셔서 감사합니다
그런데 쇼핑몰에 사용할게 아닌데요