전체카테고리 등록 채택완료
지성구
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; } ?>
방법좀가르쳐주세요..고수님들 제발..
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
채택된 답변
+20 포인트
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>
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인