게시판 리스트 엑셀 다운로드 문의드립니다. 채택완료

</p>

<p><a href="<?= $board_skin_url ?>/excel_view.php?bo_table=<?= $bo_table ?>&wr_id=<?= $list[$i]['wr_id'] ?>" class="btn_b01 btn">엑셀다운</a>

</p>

<p><?php

include_once('./_common.php');

set_include_path( get_include_path().PATH_SEPARATOR."..");

include_once(G5_LIB_PATH."/xlsxwriter.class.php");

 

$wr_id = isset($_GET['wr_id']) ? intval($_GET['wr_id'])  : 0;

$bot_table = $g5['write_prefix'].$bo_table;

 

$filename = "테스트신청현황.xlsx";

$filepath1 = G5_DATA_PATH.'/tmp/'.$filename;

$writer = new XLSXWriter();

 

$result = sql_query("select wr_id,wr_content,wr_name,wr_last,wr_1,wr_2,wr_3,wr_4,wr_5,wr_6,wr_7,wr_8,wr_9,wr_10 from {$bot_table} where wr_id = '{$wr_id}' order by wr_name");

 

$header = [];

$widths = [];

 

// $header 제목명은 모두 달라야 됨, 뒤에 여러 서식을 지정할 수 있습니다.(위 github 참조) 

$header["연번"] = 'integer';

$header["이름"] = 'string';

$header["여분1"] = 'string';

$header["여분2"] = 'string';

$header["여분3"] = 'string';

$header["여분4"] = 'string';

$header["여분5"] = 'string';

$header["여분6"] = 'string';

$header["여분7"] = 'string';

$header["여분8"] = 'string';

$header["여분9"] = 'string';

$header["여분10"] = 'string';

$header["내용"] = 'string';

$header["신청일"] = 'string';

 

//셀너비

$widths[] = 20; $widths[] = 20; $widths[] = 20; $widths[] = 20; $widths[] = 20; $widths[] = 20;$widths[] = 20; $widths[] = 20; $widths[] = 20; $widths[] = 20; $widths[] = 20; $widths[] = 20; $widths[] = 20; $widths[] = 30;

 

$styles1 = array('font'=>'맑은 고딕','font-size'=>12,'font-style'=>'bold', 'fill'=>'#ccff999', 'halign'=>'left', 'valign'=>'center', 'border'=>'left,right,top,bottom', 'widths'=>$widths);

$styles2 = array('font'=>'맑은 고딕','font-size'=>12, 'halign'=>'left', 'valign'=>'center', 'border'=>'left,right,top,bottom','wrap_text'=>true);

 

$writer->writeSheetHeader('Sheet1', $header, $styles1);    //제목줄 서식 포함

$contents = [];

$x = 0;

foreach ($result as $field) {

    $x++;

    $contents[] = $x;

    $contents[] = $field['wr_name'];

    $contents[] = $field['wr_1'];

    $contents[] = $field['wr_2'];

    $contents[] = $field['wr_3'];

    $contents[] = $field['wr_4'];

    $contents[] = $field['wr_5'];

    $contents[] = $field['wr_6'];

    $contents[] = $field['wr_7'];

    $contents[] = $field['wr_8'];

    $contents[] = $field['wr_9'];

    $contents[] = $field['wr_10'];

    $contents[] = $field['wr_content'];

    $contents[] = $field['wr_last'];

    $writer->writeSheetRow('Sheet1', $contents, $styles2);

    $contents = [];

}

$writer->writeToFile($filepath1);

 </p>

<p>//아래부분은 수정할 필요 없습니다.

$filepath = addslashes($filepath1);

$original = urlencode($filename);

if(preg_match("/msie/i", $_SERVER["HTTP_USER_AGENT"]) && preg_match("/5\.5/", $_SERVER["HTTP_USER_AGENT"])) {

    header("content-type: doesn/matter");

    header("content-length: ".filesize("$filepath"));

    header("content-disposition: attachment; filename=\"$original\"");

    header("content-transfer-encoding: binary");

} else if (preg_match("/Firefox/i", $_SERVER["HTTP_USER_AGENT"])){

    header("content-type: file/unknown");

    header("content-length: ".filesize("$filepath"));

    header("content-disposition: attachment; filename=\"".basename($filename)."\"");

    header("content-description: php generated data");

} else {

    header("content-type: file/unknown");

    header("content-length: ".filesize("$filepath"));

    header("content-disposition: attachment; filename=\"$original\"");

    header("content-description: php generated data");

}

header("pragma: no-cache");

header("expires: 0");

flush();

$fp = fopen($filepath, "rb");

if (!fpassthru($fp)) {

    fclose($fp);

}

 

//파일 삭제

if(file_exists($filepath1)) {

    @unlink($filepath1);

}</p>

<p>