如何使用PHP和Vue开发支付后会员积分的有效期设置

<?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();
?>

<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>

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");