基于select选项的SQL查询

Question

这是我的选择选项:

<div class="selectTeam" style="float:right;color:black;">
<label for="teams">Choose Team:</label>
<select name="teams" id="teams">
<option value="both">Alle Teams</option>
<option value="2">Team 2</option>
<option value="3">Team 3</option>
</select>
</div>

这就是mu查询的样子。

$stmt = $link -> prepare('SELECT id, ident, pp, date FROM sales WHERE status=? team=? ORDER BY date DESC LIMIT 5');
$status = "OK";
$stmt -> bind_param("si", $status, $team);

我知道我可以在JS中使用document.getElementById("pplegal").value来获得所选值，但我如何在PHP中做到这一点，并根据所选内容运行查询?

If option value 2 = team=2
If option value 3 = team=3
If option value both = team=2 and 3

Answer 1

在PHP中，表单参数在$_POST。您可以检查$team == 'both'的特殊情况，并将团队列表放在SQL中。否则，使用参数将变量替换为查询。

$team = $_POST['teams'];
$stats = 'OK';
if ($team == 'both') {
$stmt = $link->prepare('SELECT id, ident, pp, date FROM sales WHERE status=? AND team IN (2, 3) ORDER BY date DESC LIMIT 5');
$stmt->bind_param('s', $status);
} else {
$stmt = $link->prepare('SELECT id, ident, pp, date FROM sales WHERE status=? AND team=? ORDER BY date DESC LIMIT 5');
$stmt->bind_param('si', $status, $team);
}