Mall product display function developed using PHP
Mall product display function developed using PHP
With the rapid development of e-commerce, developing a powerful shopping mall has become an urgent need for various enterprises. In the mall system, the product display function is a crucial part, which can directly affect the user's understanding of the product and desire to purchase. This article will introduce how to use PHP to develop a simple but powerful mall product display function.
First, we need to prepare a product table, which contains basic information such as product ID, name, price, and description. Assuming we have created a table called "products", we can use the following code example to insert some test data.
// 连接数据库
$conn = new mysqli("localhost", "root", "password", "mydb");
if ($conn->connect_error) {
die("数据库连接失败: " . $conn->connect_error);
}
// 插入商品数据
$sql = "INSERT INTO products (name, price, description) VALUES ('iPhone 12', 6999, '苹果最新款手机')";
$conn->query($sql);
$sql = "INSERT INTO products (name, price, description) VALUES ('华为Mate 40', 5999, '华为旗舰机型')";
$conn->query($sql);
$sql = "INSERT INTO products (name, price, description) VALUES ('小米10', 3999, '小米旗舰手机')";
$conn->query($sql);
// 关闭数据库连接
$conn->close();Next, we need to display the product list on the web page. We can achieve this with the help of HTML, CSS and PHP. Here is a simple example.
<!DOCTYPE html>
<html>
<head>
<title>商品列表</title>
<style>
/* CSS 样式 */
.product {
margin-bottom: 20px;
}
.name {
font-weight: bold;
}
.price {
color: red;
}
.description {
margin-top: 10px;
}
</style>
</head>
<body>
<h1>商品列表</h1>
<?php
// 连接数据库
$conn = new mysqli("localhost", "root", "password", "mydb");
if ($conn->connect_error) {
die("数据库连接失败: " . $conn->connect_error);
}
// 查询商品数据
$sql = "SELECT * FROM products";
$result = $conn->query($sql);
// 遍历结果并输出商品列表
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo '<div class="product">';
echo '<div class="name">' . $row["name"] . '</div>';
echo '<div class="price">价格：￥' . $row["price"] . '</div>';
echo '<div class="description">' . $row["description"] . '</div>';
echo '</div>';
}
} else {
echo "暂无商品";
}
// 关闭数据库连接
$conn->close();
?>
</body>
</html>With the above code, we created a simple product list page. The product information on the page is read from the database and displayed through PHP. Users can see the name, price and description of the product on the page.
When we run this page, the product list in the database will be displayed on the page. If there is no product data in the database, "No Products" will be displayed.
The above is a simple but powerful development example of the mall product display function. Based on actual needs, you can also extend the code, such as adding product images, category display, etc. I hope the examples in this article can help you develop a complete mall product display function.
The above is the detailed content of Mall product display function developed using PHP. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1655
14
1413
52
1306
25
1252
29
1226
24
How to use Memcache in PHP development?
Nov 07, 2023 pm 12:49 PM
In web development, we often need to use caching technology to improve website performance and response speed. Memcache is a popular caching technology that can cache any data type and supports high concurrency and high availability. This article will introduce how to use Memcache in PHP development and provide specific code examples. 1. Install Memcache To use Memcache, we first need to install the Memcache extension on the server. In CentOS operating system, you can use the following command
How to design the mall's coupon table structure in MySQL?
Oct 31, 2023 am 11:12 AM
How to design the mall's coupon table structure in MySQL? With the rapid development of e-commerce, coupons have become one of the important marketing methods to attract users. In a shopping mall system, it is very important to properly design the structure of the coupon table. This article will introduce how to design the coupon table structure of the mall in MySQL and provide specific code examples. Basic attributes of mall coupons First, we need to clarify the basic attributes of mall coupons. Generally speaking, a coupon includes the following attributes: Coupon ID: Each coupon should have a
Describe the SOLID principles and how they apply to PHP development.
Apr 03, 2025 am 12:04 AM
The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.
How to implement version control and code collaboration in PHP development?
Nov 02, 2023 pm 01:35 PM
How to implement version control and code collaboration in PHP development? With the rapid development of the Internet and the software industry, version control and code collaboration in software development have become increasingly important. Whether you are an independent developer or a team developing, you need an effective version control system to manage code changes and collaborate. In PHP development, there are several commonly used version control systems to choose from, such as Git and SVN. This article will introduce how to use these tools for version control and code collaboration in PHP development. The first step is to choose the one that suits you
How to use PHP to develop the coupon function of the ordering system?
Nov 01, 2023 pm 04:41 PM
How to use PHP to develop the coupon function of the ordering system? With the rapid development of modern society, people's life pace is getting faster and faster, and more and more people choose to eat out. The emergence of the ordering system has greatly improved the efficiency and convenience of customers' ordering. As a marketing tool to attract customers, the coupon function is also widely used in various ordering systems. So how to use PHP to develop the coupon function of the ordering system? 1. Database design First, we need to design a database to store coupon-related data. It is recommended to create two tables: one
How to use Memcache for efficient data writing and querying in PHP development?
Nov 07, 2023 pm 01:36 PM
How to use Memcache for efficient data writing and querying in PHP development? With the continuous development of Internet applications, the requirements for system performance are getting higher and higher. In PHP development, in order to improve system performance and response speed, we often use various caching technologies. One of the commonly used caching technologies is Memcache. Memcache is a high-performance distributed memory object caching system that can be used to cache database query results, page fragments, session data, etc. By storing data in memory
How to use caching to improve system performance in PHP development?
Nov 04, 2023 pm 01:39 PM
How to use caching to improve system performance in PHP development? In today's era of rapid Internet development, system performance has become a crucial indicator. For PHP development, caching is an important means to improve system performance. This article will explore how to use caching in PHP development to improve system performance. 1. Why use caching to improve system performance: Caching can reduce frequent access to resources such as databases, thereby reducing system response time and improving system performance and throughput. Reduce server load: By using caching, you can reduce
How to use PHP to develop the member points function of the grocery shopping system?
Nov 01, 2023 am 10:30 AM
How to use PHP to develop the member points function of the grocery shopping system? With the rise of e-commerce, more and more people choose to purchase daily necessities online, including grocery shopping. The grocery shopping system has become the first choice for many people, and one of its important features is the membership points system. The membership points system can attract users and increase their loyalty, while also providing users with an additional shopping experience. In this article, we will discuss how to use PHP to develop the membership points function of the grocery shopping system. First, we need to create a membership table to store users
