How to use PHP to develop a simple product comparison function

How to use PHP to develop a simple product comparison function requires specific code examples

With the development of e-commerce, users often encounter the problem of selecting products when shopping. Troubles, such as not knowing which brand of product to choose is better, which store has more affordable prices, etc. In order to solve this problem, we can develop a simple product comparison function to help users easily compare the attributes of products and make choices. This article will introduce how to use PHP to implement this function and give specific code examples.

First, we need to create a product comparison page where users can select the products that need to be compared. At the top of the page, we can place a search box so that users can quickly find the products that need to be compared based on the product name. The following is a code example for creating a search box:

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

When the user clicks the search button, the page will jump to compare.php and pass the search keywords through the GET method. We can receive this keyword in compare.php and then query the matching product information from the database. The following is a code example for receiving and processing search keywords:

$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();

Users can click on the product image or name to select the product to be compared. When the user selects two products, we can jump to a new page to display the detailed information of the two products and compare them. On the comparison page, we can display various attributes such as product name, price, size, weight, etc. The following is a code example that displays comparative information:

$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();

The above is just an example of a simple product comparison function. You can extend and optimize these codes according to your own needs. I hope this article can be helpful to you, and I wish you successful development!

The above is the detailed content of How to use PHP to develop a simple product comparison function. For more information, please follow other related articles on the PHP Chinese website!