현재등록된 상품리스트를 엑셀로 받을 수 있나요? 채택완료

</p>

<p><?php

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

<p>auth_check($auth[$sub_menu], 'r');</p>

<p>// MS엑셀 XLS 데이터로 다운로드 받음

    $sql = " SELECT * 

               FROM {$g5['g5_shop_item_table']} ";</p>

<p>    $result = sql_query($sql);

    $cnt = @sql_num_rows($result);

    if (!$cnt)

        alert("출력할 내역이 없습니다.");</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-productlist.xls");

    $workbook = new writeexcel_workbook($fname);

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

<p>    // Put Excel data

    $data = array('상품고유번호', '상품명');

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

<p>    $col = 0;

    foreach($data as $cell) {

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

    }</p>

<p>    $save_it_id = '';

    for($i=1; $row=sql_fetch_array($result); $i++)

    {</p>

<p> </p>

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

<p> </p>

<p>        $worksheet->write($i, 0, ' '.$row['it_id']);

        $worksheet->write($i, 1, $row['it_name']); //다운받길 원하시는 걸 아래로 쭉 적으시면 됩니다.



    }</p>

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

<p>    header("Content-Type: application/x-msexcel; name=\"상품리스트-".date("ymd", time()).".xls\"");

    header("Content-Disposition: inline; filename=\"상품리스트-".date("ymd", time()).".xls\"");

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

    fpassthru($fh);

    unlink($fname);</p>

<p>    exit;</p>

<p>?></p>

<p>