데이터 출력 관련 두번째 질문 입니다. 채택완료
밀크가이
11년 전
조회 5,552
</p><p><div id="main_cate2"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><ul></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">호텔/컨벤션</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">컨벤션</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">리조트</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">연수원</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">유스호스텔</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">수련원</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">세미나/회의중</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">아트홀/공연장</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">회관</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">대학교</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">소극장</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">체육시설</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#">특별 대관장소</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></ul></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></div></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><b><div class="scr"></b></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " select * from {$g5['g5_shop_category_table']} order by ca_id desc";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result2 = sql_query($sql);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for ($i=0; $row=sql_fetch_array($result2); $i++)</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>{</p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$level = strlen($row['ca_id']) / 2 - 1;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if (!$level) { ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><table id="table_list"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td width="130"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php echo get_it_image($row['ca_id'], 118, 145); ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td width="600" valign="top" style="line-height:19px;"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if ($row['ca_1'] == 1) { ?><img src="<?php echo G5_SHOP_URL; ?>/img/premium.png"> <span style="font-weight:bold; color:#f47238;">프리미엄</span><? } ?> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if ($row['ca_2'] == 1) { ?><img src="<?php echo G5_SHOP_URL; ?>/img/review.png"> <span style="font-weight:bold; color:#f47238;">리뷰</span><? } ?>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span><b><?php echo $row['ca_name']; ?></b>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>객실수 : <?=$row['ca_10']?> / <?=$row['ca_15']?>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if ($row['ca_16'] == 1) { ?> <font color="#32a526"><?php echo $row['ca_17']; ?></font><? } ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><span class="more"><a href="./categoryview.php?ca_id=<?php echo $row['ca_id']; ?>">자세히보기</a></span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></table></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? } ?></p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php }</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if ($i == 0) echo "<div style='margin-top:200px; text-align:center;'>자료가 없습니다.</div>";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p><span class="Apple-tab-span" style="white-space: pre;"> </span><b></div></b> </p><p>
글등록시에 $row[ca_3] 필드가 있는데 checkbox 옵션(호텔/컨벤션 ~ 특별 대관장소) 으로 중복 선택할 수 있습니다.
그렇게 체크를 한 후 등록을 합니다.
리스트 페이지에서 호텔/컨벤션 ~ 특별 대관장소 까지의 각 메뉴를 클릭할 때
메뉴와 같은 옵션값으로 체크되어 저장된 데이터를 페이지 이동없이 ... 사이에서
각 메뉴별로 리스트가 바뀌면서 출력되게 하려는데 잘 안되네요..
도움 좀 부탁드립니다.!
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
채택된 답변
+20 포인트
11년 전
디비에 카테고리를 한글로 저장하지는 않으셨겠죠??
카테고리들을 cate01,cate02,cate03이런식으로 저장했다는 가정하에 쓸께요~
현제소스수정
</p><p><script type="text/javascript"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>function main_cate(cate){</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$.post('./main_cate.php',{category:cate},function(data){</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$('.src').html(data);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>});</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p></script></p><p><div id="main_cate"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><ul></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate01')">호텔/컨벤션</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate02')">컨벤션</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate03')">리조트</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate04')">연수원</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate05')">유스호스텔</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate06')">수련원</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate07')">세미나/회의중</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate08')">아트홀/공연장</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate09')">회관</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate10')">대학교</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate11')">소극장</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate12')">체육시설</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><li><a href="#" onclick="javascript:main_cate('cate13')">특별 대관장소</a></li></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></ul></p><p></div></p><p><div class="src"> <!-- 처음 전체목록 --></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " select * from {$g5['g5_shop_category_table']} order by ca_id desc";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result2 = sql_query($sql);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for ($i=0; $row=sql_fetch_array($result2); $i++)</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>{</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$level = strlen($row['ca_id']) / 2 - 1;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if (!$level) { ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><table id="table_list"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td width="130"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php echo get_it_image($row['ca_id'], 118, 145); ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td width="600" valign="top" style="line-height:19px;"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if ($row['ca_1'] == 1) { ?><img src="<?php echo G5_SHOP_URL; ?>/img/premium.png"> <span style="font-weight:bold; color:#f47238;">프리미엄</span><? } ?> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if ($row['ca_2'] == 1) { ?><img src="<?php echo G5_SHOP_URL; ?>/img/review.png"> <span style="font-weight:bold; color:#f47238;">리뷰</span><? } ?>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span><b><?php echo $row['ca_name']; ?></b>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>객실수 : <?=$row['ca_10']?> / <?=$row['ca_15']?>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if ($row['ca_16'] == 1) { ?> <font color="#32a526"><?php echo $row['ca_17']; ?></font><? } ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><span class="more"><a href="./categoryview.php?ca_id=<?php echo $row['ca_id']; ?>">자세히보기</a></span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></table></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? }</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if ($i == 0) echo "<div style='margin-top:200px; text-align:center;'>자료가 없습니다.</div>";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p></div> </p><p>
main_cate.php작성
</p><p><?</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " select * from {$g5['g5_shop_category_table']} where ca_3 = '".$_POST[category]."' order by ca_id desc";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$result2 = sql_query($sql);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>for ($i=0; $row=sql_fetch_array($result2); $i++)</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>{</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$level = strlen($row['ca_id']) / 2 - 1;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if (!$level) { ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><table id="table_list"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td width="130"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><?php echo get_it_image($row['ca_id'], 118, 145); ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td width="600" valign="top" style="line-height:19px;"></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if ($row['ca_1'] == 1) { ?><img src="<?php echo G5_SHOP_URL; ?>/img/premium.png"> <span style="font-weight:bold; color:#f47238;">프리미엄</span><? } ?> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if ($row['ca_2'] == 1) { ?><img src="<?php echo G5_SHOP_URL; ?>/img/review.png"> <span style="font-weight:bold; color:#f47238;">리뷰</span><? } ?>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span><b><?php echo $row['ca_name']; ?></b>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>객실수 : <?=$row['ca_10']?> / <?=$row['ca_15']?>
</p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? if ($row['ca_16'] == 1) { ?> <font color="#32a526"><?php echo $row['ca_17']; ?></font><? } ?></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><span class="more"><a href="./categoryview.php?ca_id=<?php echo $row['ca_id']; ?>">자세히보기</a></span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></td></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></tr></p><p><span class="Apple-tab-span" style="white-space:pre"> </span></table></p><p><span class="Apple-tab-span" style="white-space:pre"> </span><? }</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if ($i == 0) echo "<div style='margin-top:200px; text-align:center;'>자료가 없습니다.</div>";</p><p><span class="Apple-tab-span" style="white-space: pre;"> </span>?> </p><p>
끝...
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인