How to develop a simple coupon function using PHP

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

With the development of e-commerce, coupons have become an important means of attracting users. In this article, we will introduce how to develop a simple coupon function using PHP and provide specific code examples.

1. Design database

First, we need to design a database to store coupon information. We can create a table named "coupons" with the following structure:

CREATE TABLE coupons (
id int(11) NOT NULL AUTO_INCREMENT,
code varchar(50) NOT NULL,
discount decimal(5,2) NOT NULL,
expiry_date datetime NOT NULL,
is_used tinyint(1) NOT NULL DEFAULT '0',
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id ),
KEY code (code)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

In this table, we store coupons ID, discount code, discount amount, expiration date, whether it has been used, creation time and other information.

2. Generate coupons

Next, we need to write a function to generate coupons. The following is an example function that generates coupons:

function generateCoupon($discount, $expiryDate) {
$code = generateCouponCode(); // Generate discount code
$expiryDate = date( "Y-m-d H:i:s", strtotime($expiryDate)); // Convert expiration date format

$conn = mysqli_connect("localhost", "username", "password", "database"); //Connect to the database

//Insert coupons into the database
$sql = "INSERT INTO coupons (code, discount, expiry_date)

      VALUES ('$code', '$discount', '$expiryDate')";

mysqli_query($conn, $sql);

mysqli_close($conn); // Close the database connection

return $code;
}

In this function, we generate a random discount code, Insert the discount amount and expiration date into the database and return the generated discount code.

3. Verify the coupon

Now, we need to write a function to verify whether the coupon is valid. The following Is an example function that validates coupons:

function validateCoupon($code) {
$conn = mysqli_connect("localhost", "username", "password", "database"); // Connect to the database

//Query whether the coupon code exists in the database and is unused, and the expiration date is greater than the current date
$sql = "SELECT * FROM coupons

      WHERE code = '$code' AND is_used = 0 AND expiry_date > NOW()";

$result = mysqli_query ($conn, $sql);

$isValid = false;

if (mysqli_num_rows($result) > 0) {

$isValid = true;

// 更新优惠券为已使用
$row = mysqli_fetch_assoc($result);
$couponId = $row['id'];
$updateSql = "UPDATE coupons SET is_used = 1 WHERE id = '$couponId'";
mysqli_query($conn, $updateSql);

}

mysqli_close($conn); //Close the database connection

return $isValid;
}

In this function, we query whether the discount code exists in the database and is not used. And the expiration date is greater than the current date. If the conditions are met, we mark the coupon as used and return the verification results.

4. Use coupons

Finally, we need to write a function to use coupons. Here is an example function that uses coupons:

function useCoupon($code, $totalAmount) {
if (validateCoupon($code)) {

$conn = mysqli_connect("localhost", "username", "password", "database"); // 连接数据库

// 根据优惠码查询优惠券折扣金额
$sql = "SELECT discount FROM coupons WHERE code = '$code'";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$discount = $row['discount'];

$finalAmount = $totalAmount - $discount; // 计算最终金额

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

return $finalAmount;

} else {

return $totalAmount;

}
}

In this function, we first call the coupon verification function to determine whether the coupon is valid. If it is valid, we query the discount amount of the coupon based on the discount code, then calculate the final amount and return it.

Summary

In this article, we introduced how to develop a simple coupon function using PHP. By designing the database, generating coupons, validating coupons and using coupons, we can implement a basic coupon function. Of course, more situations need to be considered in practical applications, such as coupon validity limits, user usage restrictions, etc. I hope this article helps you develop a coupon feature!

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