Heim  >  Artikel  >  Backend-Entwicklung  >  PHP+MYSQL+AJAX实现每日签到功能

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

不言
不言Original
2018-05-17 16:57:454849Durchsuche

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 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=&#39;/&#39;; 
}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[&#39;do&#39;]==&#39;getDay&#39;){
$db=new mysqli(&#39;localhost&#39;,&#39;root&#39;,&#39;123456&#39;,&#39;sign&#39;);
$uid=2; $getDay="SELECT `signdays` FROM `user` WHERE `id`= {$uid}"; $day=$db -> query($getDay); $days =$day -> fetch_array(MYSQLI_ASSOC); echo $days[&#39;signdays&#39;]; 
}
if ($_GET[&#39;do&#39;]==&#39;sign&#39;){
$db=new mysqli(&#39;localhost&#39;,&#39;root&#39;,&#39;123456&#39;,&#39;sign&#39;);
$uid=2;
$time=time();
//check sign today
$todayBegin=strtotime(date(&#39;Y-m-d&#39;)." 00:00:00");
$todayEnd= strtotime(date(&#39;Y-m-d&#39;)." 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 (&#39;{$uid}&#39;,&#39;{$time}&#39;) ";
$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 (&#39;{$uid}&#39;,&#39;{$time}&#39;) ";            
$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, &#39;1389072071&#39;), (2, &#39;1389072735&#39;);
CREATE TABLE IF NOT EXISTS `user` ( 
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT &#39;USERID&#39;, 
`username` varchar(35) COLLATE utf8_bin NOT NULL COMMENT &#39;username&#39;, 
`signdays` int(11) NOT NULL COMMENT &#39;签到天数&#39;, PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3 ;
INSERT INTO `user` (`id`, `username`, `signdays`) VALUES (1, &#39;ggbound&#39;, 4), (2, &#39;other&#39;, 1);


Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn