테스트 사이트 - 개발 중인 베타 버전입니다

전체카테고리 등록 채택완료

지성구 8년 전 조회 13,071


저기전체카테고리에 메뉴들을넣고싶은데..어떻해하는지모르겠습니다...

function get_mshop_category($ca_id, $len) {     global $g5;

    $sql = " select ca_id, ca_name from {$g5['g5_shop_category_table']}                 where ca_use = '1' ";     if($ca_id)         $sql .= " and ca_id like '$ca_id%' ";     $sql .= " and length(ca_id) = '$len' order by ca_order, ca_id ";

    return $sql; } ?>

   
        '.PHP_EOL;         ?>            
  •                                

                    for($j=0; $mshop_ca_row2=sql_fetch_array($mshop_ca_res2); $j++) {                     if($j == 0)                         echo '

      '.PHP_EOL;                 ?>                    
    •                                            
    •                

                      if($j > 0)                     echo '

    '.PHP_EOL;                 ?>            
  •        

            if($i > 0)             echo ''.PHP_EOL;         else             echo '

    등록된 분류가 없습니다.

    '.PHP_EOL;         ?>    
       

    방법좀가르쳐주세요..고수님들 제발..

    댓글을 작성하려면 로그인이 필요합니다.

    답변 1개

    채택된 답변
    +20 포인트
    o
    8년 전

    재귀로 변경해서 처리하였습니다 

    </p><p>function get_mshop_category($ca_id, $ca_name)</p><p>{</p><p><span style="white-space:pre">	</span>global $g5;</p><p><span style="white-space:pre">	</span>//하위메뉴 검사</p><p><span style="white-space:pre">	</span>$ca_len=intval(strlen($ca_id)/2);</p><p><span style="white-space:pre">	</span>$str = "<li class='cate_li_{$ca_len}'><a href='".G5_SHOP_URL."/list.php?ca_id={$ca_id}' class='cate_li_{$ca_len}_a'>".get_text($ca_name)."</a>";</p><p><span style="white-space:pre">	</span>$sql = " select ca_id, ca_name </p><p><span style="white-space:pre">	</span>from {$g5['g5_shop_category_table']} </p><p><span style="white-space:pre">	</span>where ca_id like '{$ca_id}__' </p><p><span style="white-space:pre">	</span>AND ca_use = '1' </p><p><span style="white-space:pre">	</span>order by ca_order ";</p><p><span style="white-space:pre">	</span>$result=sql_query($sql);</p><p><span style="white-space:pre">	</span>if(sql_num_rows($result)){</p><p><span style="white-space:pre">		</span></p><p><span style="white-space:pre">		</span>$str.="<ul class='sub_cate sub_cate{$ca_len}'>";</p><p><span style="white-space:pre">		</span>while($row=sql_fetch_array($result)){</p><p><span style="white-space:pre">			</span>$str.=<span style="white-space:pre">	</span>get_mshop_category($row[ca_id], $row[ca_name]); </p><p><span style="white-space:pre">		</span>}</p><p><span style="white-space:pre">		</span>$str.="</ul>";</p><p><span style="white-space:pre">	</span>}</p><p><span style="white-space:pre">	</span>$str.= "</li>"; </p><p><span style="white-space:pre">	</span>return $str;</p><p>}</p><p>?></p><p><button type="button" id="menu_open">전체카테고리</button></p><p><div id="category"></p><p>    <div class="ct_wr"></p><p>       <?</p><p>       $sql = " select ca_id, ca_name </p><p><span style="white-space:pre">	</span>from {$g5['g5_shop_category_table']} </p><p><span style="white-space:pre">	</span>where  length(ca_id) = '2' </p><p><span style="white-space:pre">	</span>AND ca_use = '1' </p><p><span style="white-space:pre">	</span>order by ca_order";</p><p><span style="white-space:pre">	</span>$result=sql_query($sql); </p><p><span style="white-space:pre">	</span>$str = "";</p><p><span style="white-space:pre">	</span>while($row=sql_fetch_array($result)){</p><p><span style="white-space:pre">		</span>$str .="<ul class='cate'>";</p><p><span style="white-space:pre">		</span>$str.=<span style="white-space:pre">	</span>get_mshop_category($row[ca_id], $row[ca_name]); </p><p><span style="white-space:pre">		</span>$str.="</ul>";</p><p><span style="white-space:pre">	</span>}</p><p><span style="white-space:pre">	</span>if($str){</p><p><span style="white-space:pre">		</span>echo $str; </p><p><span style="white-space:pre">	</span>}</p><p><span style="white-space:pre">	</span>else{</p><p><span style="white-space:pre">		</span>echo '<p class="no-cate">등록된 분류가 없습니다.</p>'.PHP_EOL;</p><p><span style="white-space:pre">	</span>}</p><p>       ?></p><p>    </div></p><p>    <button type="button" class="close_btn">전체카테고리<span class="sound_only">닫기</span></button></p><p></div></p><p><script></p><p>$(function (){</p><p>    var $category = $("#category");</p><p>    $("#menu_open").on("click", function() {</p><p>        $category.css("display","block");</p><p>    });</p><p>    $("#category .close_btn").on("click", function(){</p><p>        $category.css("display","none");</p><p>    });</p><p>});</p><p>$(document).mouseup(function (e){</p><p> var container = $("#category");</p><p> if( container.has(e.target).length === 0)</p><p> container.hide();</p><p>});</p><p></script></p><p>

    로그인 후 평가할 수 있습니다

    댓글을 작성하려면 로그인이 필요합니다.

    답변을 작성하려면 로그인이 필요합니다.

    로그인