如何使用PHP实现微信小程序的报名系统？

CREATE TABLE sign_up (
    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(30) NOT NULL,
    phone VARCHAR(11) NOT NULL,
    email VARCHAR(50) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

<?php
// 获取POST请求参数
$name = $_POST['name'];
$phone = $_POST['phone'];
$email = $_POST['email'];

// 连接数据库
$servername = 'localhost';
$username = 'root';
$passWord = 'password';
$dbname = 'your_database_name';

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}

// 插入数据
$sql = "INSERT INTO sign_up (name, phone, email) VALUES ('$name', '$phone', '$email')";
if ($conn->query($sql) === TRUE) {
    echo "报名成功";
} else {
    echo "报名失败: " . $conn->error;
}

$conn->close();
?>

wx.request({
  url: 'Http://your_domain.com/submit.php',
  method: 'POST',
  data: {
    name: '张三',
    phone: '13812345678',
    email: 'zhangsan@example.com'
  },
  success: function(res) {
    console.log(res.data); // 打印服务器返回的结果
  }
})