如何使链接显示数据库中的特定数据？

Question

我正在为我的最后一个项目制作一个产品网站，我想做一个链接，例如，如果我点击网页上的处理器，它只会在另一个页面上显示来自我的数据库的处理器列表。同样应该发生当我点击其他类别，如主板，显卡等)。例如，我用方法post创建了一个按钮，然后在另一个页面上编写了以下代码：

parts.php

    <form action="display.php" method="post">


        <div class="partbox">
            <a href="#">
            <img src="./img/processor.jpg" alt="Go to Processor">
            </a>
            <br>
            <input type="submit" class="btnlink" value="Processor" name="processor"</input>
        </div>

        <div class="partbox">
            <a href="#">
            <img src="./img/motherboard.jpg" alt="Go to Motherboard">
            </a>
            <br>
            <input type="submit" class="btnlink" value="Motherboard" name="motherboard"</input>
        </div>

等等。

display.php

//When Clicking on Processor

if(isset($_POST['processor'])){

$sql = "SELECT * FROM products WHERE category = 'Processor' ";

$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);

echo "<h1>" . $row["category"] . "</h1>";

while($row = mysqli_fetch_assoc($result)) {
    include('info.php');
    echo $info;
}
}

//When clicking on Motherboard



if(isset($_POST['motherboard'])){

$sql = "SELECT * FROM products WHERE category = 'Motherboard ' ";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);

echo "<h1>" . $row["category"] . "</h1>";

while($row = mysqli_fetch_assoc($result)) {
    include('info.php');
    echo $info;
}
}

等等。

嗯，我不知道这是否有可能通过链接。还是可以保持这样的状态？恐怕我想得太久了，认为这可能是最简单的方法。

Answer 1

parts.php

    <div class="partbox">
        <a href="display.php?category_name=Processor">
        <img src="./img/processor.jpg" alt="Go to Processor">
        </a>
        <br>
    </div>

    <div class="partbox">
        <a href="display.php?category_name=Motherboard">
        <img src="./img/motherboard.jpg" alt="Go to Motherboard">
        </a>
        <br>
    </div>

display.php

// based on the link clicked, $_GET['category_name'] will have the 
//values Processor or Motherboard
if(isset($_GET['category_name'])){

    $sql = "SELECT * FROM products WHERE category = $_GET['category_name'] ";

    $result = mysqli_query($conn, $sql);
    $row = mysqli_fetch_assoc($result);

    echo "<h1>" . $row["category"] . "</h1>";

    while($row = mysqli_fetch_assoc($result)) {
        include('info.php');
        echo $info;
    }
}