PHP+MYSQL+AJAX实现每日签到功能-php教程-PHP中文網

首頁

後端開發

php教程

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

不言

May 17, 2018 pm 04:57 PM

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);

陳述

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

PHP依賴注入容器：快速啟動May 13, 2025 am 12:11 AM

aphpdepentioncontiveContainerIsatoolThatManagesClassDeptions，增強codemodocultion，可驗證性和Maintainability.itactsasaceCentralHubForeatingingIndections，因此reducingTightCightTightCoupOulplingIndeSingantInting。

PHP中的依賴注入與服務定位器May 13, 2025 am 12:10 AM

選擇DependencyInjection(DI)用於大型應用，ServiceLocator適合小型項目或原型。 1)DI通過構造函數注入依賴，提高代碼的測試性和模塊化。 2)ServiceLocator通過中心註冊獲取服務，方便但可能導致代碼耦合度增加。

PHP性能優化策略。May 13, 2025 am 12:06 AM

phpapplicationscanbeoptimizedForsPeedAndeffificeby：1）啟用cacheInphp.ini，2）使用preparedStatatementSwithPdoforDatabasequesies，3）3）替換loopswitharray_filtaray_filteraray_maparray_mapfordataprocrocessing，4）conformentnginxasaseproxy，5）

PHP電子郵件驗證：確保正確發送電子郵件May 13, 2025 am 12:06 AM

phpemailvalidation invoLvesthreesteps：1）格式化進行regulareXpressecthemailFormat; 2）dnsvalidationtoshethedomainhasavalidmxrecord; 3）

如何使PHP應用程序更快May 12, 2025 am 12:12 AM

tomakephpapplicationsfaster，關注台詞：1）useopcodeCachingLikeLikeLikeLikeLikePachetoStorePreciledScompiledScriptbyTecode.2）MinimimiedAtabaseSqueriSegrieSqueriSegeriSybysequeryCachingandeffeftExting.3）Leveragephp7 leveragephp7 leveragephp7 leveragephpphp7功能forbettercodeefficy.4）

PHP性能優化清單：立即提高速度May 12, 2025 am 12:07 AM

到ImprovephPapplicationspeed，關注台詞：1）啟用opcodeCachingwithapCutoredUcescriptexecutiontime.2）實現databasequerycachingingusingpdotominiminimizedatabasehits.3）usehttp/2tomultiplexrequlexrequestsandreduceconnection.4 limitesclection.4.4

PHP依賴注入：提高代碼可檢驗性May 12, 2025 am 12:03 AM

依赖注入（DI）通过显式传递依赖关系，显著提升了PHP代码的可测试性。1）DI解耦类与具体实现，使测试和维护更灵活。2）三种类型中，构造函数注入明确表达依赖，保持状态一致。3）使用DI容器管理复杂依赖，提升代码质量和开发效率。

PHP性能優化：數據庫查詢優化May 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

See all articles