我有两个下拉列表从数据库中获取值:
Table_Buildings
Table_Floors
以我的形式
下坠:大楼)
$db->setQuery("SELECT buildings.building_name, floors.id
FROM buildings
INNER JOIN floors
ON buildings.id=floors.id"下垂:地板)
$db->setQuery("SELECT floor_name, id FROM floors");为了过滤下拉列表,我想使用以下脚本:
<script type="text/javascript">
var xhr;
jQuery(function($) {
$('#filter_building').change(function(){
var filterBuilding = $('#filter_building').val();
if (xhr && xhr.abort) {
xhr.abort();xhr=false;
}
xhr = jQuery.ajax( {
url: 'index.php',
data: 'option=com_mycomponent',
success: function(data){
jQuery('#filter_building').replaceWith(data);
}
});
});
});
</script> 但有些地方错了,而且不起作用。
发布于 2021-03-10 09:40:17
<strong>
<div class="float-right">
<span>From: </span><input type="date" name="From1" id="From1" />
<span>To: </span><input type="date" name="To1" id="To1" />
<input type="submit" value="Get Details" onclick="GetDetailsFromToTransactions()" />
</div>
</div>
<div class="smallsize1 float-right" id="filterdropdown">
<select id="selectBox" onchange="FilterDate(value);">
<option value="0" Idselected>Select Filter</option>
<option value="1">Today</option>
<option value="-1">Last 1 Month</option>
<option value="-3">Last 3 Months</option>
<option value="-6">Last 6 Months</option>
<option value="-9">Last 9 Months</option>
<option value="-12">Last 1 Year</option>
<option value="-24">Last 2 Years</option>
</select>
</div>
</strong>https://stackoverflow.com/questions/35625821
复制相似问题