PHP를 사용하여 간단한 제품 비교 기능을 개발하는 방법

<form action="compare.php" method="GET">
  <input type="text" name="search_keyword" placeholder="请输入要搜索的商品名称">
  <input type="submit" value="搜索">
</form>

$search_keyword = $_GET['search_keyword'];

// 连接数据库
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "products";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
  die("连接失败: " . $conn->connect_error);
}

// 查询匹配的商品信息
$sql = "SELECT * FROM products WHERE name LIKE '%$search_keyword%'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    // 显示商品信息，包括名称、价格、图片等
    echo "<div>";
    echo "<h3>" . $row["name"] . "</h3>";
    echo "<p>价格：" . $row["price"] . "</p>";
    echo "<img src='" . $row["image"] . "' alt='" . $row["name"] . "'>";
    echo "</div>";
  }
} else {
  echo "没有找到相关商品";
}
$conn->close();

$product1_id = $_GET['product1_id'];
$product2_id = $_GET['product2_id'];

// 连接数据库
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "products";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
  die("连接失败: " . $conn->connect_error);
}

// 查询商品1的详细信息
$sql = "SELECT * FROM products WHERE id = $product1_id";
$result = $conn->query($sql);
$row1 = $result->fetch_assoc();

// 查询商品2的详细信息
$sql = "SELECT * FROM products WHERE id = $product2_id";
$result = $conn->query($sql);
$row2 = $result->fetch_assoc();

// 显示商品对比信息
echo "<h2>商品对比：</h2>";
echo "<div>";
echo "<h3>" . $row1["name"] . " vs " . $row2["name"] . "</h3>";
echo "<p>价格对比：" . $row1["price"] . " vs " . $row2["price"] . "</p>";
echo "<p>尺寸对比：" . $row1["size"] . " vs " . $row2["size"] . "</p>";
echo "<p>重量对比：" . $row1["weight"] . " vs " . $row2["weight"] . "</p>";
// ... 其他属性的对比
echo "</div>";

$conn->close();