释放双眼，带上耳机，听听看~！
首先我在数据库里建了两张表,一个是用户的积分表,一个是签到状态表,分来用来记录用户的积分数和先到状态
在用户签到状态表中我们有一个字段,last_sign_time,即上一次签到时间,每次可以签到的时候把这个时间与当前时间进行比较 如果相差为0天,则说明今天已签到(这个签到是24小时内只能签到一次,即两次签到时间要相差24小时以上).如果等于一天则今日可以签到,如果2天及其以上则说明漏签了.
通过时间戳的判断,及时更新状态表,并且当可以签到的时候则对用户积分表进行操作,即更新用户积分.
具体代码如下:
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
2 2 $user_id=@$_REQUEST['user_id'];
3 3 //功能：计算两个时间戳之间相差的日时分秒
4 4 //$begin_time 开始时间戳
5 5 //$end_time 结束时间戳
6 6 function timediff($begin_time,$end_time)
7 7 {
8 8 if($begin_time < $end_time){
9 9 $starttime = $begin_time;
10 10 $endtime = $end_time;
11 11 }else{
12 12 $starttime = $end_time;
13 13 $endtime = $begin_time;
14 14 }
15 15
16 16 //计算天数
17 17 $timediff = $endtime-$starttime;
18 18 $days = intval($timediff/86400);
19 19 //计算小时数
20 20 $remain = $timediff%86400;
21 21 $hours = intval($remain/3600);
22 22 //计算分钟数
23 23 $remain = $remain%3600;
24 24 $mins = intval($remain/60);
25 25 //计算秒数
26 26 $secs = $remain%60;
27 27 $res = array("day" => $days,"hour" => $hours,"min" => $mins,"sec" => $secs);
28 28 return $res;
29 29 }
30 30
31 31
32 32 function upuserscore($current_total_day){
33 33 $user_id=@$_REQUEST['user_id'];
34 34 //读取数据库配置信息的ini文件
35 35 $ary=parse_ini_file('db.ini');
36 36 $db_login_name=base64_decode($ary['db_login_name']);
37 37 $db_login_password=base64_decode($ary['db_login_password']);
38 38 $db_host=base64_decode($ary['db_host']);
39 39 $db_name=base64_decode($ary['db_name']);
40 40 //链接数据库
41 41 $scorelink=mysqli_connect($db_host,$db_login_name,$db_login_password);
42 42
43 43 mysqli_select_db($scorelink,$db_name); //选择数据库
44 44
45 45 //检查积分表里是否有该用户 有的话则更新数据 没有的话则插入数据
46 46 $scoreq = "SELECT * FROM user_score WHERE user_id=$user_id"; //SQL插入语句
47 47 mysqli_query($scorelink,"SET NAMES utf8");
48 48
49 49 $rs = mysqli_query($scorelink,$scoreq); //获取数据集
50 50 if(!$rs){
51 51 exit(json_encode(array('status'=>"success",'code'=>"1",'error'=>mysqli_error($scorelink))));
52 52 }
53 53
54 54 if(mysqli_num_rows($rs)){//该用户有数据 则更新其积分信息
55 55 $total_score="";
56 56 while($row = mysqli_fetch_row($rs)) {
57 57 $total_score=$row[4];
58 58 }
59 59 $scoreusdateq = "UPDATE user_score SET user_total_score ='98' WHERE user_id=$user_id;"; //更新
60 60 mysqli_query($scorelink,"SET NAMES utf8");
61 61 $ustaters = mysqli_query($scorelink,$scoreusdateq); //获取数据集
62 62 if($ustaters ==1){
63 63 exit(json_encode(array('status'=>"success",'code'=>"100")));
64 64 mysqli_close($scorelink);//关闭连接
65 65 exit();
66 66 }else{
67 67 exit(json_encode(array('status'=>"success",'code'=>"1")));
68 68 mysqli_close($scorelink);//关闭连接
69 69 exit();
70 70 }
71 71 }else{//没有该用户数据 则插入其积分信息
72 72 $scoreinsertq = "insert into user_score (user_id,user_total_score)values($user_id,10)"; //SQL插入语句
73 73 mysqli_query($scorelink,"SET NAMES utf8");
74 74
75 75 $rs = mysqli_query($scorelink,$scoreinsertq); //获取数据集
76 76
77 77 if(!$rs){
78 78 exit(json_encode(array('status'=>"success",'code'=>"1",'error'=>mysqli_error($scorelink))));
79 79 }
80 80 if(strpos($q,"SELECT") === false){
81 81 exit(json_encode(array('status'=>"success",'code'=>"100")));
82 82 }
83 83
84 84 mysqli_close($scorelink);//关闭连接
85 85
86 86 }
87 87
88 88 }
89 89
90 90
91 91
92 92
93 93 //读取数据库配置信息的ini文件
94 94 $ary=parse_ini_file('db.ini');
95 95 $db_login_name=base64_decode($ary['db_login_name']);
96 96 $db_login_password=base64_decode($ary['db_login_password']);
97 97 $db_host=base64_decode($ary['db_host']);
98 98 $db_name=base64_decode($ary['db_name']);
99 99
100100 //链接数据库
101101 $link=mysqli_connect($db_host,$db_login_name,$db_login_password);
102102
103103 mysqli_select_db($link,$db_name); //选择数据库
104104
105105 //检查签到表里是否有该用户 有的话则更新数据 没有的话则插入数据
106106 $q = "SELECT * FROM user_signin WHERE user_id=$user_id"; //SQL插入语句
107107 mysqli_query($link,"SET NAMES utf8");
108108
109109 $rs = mysqli_query($link,$q); //获取数据集
110110 if(!$rs){
111111 exit(json_encode(array('status'=>"success",'code'=>"1",'error'=>mysqli_error($link))));
112112 }
113113
114114 if(mysqli_num_rows($rs)){//该用户有数据 则更新其签到信息
115115 $last_time="";
116116 $total_day="";
117117 while($row = mysqli_fetch_row($rs)) {
118118 $last_time=$row[4]."<br/>";
119119 $total_day=$row[5];
120120 }
121121 //根据上次签到时间和这次签到时间作比较判断有没有漏签和今日是否已签到
122122 $current_total_day=intval($total_day)+1;
123123 $current_day=time();
124124 $ary = timediff($last_time,$current_day);
125125 if($ary[day]==0){//今天已签到
126126 exit(json_encode(array('status'=>"success",'code'=>"5")));
127127 mysqli_close($link);//关闭连接
128128 exit();
129129 }else if($ary[day]==1){//没有漏签
130130 $usdateq = "UPDATE user_signin SET last_sign_time='$current_day', total_day='$current_total_day' WHERE user_id=$user_id;"; //更新
131131 mysqli_query($link,"SET NAMES utf8");
132132 $ustaters = mysqli_query($link,$usdateq); //获取数据集
133133 if($ustaters ==1){
134134 upuserscore($current_total_day);
135135 //exit(json_encode(array('status'=>"success",'code'=>"100")));
136136 mysqli_close($link);//关闭连接
137137 exit();
138138 }else{
139139 exit(json_encode(array('status'=>"success",'code'=>"1")));
140140 mysqli_close($link);//关闭连接
141141 exit();
142142 }
143143 }else{//漏签过
144144 $usdateq = "UPDATE user_signin SET last_sign_time='$current_day', total_day=1 WHERE user_id=$user_id;"; //更新
145145 mysqli_query($link,"SET NAMES utf8");
146146 $ustaters = mysqli_query($link,$usdateq); //获取数据集
147147 if($ustaters ==1){
148148 upuserscore($current_total_day);
149149 //exit(json_encode(array('status'=>"success",'code'=>"100")));
150150 mysqli_close($link);//关闭连接
151151 exit();
152152 }else{
153153 exit(json_encode(array('status'=>"success",'code'=>"1")));
154154 mysqli_close($link);//关闭连接
155155 exit();
156156 }
157157 }
158158
159159 }else{//没有该用户记录则插入
160160 $current_day=time();
161161 $insertq = "insert into user_signin (user_id,last_sign_time,total_day)values($user_id,'$current_day',1)"; //SQL插入语句
162162
163163 mysqli_query($link,"SET NAMES utf8");
164164 $insertrs = mysqli_query($link,$insertq); //获取数据集
165165
166166 if(strpos($insertrs,"SELECT") === false){//出入数据成功
167167 upuserscore('1');
168168 //exit(json_encode(array('status'=>"success",'code'=>"100")));
169169
170170 }
171171
172172 }
173173
174174 mysqli_close($link);//关闭连接
175175
176176
177177 ?>
178
