Excel로 자료 저장할 때 저장할 시트 정하기 채택완료

</p>

<p><?php

include_once("./_common.php");</p>

<p>

if ( ! function_exists('utf2euc')) {

    function utf2euc($str) {

        return iconv("UTF-8","cp949//IGNORE", $str);

    }

}

if ( ! function_exists('is_ie')) {

    function is_ie() {

        return isset($_SERVER['HTTP_USER_AGENT']) && (strpos($_SERVER['HTTP_USER_AGENT'], 'Trident') !== false || strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') !== false);

    }

}</p>

<p> </p>

<p>$sql_common = " from {$g5['g5_shop_category_table']} ";</p>

<p>$sql_search = " where 1";

#echo $stx; exit;

if ($stx) {

    $sql_search .= " and ( ";

    switch ($sfl) {

        case 'ca_name' :

            $sql_search .= " ({$sfl} >= '{$stx}') ";

            break;

        case 'ca_id' :

            $sql_search .= " ({$sfl} = '{$stx}') ";

            break;

        default :

            $sql_search .= " ({$sfl} like '{$stx}%') ";

            break;

    }

    $sql_search .= " ) ";

}</p>

<p>if (!$sst) {

    $sst = "ca_id";

    $sod = "asc";

}</p>

<p>$sql_order = " order by {$sst} {$sod} ";</p>

<p>$sql = " select count(*) as cnt {$sql_common} {$sql_search} {$sql_order} ";

$row = sql_fetch($sql);

$total_count = $row['cnt'];

$qry = sql_query("select * {$sql_common} {$sql_search} {$sql_order}");</p>

<p>/*================================================================================

php_writeexcel <a href="http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/" target="_blank" rel="noopener noreferrer">http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/</a>

=================================================================================*/</p>

<p>include_once(G5_LIB_PATH.'/Excel/php_writeexcel/class.writeexcel_workbook.inc.php');

include_once(G5_LIB_PATH.'/Excel/php_writeexcel/class.writeexcel_worksheet.inc.php');</p>

<p>$fname = tempnam(G5_DATA_PATH, "tmp.xls");

$workbook = new writeexcel_workbook($fname);

$worksheet = $workbook->addworksheet();</p>

<p>$num2_format =& $workbook->addformat(array(num_format => '\0#'));</p>

<p>// Put Excel data

$data = array(

"ca_id"=>"ID",

"ca_name"=>"NAME",

);</p>

<p>$data = array_map('iconv_euckr', $data);</p>

<p>$col = 0;

foreach($data as $cell) {

    $worksheet->write(0, $col++, $cell);

}</p>

<p>for($i=1; $res=sql_fetch_array($qry); $i++)

{

    $res = array_map('iconv_euckr', $res);</p>

<p>    $col = 0;

    foreach($data as $key=>$cell) {

        $worksheet->write($i, $col++, $res[$key]);

    }

}</p>

<p>$workbook->close();</p>

<p>$filename = "엑셀파일명-".date("ymd", time()).".xls";</p>

<p>if( is_ie() ) $filename = utf2euc($filename);</p>

<p>header("Content-Type: application/x-msexcel; name=".$filename);

header("Content-Disposition: inline; filename=".$filename);

$fh=fopen($fname, "rb");

fpassthru($fh);

unlink($fname);

?></p>

<p>