php mysql ajax实现每日签到,PHP+MYSQL+AJAX实现每日签到功能

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

网站上支持每日签到以及签到送礼等互动功能，不仅有利于提高网站用户的活跃度，也有利于促进用户的粘合度和互动性。下面分析下使用PHP配合MYSQL、AJAX来制作了一个简单的每日签到功能。

一、web前端及ajax部分

文件index.html

PHP+AJAX+MYSQL实现每日签到

//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!");

}

});

}

签到连续签到天

二、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中文网