php下拉列表带搜索,如何在PHP上用输入搜索下拉列表

希望一切都会好起来。我面对这个问题谁都能帮我。

我使用from jQuery从bootstrap dropdown获取值以供输入。

class="form-inline active-purple-3 active-purple-4" style="width:400px;

margin-top:-50px; margin-left:125px; ">

data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"

style="margin-top:20px; margin-left:-140px;">Search By

BY ID

Name

Position

id="in" type="text" placeholder="Search" style=" margin-top:15px; border-

radius:5px 5px 5px 5px;" aria-label="Search">

style="margin-left:365px; margin-top:-55px;">Search

$(document).ready(function(){

$('#dm a').on('click', function(){

$('#sb').text($(this).text());

});

});

$(function(){

//Listen for a click on any of the dropdown items

$("#dm a").click(function(){

//Get the value

var value = $(this).text();

//Put the retrieved value into the hidden input

$("input[name='thenumbers']").val(value);

});

});

include "Config.php";

if(isset($_POST['searchrec']))

{

$txtSearch=$_POST['txtSearch'];

$column=$_POST['thenumbers'];

if($column == "BY ID")

{

$query1="SELECT * FROM ourteam WHERE id LIKE '%$txtSearch%'";

$result1=mysqli_query($db,$query1);

$count=mysqli_num_rows($result1);

if($count == 0)

{

}else{

while($rowr=mysqli_fetch_array($result1))

{

$id=$rowr['id'];

$name=$rowr['name'];

echo "";

}

}

这段PHP代码只用于ID,我还将elesif语句用于其他实体。