多个 <select> 下拉列表作为 sql 参数 | PHP

Question

我有一个正在运行的代码，它根据 1 个<select>下拉值进行sql 查询。请问如何使用2个或更多<select>下拉列表来执行多个查询参数？例子。我整理我的数据基础上accounttitle，现在我要排序accountttitle的YEAR(datedue)，我会怎么做呢？这是我到目前为止所得到的。为了 isset()  if(isset($_GET['accounttitle'])){    $accounttitle = $_GET['accounttitle'];    $year = date('Y');  if(isset($_GET['year'])){    $year = $_GET['year'];  }  else "PLEASE SELECT OPTION";  }   ?>为了 <select><div class="col-sm-9"><select class="form-control" id="select_account_title" style="text-transform:uppercase" required>  <option value="">PLEASE SELECT OPTION</option>  <?php while ($row = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)): ?>    <option value="<?= urlencode($row['accounttitle'])?>"><?= $row['accounttitle'] ?></option>  <?php endwhile; ?></select><label>Select Year: </label><select class="form-control input-sm" id="select_year">                      <?php                        for($i=2013; $i<=2033; $i++){                          $selected = ($i==$year)?'selected':'';                          echo "                            <option value='".$i."' ".$selected.">".$i."</option>                          ";                        }                      ?>                    </select></div>为了 SQL                    $sql = "SELECT referenceno, employeeidno, accounttitle, 'ON PROGRESS' as debit, postedby, approvedby, notedby, credit FROM earningsamendment where accounttitle= '$accounttitle' and YEAR(datedue)='$year'";                    $query = sqlsrv_query($conn, $sql, array(), array("Scrollable" => SQLSRV_CURSOR_KEYSET));                    while($row = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)){这是我所关心的。$(function(){  $('#select_account_title').change(function(){    window.location.href = 'earnings_amendment.php?accounttitle='+$(this).val();  });});</script>我将如何启用<script>读取 2 个参数？喜欢$(function(){  $('#select_account_title').change(function(){    window.location.href = 'earnings_amendment.php?accounttitle='+$(accounttitle).val()'&year='+$(year).val();  });});</script>或类似的东西？