如何使用PHP实现微信小程序的闹钟功能？

CREATE TABLE `alarm` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) NOT NULL,
  `time` INT(11) NOT NULL,
  `is_enabled` TINYINT(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

<?php

// 连接数据库
$dsn = 'Mysql:host=localhost;dbname=your_database_name';
$username = 'your_username';
$passWord = 'your_password';

try {
    $pdo = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    die('Connection failed: ' . $e->getMessage());
}

// 设置字符集
$pdo->exec('SET NAMES utf8');

// 处理添加闹钟请求
if ($_GET['action'] == 'add') {
    $user_id = $_GET['user_id'];
    $time = $_GET['time'];
    
    $stmt = $pdo->prepare('INSERT INTO alarm (user_id, time) VALUES (?, ?)');
    $stmt->execute([$user_id, $time]);
    
    echo JSON_encode(['result' => 'success']);
    exit;
}

// 处理获取闹钟请求
if ($_GET['action'] == 'get') {
    $user_id = $_GET['user_id'];
    
    $stmt = $pdo->prepare('SELECT * FROM alarm WHERE user_id = ?');
    $stmt->execute([$user_id]);
    
    $alarms = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    echo json_encode($alarms);
    exit;
}

// 处理删除闹钟请求
if ($_GET['action'] == 'delete') {
    $id = $_GET['id'];
    
    $stmt = $pdo->prepare('DELETE FROM alarm WHERE id = ?');
    $stmt->execute([$id]);
    
    echo json_encode(['result' => 'success']);
    exit;
}

?>

// 发送添加闹钟请求
function addAlarm(user_id, time) {
  wx.request({
    url: 'Http://your_domain.com/alarm.php?action=add',
    data: {
      user_id: user_id,
      time: time
    },
    success: function(res) {
      console.log(res.data);
    }
  });
}

// 发送获取闹钟请求
function getAlarms(user_id) {
  wx.request({
    url: 'http://your_domain.com/alarm.php?action=get',
    data: {
      user_id: user_id
    },
    success: function(res) {
      console.log(res.data);
    }
  });
}

// 发送删除闹钟请求
function deleteAlarm(id) {
  wx.request({
    url: 'http://your_domain.com/alarm.php?action=delete',
    data: {
      id: id
    },
    success: function(res) {
      console.log(res.data);
    }
  });
}

// 页面加载时发送获取闹钟请求
onLoad: function(options) {
  var user_id = options.user_id;
  getAlarms(user_id);
},

// 监听定时器
setInterval(function() {
  var currentTime = new Date().getTime() / 1000;
  var alarms = this.data.alarms;
  var that = this;

  for (var i = 0; i < alarms.length; i++) {
    if (alarms[i].is_enabled && alarms[i].time <= currentTime) {
      wx.showModal({
        title: '闹钟',
        content: '时间到了！',
        success: function(res) {
          if (res.confirm) {
            deleteAlarm(alarms[i].id);
            getAlarms(that.data.user_id);
          }
        }
      });
      break;
    }
  }
}, 1000);