主页 / 问题 / 829672
Accepted
Егор
Asked:2020-05-18 17:02:15 +0000 UTC2020-05-18 17:02:15 +0000 UTC

JS Jquery 收集查询数据库的命令

  • 772

有 3 个选择字段和 1 个 ajax 请求我想从 3 个选择中收集一个请求以替换为 ajax

 $("#Month").change(function () {
   var Month = $("#Month").val();
    f2 = " and `date1` LIKE '___"+Month+"_____'";
    return(f2);
    Filters();
    });

其他的以此类推select如何组合成一个变量，这样如果按下了select就加，如果没有就加，那么就不加

javascript

2 个回答

  1. Best Answer

    var Month, Days, Years; 
var data = {};
$("#Month").change(function () {
   data.Month = " and `date1` LIKE '___" + $(this).val() + "_____'";
}); 
$("#Days").change(function () {
   data.Days = " and `date1` LIKE '___" + $(this).val() + "_____'";
}); 
$("#Years").change(function () {
   data.Years = " and `date1` LIKE '___" + $(this).val() + "_____'";
}); 
$("#clickMe").click(function () {
	console.log("data", data);
}); 
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<select id="Month">
  <option value="1">1</option>
  <option value="2">2</option>
  <option value="3">3</option>
</select>
<select id="Days">
  <option value="1">1</option>
  <option value="2">2</option>
  <option value="3">3</option>
</select>
<select id="Years">
  <option value="1">1</option>
  <option value="2">2</option>
  <option value="3">3</option>
</select>
<button id="clickMe">Send</button>

    • 1

  2. 您可以创建一个外部变量来收集更改的数据。

    {
  const selY = $('#year');
  const selM = $('#month');
  const selD = $('#day');

  const btn = $('#send');
  
  const filterDate = {};
  selY.change(() => filterDate.y = selY.val());
  selM.change(() => filterDate.m = selM.val());
  selD.change(() => filterDate.d = selD.val());


  const getFilterDateValue = () => 
    ['y', 'm', 'd']
     .map(k => filterDate[k])
     .filter(a => a)
     .join('');
  btn.click(() => console.log('value: ', getFilterDateValue()));
}
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>


<select id="day">
  <option value=01>1</option>
  <option value=02>2</option>
  <option value=03>3</option>
</select>
<select id="month">
  <option value=01>Янв</option>
  <option value=02>Фев</option>
  <option value=03>Mар</option>
</select>
<select id="year">
  <option value=2018>2018</option>
  <option value=2019>2019</option>
</select>

<hr/>
<button id=send>Send</button>

    • 0

相关问题