每日签到的功能,供大家参考,具体内容如下
首次签到获得1个积分,第二次签到获得2个积分,第三次签到获得3个积分,以此类推但是签到必须每天连续积分才可以递增,如果有中断再次签到时获得积分仍然从1开始递增;
user: id,username,count,point,sign_time
sign.html
!DOCTYPE html> html lang="en"> head> meta charset="UTF-8"> title>sign/title> /head> body> center> input type="text" name="username"> button>签到/button>span id='span'>/span> div> table id="box" border="1">/table> /div> /center> /body> /html> script src="jquery.1.12.min.js">/script> script> $(function(){ $('button').click(function(){ var username=$(':text').val(); $.ajax({ type:'post', url:'admin.php', data:{username:username}, dataType:'json', success:function(res){ if(res.success==1){ $('#span').html('签到成功'); var str='tr>td>用户名/td>td>连续签到天数/td>td>总积分/td>/tr>'; str+='tr>td>'+res.msg.username+'/td>td>'+res.msg.count+'/td>td>'+res.msg.point+'/td>/tr>'; $('#box').html(str); } } }) }); }) /script>
admin.php
?php header('content-type:text/html;charset=utf-8'); $pdo=new PDO('mysql:host=localhost;dbname=databasename;','root','root'); $pdo->exec('set names utf8'); $username=$_POST['username']; $sqlQuery="select * from user where username='$username'"; $row=$pdo->query($sqlQuery)->fetch(PDO::FETCH_ASSOC); if($row){ $sign_time=$row['sign_time']; $sign_time=strtotime($sign_time); $int=date('Y-m-d'); $int=strtotime($int);//5 $ints=$int+86400; //6 $int_s=$int-86400; //4 //当天已签到 if($int$sign_time$sign_time$ints){ // echo '您已签到'; } //昨天未签到,积分,天数在签到修改为1 if($sign_time$int_s){ $count=1; $point=1; $sign_time=date('Y-m-d H:s:i'); $sqlRow="update user set count='$count',point='$point',sign_time='$sign_time' where username='$username'"; $res=$pdo->exec($sqlRow); // echo '签到成功修改为1'; } //请签到 if($int_s$sign_time$sign_time$int){ $count=$row['count']+1; $point=$row['point']+1; $sign_time=date('Y-m-d H:s:i'); $sqlupdate="update user set count='$count',point='$point',sign_time='$sign_time' where username='$username'"; $res=$pdo->exec($sqlupdate); // echo '签到成功+1'; } }else{ $count=1; $point=1; $sign_time=date('Y-m-d H:s:i'); $sqlAdd="insert into user values (null,'$username','$count','$point','$sign_time')"; $res=$pdo->exec($sqlAdd); // echo '恭喜你签到成功----1'; } //////////////////////响应 $sqlEnd="select * from user where username='$username'"; $info=$pdo->query($sqlEnd)->fetch(PDO::FETCH_ASSOC); echo json_encode(array('success'=>1,'msg'=>$info));die; ?>
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持脚本之家。