How to use PHP developer city function: Create product details page-PHP Tutorial-php.cn

How to use PHP developer city function: Create product details page

WBOY

Release： 2023-07-30 13:46:01

Original

1624 people have browsed it

How to use PHP developer mall function: Create product details page

With the rapid development of e-commerce, developing a fully functional mall website has become a need for many developers. As one of the most important pages in a shopping mall website, the product details page needs to display detailed information about the product to attract users' attention and prompt them to purchase. This article will introduce how to use the product details page in the PHP developer city function and provide code examples.

Step 1: Create a database table

First, we need to create a database table to store product details. Suppose our database is named "myshop" and the table is named "products". The table contains the following fields: id (product ID), name (product name), price (product price), description (product description). The table can be created using the following SQL statement:

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

Copy after login

Step 2: Create an HTML template for the product details page

Before creating the product details page, we first create an HTML template as a basis. The following is a simple product details page HTML template example:

<!DOCTYPE html>
<html>
<head>
    <title>产品详情</title>
</head>
<body>
    <h1>产品详情</h1>
    <div>
        <h2 id="product-name"></h2>
        <p id="product-price"></p>
        <p id="product-description"></p>
    </div>
</body>
</html>

Copy after login

Step 3: Write PHP code to obtain product information

Next, we need to write PHP code to obtain product information in the database , and insert it into the HTML template. The following is a simple PHP code example:

<?php
    // 建立与数据库的连接
    $conn = mysqli_connect("localhost", "username", "password", "myshop");
    if (!$conn) {
        die("连接数据库失败: " . mysqli_connect_error());
    }

    // 获取产品ID
    $productId = $_GET["id"];

    // 查询产品信息
    $sql = "SELECT * FROM products WHERE id = $productId";
    $result = mysqli_query($conn, $sql);
    $product = mysqli_fetch_assoc($result);

    // 关闭数据库连接
    mysqli_close($conn);
?>

<!-- 在HTML模板中插入产品信息 -->
<script>
    window.onload = function() {
        document.getElementById("product-name").innerHTML = "<?php echo $product['name']; ?>";
        document.getElementById("product-price").innerHTML = "价格: <?php echo $product['price']; ?>";
        document.getElementById("product-description").innerHTML = "<?php echo $product['description']; ?>";
    };
</script>

Copy after login

In the above code, we first establish a connection to the database and then obtain the product ID (usually passed through URL parameters). Next, execute the query statement to obtain product information and store the results in the $product variable. Finally, close the database connection. In the HTML template, we use PHP's echo statement to dynamically insert product information into the corresponding HTML element.

Step 4: Test the product details page

After completing the above steps, we can access the product details page through the following URL:

http://yourdomain.com/product.php?id=1

Copy after login

Among them, id=1 represents the product ID. By modifying the value of the id parameter, we can view the details of different products.

Summary:

Through the above steps, we successfully created a PHP-based product details page. In actual development, we can expand this page according to needs, such as adding product pictures, user reviews and other functions. I hope this article will help you understand how to use the product details page of the PHP Developer City function. Remember, continuous learning and practice are the best ways to improve your development skills. Happy development!

The above is the detailed content of How to use PHP developer city function: Create product details page. For more information, please follow other related articles on the PHP Chinese website!