WeChat 미니 프로그램에서 PHP로 개발된 평가 및 댓글 구현 방법

<view class="rate">
  <view class="title">服务评分：</view>
  <view class="stars">
    <view wx:for="{{[1,2,3,4,5]}}" wx:key="{{index}}" class="star" 
          data-score="{{index+1}}" bindtap="onStarClick">
      <image src="{{index<score ? '/images/star_on.png' : '/images/star_off.png'}}"></image>
    </view>
  </view>
  <view wx:if="{{score>0}}" class="submit" bindtap="onSubmitClick">提交评分</view>
</view>

Page({
  data: {
    score: 0,
  },
  onStarClick: function(e) {
    var score = e.currentTarget.dataset.score;
    this.setData({
      score: score,
    });
  },
  onSubmitClick: function(e) {
    wx.request({
      url: 'https://www.example.com/rate.php',
      data: {
        score: this.data.score,
      },
      method: 'POST',
      success: function(res) {
        wx.showToast({
          title: '评分成功',
          icon: 'success',
        });
      },
      fail: function(res) {
        wx.showToast({
          title: '评分失败',
          icon: 'none',
        });
      },
    });
  },
});

<?php

$score = $_POST['score'];

if (!empty($score)) {
  $conn = mysqli_connect('localhost', 'user', 'password', 'database');
  mysqli_query($conn, "INSERT INTO ratings (score) VALUES ('$score')");
}

?>

<view class="comment">
  <textarea placeholder="写下你的评价" bindinput="onInput"></textarea>
  <view wx:if="{{content!=''}}" class="submit" bindtap="onSubmitClick">提交评价</view>
</view>

Page({
  data: {
    content: '',
  },
  onInput: function(e) {
    var content = e.detail.value;
    this.setData({
      content: content,
    });
  },
  onSubmitClick: function(e) {
    wx.request({
      url: 'https://www.example.com/comment.php',
      data: {
        content: this.data.content,
      },
      method: 'POST',
      success: function(res) {
        wx.showToast({
          title: '评论成功',
          icon: 'success',
        });
      },
      fail: function(res) {
        wx.showToast({
          title: '评论失败',
          icon: 'none',
        });
      },
    });
  },
});

<?php

$content = $_POST['content'];

if (!empty($content)) {
  $content = htmlspecialchars($content); // 过滤HTML标签
  $content = addslashes($content); // 转义特殊字符
  $conn = mysqli_connect('localhost', 'user', 'password', 'database');
  $now = date('Y-m-d H:i:s'); // 获取当前时间
  mysqli_query($conn, "INSERT INTO comments (content,time) VALUES ('$content','$now')");
}

?>