如何筛选下拉选项以列出我的表条目？
HTML过滤器示例：
<form action="filter.php" method="post">
<select name="filter">
<option>FILTER:</option>
<option value="alphabetical">ASC</option>
<option value="date">Date</option>
</select>
</form>
MySQL基本选择：
SELECT * FROM table ORDER BY name
列出值的基本HTML：
echo '<h1>'.$name.'</h1>
<h1>'.$date.'</h1>';
第二个过滤器（日期）应该执行SELECT，列出所有具有ASC日期的条目。第二个第一个（按字母顺序）应该执行SELECT，只按ASC列出名称的所有条目。
你知道MySQL SELECT在这种情况下是如何工作的吗？
html:
<select name="filter" onchange="filter(this.value)">
<option>FILTER:</option>
<option value="alphabetical">ASC</option>
<option value="date">Date</option>
</select>
<div id="results"></div>// store the results here
Jquery：
function filter(item){
$.ajax({
type: "POST",
url: "filter.php",
data: { value: item},
success:function(data){
$("#results").html(data);
}
});
}
filter.php:
include "connection.php"; //database connection
$fieldname = $_POST['value'];
if($fieldname=="alphabetical"){
// if you choose first option
$query1 = mysqli_query("SELECT * FROM table ORDER BY name ASC");
// echo the results
}else{
// if you choose second option
$query1 = mysqli_query("SELECT * FROM table ORDER BY date ASC");
// echo the results
}
注意：不要忘记包含jquery库。
假设name和date是表中的字段名，这些应该会起作用。
SELECT * FROM table ORDER BY name ASC
SELECT * FROM table ORDER BY date ASC
我会这样做，
HTML:
<form action="filter.php" method="post">
<select name="filter">
<option>FILTER:</option>
<option value="alphabetical">ASC</option>
<option value="date">Date</option>
</select>
</form>
PHP
<?php
switch($_POST['filter']){
case "alphabetical":
$field = "name";
break 1;
case "date":
$field = "date";
break 1;
}
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
$stmt = $mysqli->prepare("SELECT * FROM table ORDER BY ? ASC");
$stmt->bind_params("s",$field);
$stmt->execute();
//ETC
?>