php - 如何在 SQL 命令中使用两个 where 语句？

Question

我有一些代码可以选择两个日期之间数据库中的所有条目，但我也希望它不选择“状态”列中“已删除”的任何条目。我可以让它执行其中一个或两个操作，但不能同时执行这两个操作。

try {
$DBH = new PDO("mysql:host=localhost;dbname=$dbname",$dbuser,$dbpass);
$DBH->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$STH = $DBH->prepare("SELECT Link, Type, Location, Urgency, Date, Time, Status, Days FROM reports WHERE truedate BETWEEN :start_date AND :end_date");
$STH->execute(array(':start_date' => $start_date_variable, ':end_date' => $end_date_variable));


$rows = $STH->fetchAll(PDO::FETCH_ASSOC);

echo "<table>";

foreach ($rows as $row) {
    echo "<tr><td>" . $row['Link'] . "</td><td>" . $row['Type'] . "</td><td>" . $row['Location'] . "</td><td>" . $row['Urgency'] . "</td><td>" . $row['Date'] . "</td><td>" . $row['Time'] . "</td><td>" . $row['Status'] . "</td><td>" . $row['Days'] . "</td></tr>";
}

echo "</table>";

}catch(PDOException $e) {
echo $e->getMessage();
}

那么我该如何使用两个 where 语句来缩小我的结果范围呢？

Answer 1

只需在 truedate 检查之前使用 AND 运算符，如图所示。

SELECT Link, Type, Location, Urgency, Date, Time, Status, Days FROM reports WHERE Status NOT LIKE '%Removed%' AND truedate BETWEEN :start_date AND :end_date