php - 如何使用相同的ajax比较两个值？

Question

我可以使用 ajax 比较一个下拉值，但无法比较同一 ajax 中的两个值。可以通过将两个值传递给 ajax 页面 URL 或将两个 id 传递给 ajax 函数来实现。我想比较 op_attend 表中存在的日期和运算符(operator) id，并检查同一个表中的出勤情况，并相应地显示下拉列表出席字段。所有这些 ajax 事件都应该在点击任何按钮之前发生。请帮助我!!

$('#category-list').on('change', function() {
  var state_id1 = this.value;
  $.ajax({
    type: "POST",
    url: "checkop.php",
    data: 'state_id1=' + state_id1,
    success: function(result) {
      $("#attend1").html(result);
    }
  });
});

<label>Date&nbsp;<span style="font-size:medium;color:red">*</span></label>
<div class="input-group">
  <input type="text" id="datepicker-autoclose" placeholder="dd-mm-yyyy" name="date2" class="complex-colorpicker form-control" required="" autocomplete="off">
</div>

<label>Operator Name&nbsp;<span style="font-size:medium;color:red">*</span></label>
<select class="select2 form-control custom-select" name="operator1" id="category-list" required="">
  <option value="">Please Select</option>
  <?php
        require_once("dbcontrollernew.php");
        $db_handle1 = new DBController();
        $queryoperator ="SELECT * FROM operator where status='1'";
        $operators = $db_handle1->runQuery($queryoperator);
          foreach($operators as $op)
          {
           ?>

    <option data-price7="<?php echo htmlentities($op['id']);?>" value="<?php echo htmlentities($op['operator']);?>">
      <?php echo htmlentities($op['operator']);?>
    </option>
    <?php
        }
        ?>
</select>
<input id="opid1" style="display:none" name="opid1">

<label>Attendance&nbsp;<span style="font-size:medium;color:red">*</span></label>
<select name="attendance1" id="attend1" class="select2 form-control custom-select" required="">
  <option value="">Please Select</option>

</select>

<?php
$sfid1 = ($_REQUEST['state_id1']); 
if($sfid1!='')
{
$drawing_result1 ='select * from op_attend where opid='.$_GET['state_id1'].';
 $result1=mysqli_query($con,$drawing_result1);
while($row1 =mysqli_fetch_assoc($result1)) { ?>
<option value="<?php echo $row1['attendance'];?>"><?php echo $row1['attendance'];?></option>
<?php }
}
?>

Answer 1

在ajax中，我们必须传递日期和运算符(operator)id两者

$('#category-list').on('change', function() {
  var state_id1 = $(this).val();
  $.ajax({
    type: "POST",
    url: "checkop.php",
    data: {'state_id1': state_id1, 'date' : $('#datepicker-autoclose').val()},
    success: function(result) {
      $("#attend1").html(result);
    }
  });
});

使用 post 方法获取日期和运算符(operator) ID:

<?php
$state_id1 = ($_POST['state_id1']); 
if($state_id1!='')
{
    $drawing_result ='select * from op_attend where opid='.$state_id1.' and date='.date('Y-m-d',strtotime($_POST['date']));
    $result1=mysqli_query($con,$drawing_result);
    $opt='';
    $opt.="<option value=''>Select Attendance</option>";

    while($row1 =mysqli_fetch_assoc($result1)) { 
        $opt.="<option value=".$row1['attendance_id']." >".$row1['attendance']."</option>";
    }
    echo $opt;
}
?>

希望这对您有用。