How to use PHP and Vue to develop the validity period setting of membership points after payment

How to use PHP and Vue to develop the validity period setting of membership points after payment

1. Introduction
The validity period setting of membership points is very important for merchants. After payment, merchants often give users certain points, but these points are not permanently valid and need to be set for a validity period according to certain rules. This article will introduce the specific steps and code examples of using PHP and Vue to develop the validity period setting of membership points after payment.

2. Technical Architecture
In this example, we will use PHP as the back-end development language, Vue as the front-end development framework, and MySQL as the database to store data. The advantage of this architecture is that PHP has powerful back-end processing capabilities, Vue has efficient front-end component development capabilities, and MySQL can store and manage data very well.

3. Database design
In this example, we need to design a database table to store member points information. This table contains at least the following fields:

1. user_id: user ID, used to distinguish different users;
2. points: the number of points;
3. expire_date: the validity period of the points .

4. Back-end development

1. First, we need to create a PHP file to handle the back-end logic. You can name it points.php.
2. In points.php, we need to accept the user ID and number of points passed by the front end, and calculate the validity period of the points.

<?php
// 连接数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);

// 判断连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 接收前端传递过来的参数
$user_id = $_POST['user_id'];
$points = $_POST['points'];

// 计算积分的有效期
$now = date('Y-m-d');
$expire_date = date('Y-m-d', strtotime($now . ' + 30 days')); // 假设积分有效期为30天

// 将数据插入数据库
$sql = "INSERT INTO points (user_id, points, expire_date) VALUES ('$user_id', '$points', '$expire_date')";

if ($conn->query($sql) === TRUE) {
    echo "积分设置成功";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

5. Front-end development

1. Create a Vue component to receive input from the user ID and number of points, and send requests to the backend.

<template>
  <div>
    <input type="text" v-model="user_id" placeholder="请输入用户ID" />
    <input type="text" v-model="points" placeholder="请输入积分数量" />
    <button @click="setPoints">设置积分</button>
  </div>
</template>

<script>
export default {
  data() {
    return {
      user_id: "",
      points: ""
    };
  },
  methods: {
    setPoints() {
      axios
        .post("points.php", {
          user_id: this.user_id,
          points: this.points
        })
        .then(function(response) {
          console.log(response.data);
        })
        .catch(function(error) {
          console.log(error);
        });
    }
  }
};
</script>

2. You need to install axios dependencies and import axios in main.js.

import Vue from "vue";
import App from "./App.vue";
import axios from "axios";

Vue.prototype.$http = axios;

new Vue({
  render: h => h(App)
}).$mount("#app");

6. Summary
By using PHP and Vue to develop the validity period setting of membership points after payment, we can implement a simple and practical function. This article introduces the steps and code examples of the entire development process, hoping to be helpful to readers. Of course, this is just a simple example. In actual projects, more functions and security issues may need to be considered, and they need to be expanded and optimized according to actual needs.

The above is the detailed content of How to use PHP and Vue to develop the validity period setting of membership points after payment. For more information, please follow other related articles on the PHP Chinese website!