本文實(shí)例講述了php實(shí)現(xiàn)簽到功能的方法。分享給大家供大家參考，具體如下：

首先我在數(shù)據(jù)庫里建了兩張表,一個(gè)是用戶的積分表,一個(gè)是簽到狀態(tài)表,分來用來記錄用戶的積分?jǐn)?shù)和先到狀態(tài)

在用戶簽到狀態(tài)表中我們有一個(gè)字段,last_sign_time,即上一次簽到時(shí)間,每次可以簽到的時(shí)候把這個(gè)時(shí)間與當(dāng)前時(shí)間進(jìn)行比較 如果相差為0天,則說明今天已簽到(這個(gè)簽到是24小時(shí)內(nèi)只能簽到一次,即兩次簽到時(shí)間要相差24小時(shí)以上).如果等于一天則今日可以簽到,如果2天及其以上則說明漏簽了.

通過時(shí)間戳的判斷,及時(shí)更新狀態(tài)表,并且當(dāng)可以簽到的時(shí)候則對用戶積分表進(jìn)行操作,即更新用戶積分.

具體代碼如下:

 ?php$user_id=@$_REQUEST[ user_id //功能：計(jì)算兩個(gè)時(shí)間戳之間相差的日時(shí)分秒//$begin_time 開始時(shí)間戳//$end_time 結(jié)束時(shí)間戳function timediff($begin_time,$end_time) if($begin_time $end_time){ $starttime = $begin_time; $endtime = $end_time; }else{ $starttime = $end_time; $endtime = $begin_time; //計(jì)算天數(shù) $timediff = $endtime-$starttime; $days = intval($timediff/86400); //計(jì)算小時(shí)數(shù) $remain = $timediff%86400; $hours = intval($remain/3600); //計(jì)算分鐘數(shù) $remain = $remain%3600; $mins = intval($remain/60); //計(jì)算秒數(shù) $secs = $remain%60; $res = array( day = $days, hour = $hours, min = $mins, sec = $secs); return $res;function upuserscore($html' target='_blank'>current_total_day){$user_id=@$_REQUEST[ user_id //讀取數(shù)據(jù)庫配置信息的ini文件 $ary=parse_ini_file( db.ini  $db_login_name=base64_decode($ary[ db_login_name  $db_login_password=base64_decode($ary[ db_login_password  $db_host=base64_decode($ary[ db_host  $db_name=base64_decode($ary[ db_name //鏈接數(shù)據(jù)庫 $scorelink=mysqli_connect($db_host,$db_login_name,$db_login_password);mysqli_select_db($scorelink,$db_name); //選擇數(shù)據(jù)庫//檢查積分表里是否有該用戶 有的話則更新數(shù)據(jù) 沒有的話則插入數(shù)據(jù)$scoreq = SELECT * FROM user_score WHERE user_id=$user_id //SQL插入語句 mysqli_query($scorelink, SET NAMES utf8  $rs = mysqli_query($scorelink,$scoreq); //獲取數(shù)據(jù)集 if(!$rs){ exit(json_encode(array( status = success , code = 1 , error = mysqli_error($scorelink)))); if(mysqli_num_rows($rs)){//該用戶有數(shù)據(jù) 則更新其積分信息 $total_score=  while($row = mysqli_fetch_row($rs)) { $total_score=$row[4]; $scoreusdateq = UPDATE user_score SET user_total_score = 98 WHERE user_id=$user_id; //更新 mysqli_query($scorelink, SET NAMES utf8  $ustaters = mysqli_query($scorelink,$scoreusdateq); //獲取數(shù)據(jù)集 if($ustaters ==1){ exit(json_encode(array( status = success , code = 100 ))); mysqli_close($scorelink);//關(guān)閉連接  exit(); }else{ exit(json_encode(array( status = success , code = 1 ))); mysqli_close($scorelink);//關(guān)閉連接 exit(); }else{//沒有該用戶數(shù)據(jù) 則插入其積分信息 $scoreinsertq = insert into user_score (user_id,user_total_score)values($user_id,10) //SQL插入語句 mysqli_query($scorelink, SET NAMES utf8  $rs = mysqli_query($scorelink,$scoreinsertq); //獲取數(shù)據(jù)集 if(!$rs){ exit(json_encode(array( status = success , code = 1 , error = mysqli_error($scorelink)))); if(strpos($q, SELECT ) === false){ exit(json_encode(array( status = success , code = 100 ))); mysqli_close($scorelink);//關(guān)閉連接//讀取數(shù)據(jù)庫配置信息的ini文件 $ary=parse_ini_file( db.ini  $db_login_name=base64_decode($ary[ db_login_name  $db_login_password=base64_decode($ary[ db_login_password  $db_host=base64_decode($ary[ db_host  $db_name=base64_decode($ary[ db_name //鏈接數(shù)據(jù)庫 $link=mysqli_connect($db_host,$db_login_name,$db_login_password);mysqli_select_db($link,$db_name); //選擇數(shù)據(jù)庫//檢查簽到表里是否有該用戶 有的話則更新數(shù)據(jù) 沒有的話則插入數(shù)據(jù)$q = SELECT * FROM user_signin WHERE user_id=$user_id //SQL插入語句 mysqli_query($link, SET NAMES utf8  $rs = mysqli_query($link,$q); //獲取數(shù)據(jù)集 if(!$rs){ exit(json_encode(array( status = success , code = 1 , error = mysqli_error($link)))); if(mysqli_num_rows($rs)){//該用戶有數(shù)據(jù) 則更新其簽到信息 $last_time=  $total_day=  while($row = mysqli_fetch_row($rs)) { $last_time=$row[4]. br/  $total_day=$row[5]; //根據(jù)上次簽到時(shí)間和這次簽到時(shí)間作比較判斷有沒有漏簽和今日是否已簽到 $current_total_day=intval($total_day)+1; $current_day=time(); $ary = timediff($last_time,$current_day); if($ary[day]==0){//今天已簽到 exit(json_encode(array( status = success , code = 5 ))); mysqli_close($link);//關(guān)閉連接  exit(); }else if($ary[day]==1){//沒有漏簽 $usdateq = UPDATE user_signin SET last_sign_time= $current_day , total_day= $current_total_day WHERE user_id=$user_id; //更新 mysqli_query($link, SET NAMES utf8  $ustaters = mysqli_query($link,$usdateq); //獲取數(shù)據(jù)集 if($ustaters ==1){ upuserscore($current_total_day); //exit(json_encode(array( status = success , code = 100 ))); mysqli_close($link);//關(guān)閉連接  exit(); }else{ exit(json_encode(array( status = success , code = 1 ))); mysqli_close($link);//關(guān)閉連接 exit(); }else{//漏簽過 $usdateq = UPDATE user_signin SET last_sign_time= $current_day , total_day=1 WHERE user_id=$user_id; //更新 mysqli_query($link, SET NAMES utf8  $ustaters = mysqli_query($link,$usdateq); //獲取數(shù)據(jù)集 if($ustaters ==1){ upuserscore($current_total_day); //exit(json_encode(array( status = success , code = 100 ))); mysqli_close($link);//關(guān)閉連接  exit(); }else{ exit(json_encode(array( status = success , code = 1 ))); mysqli_close($link);//關(guān)閉連接 exit(); }else{//沒有該用戶記錄則插入 $current_day=time(); $insertq = insert into user_signin (user_id,last_sign_time,total_day)values($user_id, $current_day ,1) //SQL插入語句 mysqli_query($link, SET NAMES utf8  $insertrs = mysqli_query($link,$insertq); //獲取數(shù)據(jù)集 if(strpos($insertrs, SELECT ) === false){//出入數(shù)據(jù)成功 upuserscore( 1  //exit(json_encode(array( status = success , code = 100 ))); mysqli_close($link);//關(guān)閉連接? 

linux下的php-fpm參數(shù)配置介紹與參數(shù)優(yōu)化說明詳解

Laravel中數(shù)據(jù)遷移與數(shù)據(jù)填充的詳細(xì)步驟詳解

PHP 閉包獲取外部變量和global關(guān)鍵字聲明變量的區(qū)別講解

以上就是php實(shí)現(xiàn)簽到功能的方法實(shí)例分析詳解的詳細(xì)內(nèi)容，PHP教程

鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請第一時(shí)間聯(lián)系我們修改或刪除，多謝。