Home > Article > Backend Development > How to implement a simple online mall using PHP
How to implement a simple online mall using PHP
- 王林Original
- 2023-09-25 14:25:021549browse
How to use PHP to implement a simple online mall
With the development of the Internet, e-commerce has become a common way of shopping. Many people want to learn how to build their own online store. This article will introduce how to use PHP language to implement a simple online mall and give specific code examples.
1. Build the environment
First, we need to build a PHP development environment locally. It is recommended to use XAMPP or WAMP tools to build an integrated development environment, which can avoid tedious configuration work.
2. Create a database
Next, we need to create a database and create the required tables in the database. In MySQL, you can use the following code to create a database named "shop" and create a "products" table:
CREATE DATABASE shop; USE shop; CREATE TABLE products ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, price DECIMAL(8, 2) NOT NULL, description VARCHAR(255) NOT NULL );
3. Write the code
- First, create a database named "shop" The file "index.php" serves as the homepage of the mall.
<?php
// 导入数据库配置
require_once 'config.php';
// 查询所有商品
$sql = "SELECT * FROM products";
$result = mysqli_query($conn, $sql);
?>
<html>
<head>
<title>在线商城</title>
</head>
<body>
<h1>在线商城</h1>
<?php while($row = mysqli_fetch_assoc($result)): ?>
<div>
<h2><?= $row['name']; ?></h2>
<p><?= $row['description']; ?></p>
<p>价格: $<?= $row['price']; ?></p>
<a href="buy.php?id=<?= $row['id']; ?>">购买</a>
</div>
<?php endwhile; ?>
</body>
</html>In the above example, we first imported the database configuration file "config.php", then used MySQL's "SELECT" statement to query all products, and used a "while" loop to products are displayed on the page.
- Create a file named "buy.php" to handle the logic for users to purchase goods.
<?php
// 导入数据库配置
require_once 'config.php';
$id = $_GET['id']; // 获取商品ID
// 查询商品信息
$sql = "SELECT * FROM products WHERE id = $id";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
// 处理购买逻辑
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$quantity = $_POST['quantity'];
$totalPrice = $row['price'] * $quantity;
// 执行购买操作，此处省略详细代码
echo "购买成功!";
exit;
}
?>
<html>
<head>
<title>购买商品</title>
</head>
<body>
<h1>购买商品</h1>
<div>
<h2><?= $row['name']; ?></h2>
<p><?= $row['description']; ?></p>
<p>价格: $<?= $row['price']; ?></p>
<form method="POST" action="">
<input type="number" name="quantity" placeholder="请输入购买数量" required>
<button type="submit">购买</button>
</form>
</div>
</body>
</html>In the above example, we first imported the database configuration file "config.php", and then queried the product information based on the product ID passed by the user and displayed it on the page. When the user clicks the purchase button, we obtain the purchase quantity entered by the user through the POST method, calculate the total price, and perform the corresponding purchase operation. Here we only briefly display the prompt information for a successful purchase. The actual purchase process needs to be processed in detail based on your needs.
4. Summary
Through the above sample code, we have learned how to use PHP language to implement a simple online mall. Of course, the above example is just a basic implementation. In practice, more functions need to be processed, such as user login, shopping cart, order management, etc. I hope this article can provide some reference for beginners to help them better learn and understand PHP development.
The above is the detailed content of How to implement a simple online mall using PHP. For more information, please follow other related articles on the PHP Chinese website!