PHP+MYSQL+AJAX实现每日签到功能
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了PHP+MYSQL+AJAX实现每日签到功能,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3630字,纯文字阅读大概需要6分钟。
内容图文
![PHP+MYSQL+AJAX实现每日签到功能](/upload/InfoBanner/zyjiaocheng/207/2f9fa1d2b02446168d71d37645b81273.jpg)
网站上支持每日签到以及签到送礼等互动功能,不仅有利于提高网站用户的活跃度,也有利于促进用户的粘合度和互动性。下面分析下使用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实现每日签到功能全部内容,希望文章能够帮你解决PHP+MYSQL+AJAX实现每日签到功能所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。