How to use PHP to implement weekly check-in function

1. Foreword

With the popularity of the Internet, more and more websites and apps have begun to build check-in systems for users to attract and retain users. The sign-in system is a lightweight and highly interactive marketing method. Users can obtain free rights through sign-in, and guide users to form habitual operations every day, every week, etc., thereby achieving the purpose of brand promotion. As one of many languages, PHP can naturally implement this check-in function. This article will introduce how to use PHP to implement the weekly check-in function.

2. Requirements Analysis

Before implementing weekly check-in, we first need to conduct a detailed analysis of the requirements.

1. Users can register an account and log in to the system;
2. Users can sign in on the sign-in page;
3. Users can only sign in once in a week;
4. After the user successfully signs in, he can obtain the corresponding point reward;
5. The sign-in page can display the number of days the user has signed in and the current points that can be obtained.

3. Implementation steps

According to the above requirements, we can divide it into the following steps for implementation.

1. Database Design

Create a table to store the user's check-in status, including user ID, number of consecutive check-in days, last check-in time and other fields. The specific table creation statements are as follows:

CREATE TABLE `user_sign` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `con_day` int(11) NOT NULL DEFAULT '0' COMMENT '连续签到天数',
  `last_time` date NOT NULL DEFAULT '0000-00-00' COMMENT '上次签到时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户签到信息表';

2. Registration and Login

Users can register their account through the registration page and then log in to the system. For convenience, we can use Session to manage the user's login status. When logging in, the user's ID is stored in the Session, and the user ID will be obtained through the Session during subsequent sign-in operations.

3. Sign-in and Rewards

On the sign-in page, the user will perform the sign-in operation by clicking the sign-in button. When checking in, you need to first determine whether the user's last check-in time was within a week. If so, the check-in fails; if not, the number of consecutive check-in days of the user is calculated and points are awarded. The specific implementation code is as follows:

// 获取当前用户ID
$user_id = $_SESSION['user_id'];

// 查询用户签到信息
$sql = "SELECT con_day,last_time FROM user_sign WHERE user_id='$user_id'";
$res = mysqli_query($link, $sql);
$info = mysqli_fetch_assoc($res);
$last_time = $info['last_time'];
$con_day = $info['con_day'];

// 判断用户上次签到时间是否在一周内，若是则签到失败
if ((time()-strtotime($last_time)) < 86400*7) {
    echo "今天已经签过到啦~";
} else {
    // 新增签到记录
    $sql = "INSERT INTO user_sign (user_id,con_day,last_time) VALUES ('$user_id','".($con_day+1)."','".date('Y-m-d')."')";
    mysqli_query($link, $sql);

    // 奖励积分
    $reward = 5 + ($con_day+1)*2;
    echo "签到成功，获得".$reward."积分！";
}

4. Sign-in days and points display

After each sign-in is successful, it is necessary to query the user's consecutive sign-in days and the number of points that can be obtained. The function code is as follows:

// 获取当前用户ID
$user_id = $_SESSION['user_id'];

// 查询用户签到信息
$sql = "SELECT con_day,last_time FROM user_sign WHERE user_id='$user_id'";
$res = mysqli_query($link, $sql);
$info = mysqli_fetch_assoc($res);
$last_time = $info['last_time'];
$con_day = $info['con_day'];

// 计算应得积分
$reward = 5 + $con_day*2;

// 输出签到天数和奖励积分
echo "你已经签到".$con_day."天，可获得".$reward."积分！";

4. Summary

It is not difficult to implement the weekly check-in function in PHP. The main difficulty lies in clarifying the check-in process and determining the user's check-in time. By establishing appropriate data structures and writing clear business logic, these problems can be effectively solved. I hope this article will be helpful to readers in need.

The above is the detailed content of How to use PHP to implement weekly check-in function. For more information, please follow other related articles on the PHP Chinese website!