24'C 구름 많음
서울 강남구
다음은 PHP와 javaScript코드입니다.
<div class="adressWrap">
<select name="wr_4" class="y1" id="selectID">
<option value="" required>선택해주세요</option>
<!-- 사용할데이터 불러오기 -->
<?php
$sql="SELECT DISTINCT `쿼리` FROM `쿼리`";
$result = sql_query($sql);
while ($row = sql_fetch_array($result))
{
echo '<option value="'.$row['쿼리'].'">'.$row['쿼리'].'</option>';
}
?>
</select>
<select name="wr_6" class="y2" id="selectID2" required>
</select>
</div>
<script>
$(document).ready(function(){
$('#selectID').on('change', function(){
var path = window.location.href;
// alert(path+"theme/basic/ajaxPHP.php");
$.post(path+"theme/basic/ajaxPHP.php",{optVal:this.value}, function(data) {
$('#selectID2').empty();
$('#selectID2').append('<option value="">선택해주세요</option>');
$('#selectID2').append(data);
});
});
});
</script>
ajaxPHP.php 파일
<?php
include_once('./_common.php');
$ajax = $_POST['optVal'];
$option="";
$sql="SELECT `쿼리` FROM `쿼리` WHERE `쿼리`="".$ajax.""";
// echo $sql;
$result = sql_query($sql);
while ($row = sql_fetch_array($result))
{
// echo $row['co_gu'];
$option=$option.'<option value="'.$row['쿼리'].'">'.$row['쿼리'].'</option>';
}
echo $option;
?>