<?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来缩短代码。在optionchange事件上获取所选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/

10-09 18:13
查看更多