php 批量导入昨天的数据(别类版的增量备份安案)

最新推荐文章于 2025-09-08 20:15:10 发布

weixin_33895516

最新推荐文章于 2025-09-08 20:15:10 发布

阅读量76

点赞数

文章标签： php

本文介绍了一种游戏登录日志的同步方法，包括从远程数据库查询登录记录，并按日期和ID进行分页处理，最终将数据插入到本地数据库中。

$where = '';
            $localogLogin = $this->gamedb_model->query_onerow("select `datetime` from logLogin order by id desc");
            $posdatetime =     $localogLogin['datetime'];
            if(empty()){
                $where = "where datetime<'$todaydate'";
            }else{
                $where = "where datetime<'$todaydate' and datetime>'$posdatetime'";
            }
            $remountlist = $this->remotedb_model->query_onerow("select count(*) as num from logLogin $where");
            $allcount = $remountlist['num'];
            if($allcount){
                $page = 1;//当前页
                $pagesize=1000;//分页大小
                $failt = 0;// 失败次数
                $allpage =ceil($allcount/$pagesize);//分页总大小
                while($page <= $allpage){
                        $sqltmp = 'insert  into `loglogin`(`accid`,`roleID`,`macAddr`,`ip`,`datetime`,`online`) values';
                        //一天一天的算
                        $templogdate = $this->remotedb_model->query_lists("select * from logLogin $where order by datetime asc limit ".($page-1)*$pagesize.",$pagesize");
                        foreach ($templogdate as $k => $val) {
                                $tempdate = substr($val['datetime'],0,strpos($val['datetime']," "));
                                if($k == (count($templogdate)-1)){
                                    $sqltmp .="($val[accid],$val[roleID],'$val[macAddr]','$val[ip]','$val[datetime]',$tempdate)";
                                }else{
                                    $sqltmp .="($val[accid],$val[roleID],'$val[macAddr]','$val[ip]','$val[datetime]',$tempdate),";
                                }
                        }
                        $this->gamedb_model->query($sqltmp);
                        $sqltmp = '';
                        $page++;
                    }
            }

$localogLogin = $this->gamedb_model->query_onerow("select id from logLogin order by id desc");
            $maxid = empty($localogLogin['id'])?'0':$localogLogin['id'];
            $remountlist = $this->remotedb_model->query_onerow("select count(*) as num from logLogin where id>$maxid");                
            $allcount = $remountlist['num'];
            if($allcount){
                $page = 1;//当前页
                $pagesize=1000;//分页大小
                $failt = 0;// 失败次数
                $allpage =ceil($allcount/$pagesize);//分页总大小
                while($page <= $allpage){
                        $sqltmp = 'insert  into `loglogin`(`accid`,`roleID`,`macAddr`,`ip`,`datetime`,`online`) values';
                        //一天一天的算
                        $templogdate = $this->remotedb_model->query_lists("select * from logLogin where id>$maxid order by id asc limit ".($page-1)*$pagesize.",$pagesize");
                        foreach ($templogdate as $k => $val) {
                            
                                $tempdate = substr($val['datetime'],0,strpos($val['datetime']," "));
                                
                                if($k == (count($templogdate)-1)){
                                    $sqltmp .="($val[accid],$val[roleID],'$val[macAddr]','$val[ip]','$val[datetime]',$tempdate)";
                                }else{
                                    $sqltmp .="($val[accid],$val[roleID],'$val[macAddr]','$val[ip]','$val[datetime]',$tempdate),";
                                }
                        }

                        $this->gamedb_model->query($sqltmp);
                        $sqltmp = '';
                        $page++;
                    }
            }