程式師世界 >> 編程語言 >> 網頁編程 >> PHP編程 >> PHP綜合 >> PHP+MYSQL+AJAX實現每日簽到功能

PHP+MYSQL+AJAX實現每日簽到功能

編輯：PHP綜合

網站上支持每日簽到以及簽到送禮等互動功能，不僅有利於提高網站用戶的活躍度，也有利於促進用戶的粘合度和互動性。下面分析下使用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  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);