我想根據第一個選項類型中的選擇角色在第二個選項中獲取用戶。我有多個用戶表。我想要根據角色選擇第一個選項值的記錄，然后記錄將根據選擇從表中提取。我在這里只插入了1個表代碼。我希望當用戶選擇npa時，reocrd將從npa表中獲取。/*Ajax.php*/include('config.php');if(!empty($_POST["role"])){ // Fetch state data based on the specific country $query = "SELECT * FROM promotor"; $result = mysqli_query($conn , $query); // Generate HTML of state options list if(mysqli_num_rows($result) > 0){ echo '<option value="">Select User</option>'; while($row = mysqli_fetch_assoc($result)){ echo '<option value="'.$row['Promotor_ID'].'">'.$row['Promotor_Name'].'</option>'; } }else{ echo '<option value="" class="form-control">User not available</option>'; }<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <script type="text/javascript"> //alert(role); $(document).ready(function(){ $('#role').on('change', function(){ var role = $(this).val(); if(role){ alert(console.log(role)); } $.ajax({ type:'POST', url:'ajax.php', data:'role='+role, success:function(html){ $('#user').html(html); } }); } else{ $('#user').html('<option value="">User Not Available</option>'); } });</script> <select id="role" name="role" class="form-control"> <option value="default">Select Role</option> <option value="NPA">NPA</option> <option value="BDA">BDA</option> </select> <select id="user" name="user" class="form-control"> <option value="">Select User</option> </select>
1 回答
米脂
TA貢獻1836條經驗 獲得超3個贊
<?php
<?php
/*getcustomer.php*/
include('config.php');
$sql = "select * from promotor";
$result = mysqli_query($conn, $sql);
?>
<select id="user">
<option value="">Select Country</option>
<?php
if(mysqli_num_rows($result)){
while($row = mysqli_fetch_assoc($result)){
echo '<option value="'.$row['Promotor_ID'].'">'.$row['Promotor_Name'].'</option>';
}
}else{
echo '<option value="">User Not Available</option>';
}
?>
</select>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script>
function showCustomer(str) {
var xhttp;
if (str == "") {
document.getElementById("txtHint").innerHTML = "";
return;
}
xhttp = new XMLHttpRequest();
xhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("txtHint").innerHTML = this.responseText;
}
};
xhttp.open("GET", "getcustomer.php?q="+str, true);
xhttp.send();
}
</script>
<select id="role" name="role" class="form-control" onchange="showCustomer(this.value)">
<option value="default">Select Role</option>
<option value="NPA">NPA</option>
<option value="BDA">BDA</option>
</select>
<div id="txtHint">User list will be here</div>
- 1 回答
- 0 關注
- 116 瀏覽
添加回答
舉報
0/150
提交
取消