엑셀저장

엑셀저장

QA

엑셀저장

본문

아래 코드 좀 봐주세요

목록을 엑셀로 저장해야 되겠는데 안되네요

어느분이 올리신것 동작이 안되서 약간 바꾸었는데 안되네요

제목은 엑셀로 출력이 되는데 데이터가 출력이 안되요

고수님들의 조언 부탁드립니다  

이 질문에 댓글 쓰기 :

답변 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");
("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");
("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>

답변을 작성하시기 전에 로그인 해주세요.
전체 123,131 | RSS
QA 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1404호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT