如何创建一个下拉菜单搜索MySQL数据库

Question

我想创建一个带有类似搜索选项的选择框，但该选项来自我的数据库。

到目前为止我有的代码

<form name="form1" action="" method="post">                            
<table>
<tr>                                    
<td>
<select name="id" class="form-control selectpicker">
<?php
$res=mysqli_query ($link,"select id, nama from peminjaman");
while ($row = mysqli_fetch_array($res)) 
{
echo "<option>";
echo $row["id"].". " .$row["nama"];
echo "</option>";
}
?>
</select>
</td>

Answer 1

试试这个。

function myFunction() {
document.getElementById("myDropdown").classList.toggle("show");
}
function filterFunction() {
var input, filter, ul, li, a, i;
input = document.getElementById("myInput");
filter = input.value.toUpperCase();
div = document.getElementById("myDropdown");
a = div.getElementsByTagName("a");
for (i = 0; i < a.length; i++) {
txtValue = a[i].textContent || a[i].innerText;
if (txtValue.toUpperCase().indexOf(filter) > -1) {
a[i].style.display = "";
} else {
a[i].style.display = "none";
}
}
}

.dropbtn {
background-color: #04AA6D;
color: white;
padding: 16px;
font-size: 16px;
border: none;
cursor: pointer;
}
.dropbtn:hover, .dropbtn:focus {
background-color: #3e8e41;
}
#myInput {
box-sizing: border-box;
background-image: url('searchicon.png');
background-position: 14px 12px;
background-repeat: no-repeat;
font-size: 16px;
padding: 14px 20px 12px 45px;
border: none;
border-bottom: 1px solid #ddd;
}
#myInput:focus {outline: 3px solid #ddd;}
.dropdown {
position: relative;
display: inline-block;
}
.dropdown-content {
display: none;
position: absolute;
background-color: #f6f6f6;
min-width: 230px;
overflow: auto;
border: 1px solid #ddd;
z-index: 1;
}
.dropdown-content a {
color: black;
padding: 12px 16px;
text-decoration: none;
display: block;
}
.dropdown a:hover {background-color: #ddd;}
.show {display: block;}

<div class="dropdown">
<button onclick="myFunction()" class="dropbtn">Dropdown</button>
<div id="myDropdown" class="dropdown-content">
<input type="text" placeholder="Search.." id="myInput" onkeyup="filterFunction()">
<a href="#about">About</a>
<a href="#base">Base</a>
<a href="#blog">Blog</a>
<a href="#contact">Contact</a>
<a href="#custom">Custom</a>
<a href="#support">Support</a>
<a href="#tools">Tools</a>
</div>
</div>

Answer 2

执行此操作的方式假定数据库中有大量数据，并且希望每次加载页面时都加载这些数据。这将减缓一切。你应该采用AJAX的工作方式。而且它已经用select2jquery插件完成了。这是链接。

https://select2.org/data-sources/ajax

api中已经做了很多事情。您只需要将数据编码为JSON。事实上，你最好从这里开始。

https://select2.org/data-sources