實例講解Thinkphp連續簽到獲取積分的開發思路

CREATE TABLE IF NOT EXISTS `mall_sign` ( 
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT, 
  `uid` int(11) NOT NULL, 
  `points` int(6) NOT NULL COMMENT '签到积分', 
  `num` int(8) NOT NULL DEFAULT '0' COMMENT '连续签到次数', 
  `addtime` int(10) NOT NULL COMMENT '签到时间', 
  PRIMARY KEY (`id`) 
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; 
 
-- 
-- 转存表中的数据 `mall_sign` 
-- 
 
INSERT INTO `mall_sign` (`id`, `uid`, `points`, `num`, `addtime`) VALUES 
(1, 1, 6, 1, 1502985600), 
(2, 1, 6, 2, 1503072000), 
(3, 1, 6, 3, 1503158400);