테스트 사이트 - 개발 중인 베타 버전입니다
SIR
목록으로
이전글 다음글

셀렉트박스로 리스트 표시 채택완료

익수야가자 4년 전 조회 1,378
답변 1
목록 

</p>

<p><?php

//db연결

$connect = mysqli_connect("localhost", "uksoft", "ghkdskacjf123","uksoft");

$query = "SELECT * FROM market";

$result = mysqli_query($connect, $query);

?></p>

<p><!DOCTYPE html>

<html>

<head>

<title></title>

<script src="<a href="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>" target="_blank" rel="noopener noreferrer">https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script></a>

<link rel="stylesheet" href="<a href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"" target="_blank" rel="noopener noreferrer">https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"</a> />

<script src="<a href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>" target="_blank" rel="noopener noreferrer">https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script></a>

<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->

<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->

<!--[if lt IE 9]>

<script src="<a href="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>" target="_blank" rel="noopener noreferrer">https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script></a>

<script src="<a href="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>" target="_blank" rel="noopener noreferrer">https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script></a>

<![endif]--></p>

<p></head></p>

<p><body></p>

<p></br></br></p>

<p><div class="container" style = "width:100%;">

<h3 align="center">고고기획 시장 현황</h3>


</p>

<p>

<div class="talbe-responsive"></p>

<p><!-- 추가 버튼-->

<div align="right">

<button type="button" name="add" id="add" data-toggle="modal"

data-target="#add_data_Modal" class="btn btn-success">추가</button>

</div></p>

<p>


<div id="employee_table">

<table class="table table-bordered">

           <tr>

                <th width="15%">시장명</th>

                <th width="15%">가맹점명</th>

        <th width="50%">주소</th>

                <th width="15%">보기</th>

            </tr></p>

<p><?php

while($row=mysqli_fetch_array($result))

{

?>

<tr>

                <td><?php echo $row["시장명"]; ?> </td>

                <td><?php echo $row["가맹점명"]; ?> </td>

                <td><?php echo $row["주소"]; ?> </td>

<td><button type="button" onclick="location.href='<a href="https://m.map.naver.com/search2/search.naver?query=<?php" target="_blank" rel="noopener noreferrer">https://m.map.naver.com/search2/search.naver?query=<?php</a> echo $row["주소"]; ?>&siteLocation=&queryRank=&type='" class="edit_data btn btn-warning" />지도</button></td>

</tr></p>

<p><?php

}

?>

</table>

</div>

</div>

<div>

</body>

</html></p>

<p>

시장별로 리스트를 노출 하고 싶은데 어떻게 해야할까요?

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

답변 1개

채택된 답변
+20 포인트
e
eyekiss
4년 전

</p>

<p><?php</p>

<p>//db연결</p>

<p>$connect = mysqli_connect("localhost", "uksoft", "ghkdskacjf123","uksoft");</p>

<p>$query = "SELECT * FROM market";</p>

<p>if($sh_market) $query .= " where 시장명='$sh_market' ";</p>

<p>$result = mysqli_query($connect, $query);</p>

<p>?></p>

<p><!DOCTYPE html></p>

<p><html></p>

<p><head></p>

<p><title></title></p>

<p><script src="<a href="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>" target="_blank" rel="noopener noreferrer">https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script></a></p>

<p><link rel="stylesheet" href="<a href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />" target="_blank" rel="noopener noreferrer">https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" /></a></p>

<p><script src="<a href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>" target="_blank" rel="noopener noreferrer">https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script></a></p>

<p><!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries --></p>

<p><!-- WARNING: Respond.js doesn't work if you view the page via file:// --></p>

<p><!--[if lt IE 9]></p>

<p><script src="<a href="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>" target="_blank" rel="noopener noreferrer">https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script></a></p>

<p><script src="<a href="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>" target="_blank" rel="noopener noreferrer">https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script></a></p>

<p><![endif]--></p>

<p></head></p>

<p><body></p>

<p></br></br></p>

<p><div class="container" style = "width:100%;"></p>

<p><h3 align="center">고고기획 시장 현황</h3></p>

<p>
</p>

<p> </p>

<p><form name="fsearch" method="get" action="<?php $_SERVER['PHP_SELF']?>"></p>

<p><div></p>

<p>    시장 검색 : <select name="sh_market" onchange="this.form.submit()"></p>

<p>            <?php   </p>

<p>                $que = "SELECT 시장명 from market group by 시장명";</p>

<p>                $sql = mysqli_query($connect, $que);</p>

<p>                while($row=mysqli_fetch_array($result)) {</p>

<p>            ?></p>

<p>                <option value="<?php echo $row['시장명']?>"<?php if($sh_market == $row['시장명']) echo" selected";?>><?php echo $row['시장명']?></option></p>

<p>            <?php } ?></p>

<p>            </select></p>

<p></div></p>

<p></form></p>

<p> </p>

<p><div class="talbe-responsive"></p>

<p><!-- 추가 버튼--></p>

<p><div align="right"></p>

<p><button type="button" name="add" id="add" data-toggle="modal"</p>

<p>data-target="#add_data_Modal" class="btn btn-success">추가</button></p>

<p></div></p>

<p>
</p>

<p><div id="employee_table"></p>

<p><table class="table table-bordered"></p>

<p>           <tr></p>

<p>                <th width="15%">시장명</th></p>

<p>                <th width="15%">가맹점명</th></p>

<p>        <th width="50%">주소</th></p>

<p>                <th width="15%">보기</th></p>

<p>            </tr></p>

<p><?php</p>

<p>while($row=mysqli_fetch_array($result))</p>

<p>{</p>

<p>?></p>

<p><tr></p>

<p>                <td><?php echo $row["시장명"]; ?> </td></p>

<p>                <td><?php echo $row["가맹점명"]; ?> </td></p>

<p>                <td><?php echo $row["주소"]; ?> </td></p>

<p><td><button type="button" onclick="location.href='<a href="https://m.map.naver.com/search2/search.naver?query=<?php echo $row["주소"]; ?>&siteLocation=&queryRank=&type='" class="edit_data btn btn-warning" />지도</button></td>" target="_blank" rel="noopener noreferrer">https://m.map.naver.com/search2/search.naver?query=<?php echo $row["주소"]; ?>&siteLocation=&queryRank=&type='" class="edit_data btn btn-warning" />지도</button></td></a></p>

<p></tr></p>

<p><?php</p>

<p>}</p>

<p>?></p>

<p></table></p>

<p></div></p>

<p></div></p>

<p><div></p>

<p></body></p>

<p></html></p>

<p>

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

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

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

로그인