다중분류검색에대해서 물어보고싶어요...
본문
<br />
<div><br /></div>
<div><div><div class="board_category_tab"></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><a href='board.php?bo_table=<?=$bo_table?>&sca=<?=$sca?>&sca3=<?=$sca3?>' class="board_category <?=!$sca2?"thisTab":" "?>" >전체</a></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><? for ($j=0; $j<count($cat1); $j++){</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$this_style='';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($sca2==$cat1[$j]) $this_style=" thisTab";//여기서 $stx 에서 짤라낸 값을 가지고 판단</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>?></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><a href='board.php?bo_table=<?=$bo_table?>&sca=<?=$sca?>&sca2=<?=$cat1[$j]?>&sca3=<?=$sca3?>' class="board_category<?=$this_style?>"><?=$cat1[$j]?></a></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><?}?></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div> </div>
<div><br /></div>
<div><!-- 3단/////////////////////////////////////////////////////////////////////// --></div>
<div> <div class="board_category_tab"></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><a href='board.php?bo_table=<?=$bo_table?>&sca=<?=$sca?>&sca2=<?=$sca2?>' class="board_category <?=!$sca3?"thisTab":" "?>" >전체</a></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><? for ($k=0; $k<count($cat2); $k++){</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$this_style='';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($sca3==$cat2[$k]) $this_style=" thisTab";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>?></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><a href='board.php?bo_table=<?=$bo_table?>&sca=<?=$sca?>&sca2=<?=$sca2?>&sca3=<?=$cat2[$k]?>' class="board_category<?=$this_style?>"><?=$cat2[$k]?></a></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><?}?></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div> </div></div>
<div><br /></div>
<div><font color="#c00000">현재는 값을 뽑아와요...</font></div>
<div><font color="#c00000"><br /></font></div>
<div><font color="#c00000">bbs/board.php?bo_table=0505&sca1=서울&sca2=가격&sca=민박</font>
<div><font color="#c00000"><br /></font></div>
<div><font color="#c00000">이런식으로 검색할려면 어떻케 해야되죠.. sca는 카테고리고 </font></div>
<div><font color="#c00000">sca1=서울 &sca2=가격 머 이렇케 할려면 </font></div>
<div><font color="#c00000"><br /></font></div>
<div><font color="#c00000">꼭 좀 부탁 드려여 ^^ </font></div></div>
<div><br /></div>
<div><div><div class="board_category_tab"></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><a href='board.php?bo_table=<?=$bo_table?>&sca=<?=$sca?>&sca3=<?=$sca3?>' class="board_category <?=!$sca2?"thisTab":" "?>" >전체</a></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><? for ($j=0; $j<count($cat1); $j++){</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$this_style='';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($sca2==$cat1[$j]) $this_style=" thisTab";//여기서 $stx 에서 짤라낸 값을 가지고 판단</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>?></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><a href='board.php?bo_table=<?=$bo_table?>&sca=<?=$sca?>&sca2=<?=$cat1[$j]?>&sca3=<?=$sca3?>' class="board_category<?=$this_style?>"><?=$cat1[$j]?></a></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><?}?></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div> </div>
<div><br /></div>
<div><!-- 3단/////////////////////////////////////////////////////////////////////// --></div>
<div> <div class="board_category_tab"></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><a href='board.php?bo_table=<?=$bo_table?>&sca=<?=$sca?>&sca2=<?=$sca2?>' class="board_category <?=!$sca3?"thisTab":" "?>" >전체</a></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><? for ($k=0; $k<count($cat2); $k++){</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$this_style='';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($sca3==$cat2[$k]) $this_style=" thisTab";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>?></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><a href='board.php?bo_table=<?=$bo_table?>&sca=<?=$sca?>&sca2=<?=$sca2?>&sca3=<?=$cat2[$k]?>' class="board_category<?=$this_style?>"><?=$cat2[$k]?></a></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span><?}?></div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span></div> </div></div>
<div><br /></div>
<div><font color="#c00000">현재는 값을 뽑아와요...</font></div>
<div><font color="#c00000"><br /></font></div>
<div><font color="#c00000">bbs/board.php?bo_table=0505&sca1=서울&sca2=가격&sca=민박</font>
<div><font color="#c00000"><br /></font></div>
<div><font color="#c00000">이런식으로 검색할려면 어떻케 해야되죠.. sca는 카테고리고 </font></div>
<div><font color="#c00000">sca1=서울 &sca2=가격 머 이렇케 할려면 </font></div>
<div><font color="#c00000"><br /></font></div>
<div><font color="#c00000">꼭 좀 부탁 드려여 ^^ </font></div></div>
답변 1
sca1=서울&sca2=가격&sca=민박
아래처럼 정의하고..
$sca = sca.sca1.sca2
where 추가 하면 되겠네요.
sca저장되는컬럼.sca1저장되는컬럼.sca2저장되는컬럼 = '$sca'
이거는 무조건 카테고리 값이 있어야 되는거 아닌가요?... sca값이없다면 ..??.. 안되자나요..
처음 민박 클릭 안하고 가격먼저 클릭하고 혹은 서울 먼저 클릭했을시면 ..??..
흠.... 어떻케 해야되지 ㅠㅠ
$dyn_where = " 1 = 1 ";
if($sca != "") $dyn_where .= " and sca = '$sca'";
if($sca1 != "") $dyn_where .= " and sca1 = '$sca1'";
if($sca2 != "") $dyn_where .= " and sca2 = '$sca2'";
where 이하에 $dyn_where 추가 하면 될것같네요.
아래처럼요..
where $dyn_where
and조건이 아니면 or 로 하면 될것 같네요.
답변을 작성하시기 전에 로그인 해주세요.