PHP ， SQL 按照 name=:id an 显示所有威士忌日期和名称

Question

我正在尝试从URL显示数据库中的所有威士忌及其旁边的日期。我有几款同名的威士忌，想展示多年来的价格变化。我当前的代码如下，但目前它只显示一个日期，名称和价格。我很高兴在顶部显示一个名字，但我想显示所有的价格和日期。test_db

if (isset($_GET['id'])) {
$sql = "SELECT date , name , price  FROM test_db WHERE name = :id ORDER BY name ASC";
$stmt = $conn->prepare($sql);
$stmt->execute( [ 'id' => $_GET['id'] ] );
$row = $stmt->fetch();
echo "<div class='details'>";
    echo "<br>";
    echo $row['name'];
    echo "<br><br>";
    echo $row ['date'];
    echo"<br><br>";
    echo " £";
    echo floor ($row ['price']);
    echo "<br>";
    echo "<br>";
    echo "<br>";
echo "</div>";

Answer 1

如果你有几个结果，你应该使用一个循环，例如：

while( $row = $stmt->fetch() ) {
    echo "<div class='details'>";
        echo "<br>";
        echo $row['name'];
        echo "<br><br>";
        echo $row ['date'];
        echo"<br><br>";
        echo " £";
        echo floor ($row ['price']);
        echo "<br>";
        echo "<br>";
        echo "<br>";
    echo "</div>";
}