如何编写PHP实现连续签到功能的长尾关键词？

2026-04-01 08:151阅读0评论SEO教程

内容介绍
文章标签
相关推荐

本文共计949个文字，预计阅读时间需要4分钟。

本文将简单介绍PHP连接数据库功能的实现方法。以下是一段示例代码：

phprequire .\global.php;$act=isset($_GET['act']) ? $_GET['act'] : error;// 检查$act变量switch($act) { case qiandao: $uid=intval($_POST['uid']); // 执行签到操作 break;}

本文实例讲述了PHP连续签到功能实现方法。分享给大家供大家参考，具体如下：

require "./global.php"; $act = isset($_GET['act']) ? $_GET['act'] : "error"; // d($act); switch($act){ case "qiandao": $uid = intval($_POST['uid']); $res = $db -> get('qian_dao','*',array('uid'=>$uid)); // last_query(); $time = time(); //判断今天是否签到 $todayBegin=strtotime(date('Y-m-d')." 00:00:00"); $todayEnd= strtotime(date('Y-m-d')." 23:59:59"); $isexit = $db -> get('qian_dao','id',array('AND'=>array('uid'=>$uid,'qian_dao_time[>=]'=>$todayBegin,'qian_dao_time[<=]'=>$todayEnd))); // last_query(); if($isexit){ // echo "今天已签到！"; Log::writeLog(print_r(array('state'=>'stop','msg'=>'今天已签到！'),true)); echo json_encode(array('state'=>'stop','msg'=>'今天已签到！')); exit; } if($res){ //存在签到 if((time() - $res['qian_dao_time'] > 24*60*60)){ // 判断时间是否大于24小时 // 让字段归0 $addInfo = $db -> update('qian_dao',array('qian_dao_num'=>1,'qian_dao_time'=>$time),array('uid'=>$uid)); }else{ // 更新签到的天数 $addInfo = $db -> update('qian_dao',array('qian_dao_num[+]'=>1,'qian_dao_time'=>$time),array('uid'=>$uid)); } }else{ // echo '您还没有签到过'; //没有签到过 $db -> insert('qian_dao',array('uid'=>$uid,'qian_dao_num'=>1,'qian_dao_time'=>$time)); // echo $db ->last_query(); } // 插入签到记录 $db -> insert('sign',array( 'uid'=>$uid, 'dateline'=>$time, )); // 获取连续签到的天数 $info = $db -> get('qian_dao','qian_dao_num',array('uid'=>$uid)); echo json_encode(array('state'=>'success','msg'=>"您是第".$info."天签到")); break; default : echo json_encode(array("ret"=>0,"msg"=>"操作不存在！")); break; }

sql：

CREATE TABLE IF NOT EXISTS `qian_dao` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(1) NOT NULL COMMENT '用户id', `qian_dao_num` int(11) NOT NULL COMMENT '签到次数', `qian_dao_time` int(11) NOT NULL COMMENT '签到时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `sign` ( `uid` int(11) NOT NULL, `dateline` varchar(10) COLLATE utf8_bin NOT NULL, KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

html：

<?php include './global.php'; $uid = 1; $todayBegin=strtotime(date('Y-m-d')." 00:00:00"); $todayEnd= strtotime(date('Y-m-d')." 23:59:59"); $isexit = $db -> get('qian_dao','id',array('AND'=>array('uid'=>$uid,'qian_dao_time[>=]'=>$todayBegin,'qian_dao_time[<=]'=>$todayEnd))); $flag = ''; if($isexit){ $flag = 'current'; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="www.w3.org/1999/xhtml"> <head> <meta img.558idc.com/uploadfile/allimg/210510/14451J292-0.jpg"></script> <script type="text/javascript"> /*签到模块日期捕捉：*/ function week(){ var objDate= new Date(); var week = objDate.getDay(); switch(week) { case 0: week="周日"; break; case 1: week="周一"; break; case 2: week="周二"; break; case 3: week="周三"; break; case 4: week="周四"; break; case 5: week="周五"; break; case 6: week="周六"; break; } $("#sing_for_number").html( week ); } $(document).ready(function(){ week(); var cache=new Array(); // 缓存变量，当数据被访问过之后放置在缓存中，加快访问速度 $(".singer_r_img").click(function(){ // 如果缓存中存在数据，那么直接从缓存中读取；如果不存在数据，那么就从数据库中读取，并把数据存入缓存 if (typeof(cache['stop'])=='undefined') { $.ajax({ url:"action.php?act=qiandao", type:"post", dataType:'json', data:{ uid:1, }, async:false, success:function(data){ // alert(data.msg); switch(data.state){ case 'success': alert(data.msg); break case 'stop': cache['stop'] = data.msg; alert(data.msg); break; } $(".singer_r_img").addClass("current"); } }) }else{ alert(cache['stop']) } }) }) </script> </body> </html> <?php // 获取签到记录 $sign = $db -> select('sign','*',array('uid'=>$uid,'ORDER'=>'dateline DESC')); ?> <ul class='ul'> <?php if(empty($sign)){ ?> <li class="li">暂无签到信息</li> <?php }else{ foreach($sign as $k=>$v){ ?> <li class="li"><span><?php echo ($k + 1);?></span> <?php echo date('Y-m-d H:i:s',$v['dateline']);?></li> <?php } } ?> </ul>

更多关于PHP相关内容感兴趣的读者可查看本站专题：《php+mysql数据库操作入门教程》、《php+mysqli数据库程序设计技巧总结》、《php面向对象程序设计入门教程》、《PHP数组(Array)操作技巧大全》、《php字符串(string)用法总结》及《php常见数据库操作技巧汇总》

希望本文所述对大家PHP程序设计有所帮助。

标签：PHP 连续签到功能实现