文章目录[隐藏]
PHP+MYSQL+AJAX实现每日签到功能
网站上支持每日签到以及签到送礼等互动功能，不仅有利于提高网站用户的活跃度，也有利于促进用户的粘合度和互动性。下面分析下使用PHP配合MYSQL、AJAX来制作了一个简单的每日签到功能。
一、web前端及ajax部分
文件index.html
<html> <head> <meta http-equiv=Content-Type content="text/html;charset=utf-8"><title>PHP+AJAX+MYSQL实现每日签到</title><script type="text/javascript" src="js/jquery.min.js"></script><script type="text/javascript">//page load get num$(window).ready(function(){ doGetDays(); });//get sign daysfunction doGetDays<a style="color:transparent">本@文来源gao($daima.com搞@代@#码(网5</a><strong>搞gaodaima代码</strong>(){ $.get("/sign.php?do=getDay",{},function(data){ $("#days").html(data); }); }//do signfunction doSign(){ $.get("/sign.php?do=sign",{},function(data){ if(data==1){ alert("sign success!"); window.location.href='/'; }else if(data==2){ alert("already sign today! next tomorrow!"); } }); }</script></head> <body><a style="cursor:pointer;" onclick="doSign();">签到<span>连续签到<span id="days"></span>天</span></a></body> </html>
二、PHP后端处理部分
sign.php文件
<?phpif ($_GET['do']=='getDay'){$db=new mysqli('localhost','root','123456','sign');$uid=2; $getDay="SELECT `signdays` FROM `user` WHERE `id`= {$uid}"; $day=$db -> query($getDay); $days =$day -> fetch_array(MYSQLI_ASSOC); echo $days['signdays']; }if ($_GET['do']=='sign'){$db=new mysqli('localhost','root','123456','sign');$uid=2;$time=time();//check sign today$todayBegin=strtotime(date('Y-m-d')." 00:00:00");$todayEnd= strtotime(date('Y-m-d')." 23:59:59");$checkSignSql="SELECT * FROM `sign` WHERE `uid` = {$uid} AND `dateline` < {$todayEnd} AND `dateline` > {$todayBegin} ";$checkSignToday= $db -> query($checkSignSql);$checkSign = $checkSignToday -> fetch_array(MYSQLI_ASSOC);if (empty($checkSign)){$sql="SELECT * FROM `sign` WHERE `uid` = {$uid} ";$return = $db -> query($sql) -> fetch_array(MYSQL_ASSOC);//check sign table exist uid recordif (empty($return)){//no$insertSql="INSERT INTO `sign` (`uid`,`dateline`) VALUES ('{$uid}','{$time}') ";$insert = $db -> query($insertSql);$updateSignSql="UPDATE `user` SET `signdays` =1 WHERE `id` = {$uid} ";$db -> query($updateSignSql); echo 1; }else{ // check is continuous ? reset with login set signdays as 0 !!!!!$yesterdayBegin= strtotime(date("Y-m-d",strtotime("-1 day"))." 00:00:00");$yesterdayEnd= strtotime(date("Y-m-d",strtotime("-1 day"))." 23:59:59");$checkContinuSql="SELECT * FROM `sign` WHERE `uid` = {$uid} AND `dateline` < {$yesterdayEnd} AND `dateline` > {$yesterdayBegin}"; $checkContinuYesterday = $db ->query($checkContinuSql) -> fetch_array(MYSQL_ASSOC); if (!empty($checkContinuYesterday)){ $replaceSql="REPLACE INTO `sign` (`uid`,`dateline`) VALUES ('{$uid}','{$time}') "; $replace=$db -> query($replaceSql);$updateSignSql="UPDATE `user` SET `signdays` = `signdays` + 1 WHERE `id` = {$uid} ";$db -> query($updateSignSql); echo 1; }else{ } } }else{ echo 2;// allready sign. } }?>
三、Mysql数据库部分
CREATE TABLE IF NOT EXISTS `sign` ( `uid` int(11) NOT NULL, `dateline` varchar(10) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;INSERT INTO `sign` (`uid`, `dateline`) VALUES (1, '1389072071'), (2, '1389072735');CREATE TABLE IF NOT EXISTS `user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'USERID', `username` varchar(35) COLLATE utf8_bin NOT NULL COMMENT 'username', `signdays` int(11) NOT NULL COMMENT '签到天数', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3 ;INSERT INTO `user` (`id`, `username`, `signdays`) VALUES (1, 'ggbound', 4), (2, 'other', 1);
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：PHP+MYSQL+AJAX实现每日签到功能
转载请注明原文链接：PHP+MYSQL+AJAX实现每日签到功能
