<?php
echo '<form class="farm" name=f1 id=f1 method="POST" action="'.$_SERVER['PHP_SELF'].'">
<table class="table table-bordered table-hover table-striped" style="width:35%;">
<tr align="center">
<div class="prodselectbox">
<div class="floatleft cat"></div>
<div class="floatleft catid">
<td>';
$query = "select name from profiles ";
$sql = mysqli_query($conn, $query);
echo "<select id='selectcat' name='selectcat' class='form-control'>";
echo "<option value='' class='rhth'>Select Category</option>";
echo "<option class='all' value='ALL' >ALL</option>";
while($row = mysqli_fetch_array($sql)) {
echo "<option class='pre-offer' value='".$row['name']."'>".$row['name']."</option>";
}
echo "</select>";
?>
</td>
</tr>
</div>
</div>
</table>
</form>
Profiles Table
id name
1 Hello
2 Morning
我想检查是否从下拉列表中选择的值是=,以从表中动态生成值并对其执行查询。
如果我从下拉列表中选择“你好”,我想执行一些查询
如果我选择“早晨”,我想执行一些查询
最佳答案
这是一般的想法,使用jQuery来缩短代码。在option
的change
事件上获取所选select
的值,然后注释掉一些可能用于构建查询的逻辑,然后向您拥有的某些PHP脚本提供示例AJAX POST
请求,并传递查询以及success
回调。非常简单。这是$.ajax()
上其他选项的资源-http://api.jquery.com/jquery.ajax/
$("#selectcat").on("change", function() {
var val = $(this).find("option:selected").val(),
query = { name: "", location: "" };
console.log(val);
/*
if (val == 'Hello') {
query.name = "john";
query.location = "boston";
} else if (val == 'Morning') {
query.name = "billybob";
query.location = "texas";
}
$.ajax({
url: "someurl.php",
method: "POST",
data: query,
success: function(result) {
$("#someElement").html(result);
}
});
*/
});
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<select id='selectcat' name='selectcat' class='form-control'>
<option disabled selected>choose</option>
<option value="foo">foo</option>
<option value="bar">bar</option>
</select>
关于javascript - 如何从动态生成的下拉值中选择值并在php中对其执行查询,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/44221997/