How to develop an online shopping website using PHP and CGI

How to use PHP and CGI to develop an online shopping website

With the continuous development of the Internet, e-commerce has become an indispensable part of daily life. The development of online shopping websites has become one of the important tasks for many businesses and individuals. This article will introduce how to use PHP and CGI to develop a simple and powerful online shopping website. Below we will explain it step by step, with code examples.

1. Environment setup

First, make sure you have installed the PHP and CGI operating environments. You can use an integrated development environment such as XAMPP or WAMP, or you can configure it yourself on a Linux or Unix server. Please make sure your environment contains the required PHP and CGI modules.

2. Database design and connection establishment

Before developing the shopping website, we need to design the database structure and establish a connection with the database. In this example, we design a simple table that contains fields such as product ID, product name, product description, price, and inventory. The following is an example MySQL SQL statement to create a table:

CREATE TABLE products (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
description TEXT,
price DECIMAL(10, 2) NOT NULL,
stock INT NOT NULL
);

Then, we need to use PHP code to establish a connection to the database. The following is a sample code to connect to a MySQL database:

$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "mydb";

// Create database connection
$conn = new mysqli($servername, $username, $password, $dbname);

/ / Check whether the connection is successful
if ($conn->connect_error) {

die("连接失败: " . $conn->connect_error);

}
?>

3. Product list display

Next, we need to display the product list on the website. You can use the hybrid technology of HTML and PHP to dynamically generate product lists based on database data. The following is a simple sample code:

//Query the database to obtain product list data
$sql = "SELECT * FROM products";
$result = $conn ->query($sql);

if ($result->num_rows > 0) {

// 输出商品列表
while($row = $result->fetch_assoc()) {
    echo "<h2 id="row-name">".$row["name"]."</h2>";
    echo "<p>".$row["description"]."</p>";
    echo "<p>价格： $".$row["price"]."</p>";
    echo "<p>库存： ".$row["stock"]."件</p>";
    echo "<hr>";
}

} else {

echo "暂无商品";

}
? >

4. Add items to shopping cart

Users can add items to their shopping cart by clicking the "Add to Shopping Cart" button on the item page. We can use PHP Session to store shopping cart data. The following is a sample code:

session_start();

// Add items to the shopping cart
function addToCart($productId, $quantity) {

// 如果购物车不存在则创建购物车数组
if (!isset($_SESSION["cart"])) {
    $_SESSION["cart"] = array();
}

// 如果商品已经存在则增加数量
if (isset($_SESSION["cart"][$productId])) {
    $_SESSION["cart"][$productId] += $quantity;
} else {
    $_SESSION["cart"][$productId] = $quantity;
}

}

// Handle the request to add to the shopping cart
if ($_SERVER["REQUEST_METHOD"] == "POST") {

$productId = $_POST["productId"];
$quantity = $_POST["quantity"];

addToCart($productId, $quantity);

}
?>

5. Shopping cart page

On the shopping cart page, we display the items that the user has added to the shopping cart and provide the ability to modify the quantity or delete them. Product options. The following is a sample code:

if (isset($_SESSION["cart"]) && count($_SESSION["cart"]) > 0) {

foreach ($_SESSION["cart"] as $productId => $quantity) {
    // 根据商品ID从数据库中查询商品数据
    $sql = "SELECT * FROM products WHERE id = $productId";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        echo "<h2 id="row-name">".$row["name"]."</h2>";
        echo "<p>数量： ".$quantity."</p>";
        echo "<p>价格： $".$row["price"]."</p>";
        echo "<hr>";
    }
}

} else {

echo "购物车是空的";

}
?>

The above are the basic steps and sample codes for developing online shopping websites using PHP and CGI. Of course, a complete shopping website also includes user registration, login, payment and other functions, but this is beyond the scope of this article. I hope the content of this article can help you better understand how to use PHP and CGI to develop online shopping websites.

The above is the detailed content of How to develop an online shopping website using PHP and CGI. For more information, please follow other related articles on the PHP Chinese website!