PHP与Vue开发：如何实现会员积分的分享奖励机制

CREATE TABLE members (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  points INT(6) NOT NULL
);

CREATE TABLE rewards (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  member_id INT(6) UNSIGNED,
  points INT(6) NOT NULL,
  share_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (member_id) REFERENCES members(id)
);

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

// 检查连接是否成功
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

// 获取会员ID和分享积分数
$member_id = $_POST['member_id'];
$share_points = $_POST['share_points'];

// 更新会员的积分
$sql = "UPDATE members SET points = points + $share_points WHERE id = $member_id";
mysqli_query($conn, $sql);

// 记录分享奖励
$sql = "INSERT INTO rewards (member_id, points) VALUES ($member_id, $share_points)";
mysqli_query($conn, $sql);

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

<template>
  <div>
    <h1>会员积分</h1>
    <p>当前积分：{{ points }}</p>
    <button @click="sharePoints">分享</button>
  </div>
</template>

<script>
import axios from 'axios';

export default {
  data() {
    return {
      points: 0
    };
  },
  mounted() {
    this.getPoints();
  },
  methods: {
    getPoints() {
      axios
        .get('getPoints.php')
        .then((response) => {
          this.points = response.data.points;
        })
        .catch((error) => {
          console.log(error);
        });
    },
    sharePoints() {
      axios
        .post('sharePoints.php', { member_id: 1, share_points: 10 })
        .then(() => {
          this.getPoints();
        })
        .catch((error) => {
          console.log(error);
        });
    }
  }
};
</script>