캐시생성 (SELECT)(셀렉트)

<?php
/***************************************************************************
*
*        Date            : 2004-07-13
*        Copyright        : aucd29
*        E-mail            : aucd29@daum.net
*        Type            : Cache
*
*        Online Form Program Cache File
*
***************************************************************************/
ob_start();
?>

var cat1_info_p = new Array;
var cat2_info_p = new Array;
var cat2_num_p = new Array;

<?php
include_once $_SERVER[DOCUMENT_ROOT].'/include/dbconn.php3';

// 업종 최상위 카테고리를 가져온다.
$sql = "SELECT nCategoryID, sName FROM category WHERE nParent=0";
$res = mysql_query($sql);
if(!$res)
{
    echo '<font color=red style=font-size:9pt>';
    echo mysql_error();
    echo '<br>';
    echo $sql;
    echo '</font>';
    exit;
}

for($i=0; $i<$rs = mysql_fetch_array($res, MYSQL_ASSOC); $i++)
{
    echo "
    cat1_info_p[$i] = { serial:'$i', name:'$rs[sName]' };";
    $num[]=$rs[nCategoryID];
}
echo "
var cat1_num_p = $i;";


// 하위 리스트
$j=0;
$count = count($num);
for($i=1; $i<=$count; $i++)
{
    $sql2 = "SELECT nCategoryID, sName FROM category WHERE nParent=$num[$j]";
    $res2 = mysql_query($sql2);
    if(!$res2)
    {
        echo '<font color=red style=font-size:9pt>';
        echo mysql_error();
        echo '<br>';
        echo $sql2;
        echo '</font>';
        exit;
    }
    
    echo "
    cat2_info_p[$i] = new Array;";    
    for($k=0; $k<$rs2 = mysql_fetch_array($res2); $k++)
    {
        echo "
        cat2_info_p[$i][$k] = { serial:'$k', name:'$rs2[sName]' };";        
    }
    echo "
    cat2_num_p[$i] = $k;    
    
    ";
    $j++;
}
unset($num);
?>

function ChangeCat_p( cat1, cat2 )
{
    document.frm_write.nProgram1.options.length = cat2_num_p[cat1] + 1;
    document.frm_write.nProgram1.options[0] = new Option( '- 세부옵션 -', '', true, true );
    
    for( var i=0; i<cat2_num_p[cat1]; i++ )
    {
        document.frm_write.nProgram1.options[i+1] = new Option( cat2_info_p[cat1][i].name, cat2_info_p[cat1][i].name );

        if( cat2_info_p[cat1][i].name == cat2 )
        {
            document.frm_write.nProgram1.options[i+1].selected = true;
        }
    }
}

function LoadCat(cat1)
{
    document.frm_write.nProgram.options.length = cat2_num_p;
    document.frm_write.nProgram.options[0]        = new Option( '선택하세요', '', true, true );

    for(i=0; i<cat1_num_p; ++i)
    {
        document.frm_write.nProgram.options[i+1] = new Option( cat1_info_p[i].name,cat1_info_p[i].name );
        if( cat1_info_p[i].name == cat1 )
        {
             document.frm_write.nProgram.options[i+1].selected = true;
        }
    }
}

<?php
$result = ob_get_contents();
ob_end_clean();

$fp = fopen($_SERVER[DOCUMENT_ROOT]."/cache/cache.js", w);
fwrite($fp, $result);
fclose($fp);
?>