当前位置：首页 > PHP

PHP签到实现

2026-03-12 21:04:19PHP

PHP签到功能实现方法

数据库设计

创建签到记录表，包含用户ID、签到日期等字段

CREATE TABLE `sign_in` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `sign_date` date NOT NULL,
  `sign_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_date` (`user_id`,`sign_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

签到逻辑处理

检查用户今日是否已签到，未签到则插入记录

function doSignIn($userId) {
    $today = date('Y-m-d');
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');

    // 检查今日是否已签到
    $stmt = $pdo->prepare("SELECT id FROM sign_in WHERE user_id = ? AND sign_date = ?");
    $stmt->execute([$userId, $today]);

    if($stmt->fetch()) {
        return ['status' => 0, 'msg' => '今日已签到'];
    }

    // 执行签到
    $stmt = $pdo->prepare("INSERT INTO sign_in (user_id, sign_date) VALUES (?, ?)");
    $stmt->execute([$userId, $today]);

    return ['status' => 1, 'msg' => '签到成功'];
}

连续签到统计

计算用户连续签到天数

function getContinuousDays($userId) {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
    $stmt = $pdo->prepare("
        SELECT sign_date FROM sign_in 
        WHERE user_id = ? 
        ORDER BY sign_date DESC
    ");
    $stmt->execute([$userId]);

    $continuousDays = 0;
    $currentDate = date('Y-m-d');

    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        if($row['sign_date'] == $currentDate) {
            $continuousDays++;
            $currentDate = date('Y-m-d', strtotime($currentDate . ' -1 day'));
        } else {
            break;
        }
    }

    return $continuousDays;
}

签到奖励机制

根据连续签到天数给予不同奖励

function giveSignInReward($userId, $continuousDays) {
    $rewards = [
        1 => ['points' => 10],
        3 => ['points' => 30],
        7 => ['points' => 100],
        30 => ['points' => 500]
    ];

    if(isset($rewards[$continuousDays])) {
        $reward = $rewards[$continuousDays];
        // 发放积分奖励逻辑
        return $reward;
    }

    return null;
}

前端交互示例

简单的AJAX签到请求处理

PHP签到实现

$('#signInBtn').click(function() {
    $.post('/sign_in.php', {action: 'sign_in'}, function(res) {
        if(res.status == 1) {
            alert('签到成功！连续签到' + res.continuous_days + '天');
        } else {
            alert(res.msg);
        }
    }, 'json');
});