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 days function doGetDays(){
  $.get("/sign.php?do=getDay",{},function(data){
    $("#days").html(data);
  });
} //do sign function 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文件

<?php 

if ($_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 record     if (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);  

PHP+MYSQL+AJAX实现每日签到功能

上一篇:原生AJAX封装


下一篇:js清除单选框所选的值