小程序开发中的PHP数据分析与用户画像生成

// 在页面中发送数据
wx.request({
  url: 'http://your-domain.com/collect',
  data: {
    action: 'clickButton',
    page: 'homepage',
    button: 'loginButton'
  },
  success: (res) => {
    console.log(res.data)
  }
})

// 在后台接收数据
$action = $_POST['action'];
$page = $_POST['page'];
$button = $_POST['button'];

// 存储到数据库
$conn = new mysqli("localhost", "username", "password", "database");
$sql = "INSERT INTO user_actions (action, page, button) VALUES ('$action', '$page', '$button')";
$conn->query($sql);
$conn->close();

// 数据分析
$conn = new mysqli("localhost", "username", "password", "database");
$sql = "SELECT COUNT(*) as count FROM user_actions WHERE action = 'clickButton' AND page = 'homepage'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();

$count = $row['count'];

$conn->close();

// 返回结果给小程序前端
echo json_encode(array('clickButtonCount' => $count));

// 数据提取
$conn = new mysqli("localhost", "username", "password", "database");
$sql = "SELECT * FROM user_actions LEFT JOIN user_info ON user_actions.user_id = user_info.id";
$result = $conn->query($sql);

$data = array();
while ($row = $result->fetch_assoc()) {
  $data[] = $row;
}

$conn->close();

// 用户画像生成
$interests = array();
foreach ($data as $row) {
  $interest = $row['interest'];
  if (!in_array($interest, $interests)) {
    $interests[] = $interest;
  }
}

// 返回结果给小程序前端
echo json_encode(array('interests' => $interests));