利用PHP开发的二手回收网站支持短信订阅功能

CREATE TABLE `subscribers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

<form action="subscribe.php" method="post">
  <input type="text" name="name" placeholder="姓名" required>
  <input type="tel" name="phone" placeholder="手机号码" required>
  <input type="email" name="email" placeholder="电子邮箱" required>
  <button type="submit">订阅</button>
</form>

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

// 处理订阅请求
$name = $_POST["name"];
$phone = $_POST["phone"];
$email = $_POST["email"];

$sql = "INSERT INTO subscribers (name, phone, email)
        VALUES ('$name', '$phone', '$email')";

if ($conn->query($sql) === TRUE) {
    // 发送短信通知
    $message = "尊敬的用户，您已成功订阅我们的二手回收网站。感谢您的支持！";
    // 调用短信发送接口，示例代码略

    echo "订阅成功！";
} else {
    echo "订阅失败：" . $conn->error;
}

$conn->close();
?>