PHP+MYSQL+AJAX实现每日签到

在现在的好多网站上都出现了每日签到以及签到送等互动功能，这边呢，作者就使用最原始的PHP配合MYSQL、AJAX来制作了一个简单的每日签到功能，至于送还有其他的小游戏就需要读者们自己去增加和拓展了。 下面先看下文件目录： database： 顾名思义就是存放数据 在现在的好多网站上都出现了每日签到以及签到送礼等互动功能，这边呢，作者就使用最原始的PHP配合MYSQL、AJAX来制作了一个简单的每日签到功能，至于送礼还有其他的小游戏就需要读者们自己去增加和拓展了。下面先看下文件目录：database：顾名思义就是存放数据库SQL语句的文件，里面存放了已经设计好的简单的几张表。js：存放JS脚本库。index.php用的是.PHP为后缀的，其实下面看到后，读者可能会说，里面没PHP代码，直接弄成.HTML的后缀好了，其实大家可以自己去修改的，作者就不更改了。index.php code:登录后复制sign.php 该文件就是具体处理签到的PHP代码了，具体的code如下： 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` {$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` {$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.}}?>登录后复制数据库：测试数据库结构及具体内容如下-- phpMyAdmin SQL Dump-- version 3.4.8-- http://www.phpmyadmin.net---- Host: localhost-- Generation Time: Jan 07, 2014 at 01:32 PM-- Server version: 5.5.28-- PHP Version: 5.2.17p1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;---- Database: `sign`---- ------------------------------------------------------------ Table structure for table `sign`--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;---- Dumping data for table `sign`--INSERT INTO `sign` (`uid`, `dateline`) VALUES(1, '1389072071'),(2, '1389072735');-- ------------------------------------------------------------ Table structure for table `user`--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 ;---- Dumping data for table `user`--INSERT INTO `user` (`id`, `username`, `signdays`) VALUES(1, 'ggbound', 4),(2, 'other', 1);/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;登录后复制到此一个每日签到的功能就基本完成了！