时间:2021-07-01 10:21:17 帮助过:16人阅读
DATE: ".date('Y-n-j H:i:s')."
ERROR: ".$info."
SQL: ".$sql."
}
"; } public function close(){ self::$DB =null; } public function __destruct() { self::close(); } } /*---class end*/ function makedir($dirpath){ if(!$dirpath) return 0; $dirpath=str_replace("\\","/",$dirpath); $mdir=""; foreach(explode("/",$dirpath) as $val){ $mdir.=$val."/"; if($val==".."||$val==".")continue; if(!is_dir($mdir)&&!file_exists($mdir)){ if(!@mkdir($mdir,0755)){ exit("创建目录 [".$mdir."]失败."); } } } return true; } function delDirAndFile($dirName){ if($handle=opendir($dirName)){ while(false!==($item = readdir($handle))){ if($item !="."&&$item!=".."){ if(is_dir( "$dirName/$item")){ delDirAndFile( "$dirName/$item"); }else{ unlink("$dirName/$item"); } } } closedir( $handle ); if( rmdir( $dirName ) )echo "成功删除目录: $dirName
\n"; } } function filein($filename="databak/",$table='',$mysql=''){ $fp = fopen($filename.'/'.$table.'.sql','w'); fputs($fp,$mysql); fclose($fp); } header("Content-Type:text/html;charset=utf-8"); $db=new dbmysql(); $table=$db->getTablesName(); $filename="databak/".date("Ymd"); $url=getcwd()."/databak/"; $handle = opendir($url); while(false!==($file = readdir($handle))){ if ($file!="."&&$file!=".."&&is_dir($url."/".$file)) { if(date("Ymd")-$file>5){delDirAndFile($url."/".$file);}; } } makedir($filename); foreach($table as $t){ $s1=$db->fetch_array("show create table `$t`"); $mysql="/*Time:".date("Y-m-d H:i:s")." */\r\nDROP TABLE IF EXISTS `$t`;\r\n".$s1['Create Table'].";\r\n\r\n"; $a1=$db->fetch_assoc("select * from `$t`"); foreach ($a1 as $data){ $vals=array_values($data); $vals=array_map('addslashes',$vals); $vals=join("','",$vals); $vals="'".$vals."'"; $mysql.="INSERT INTO `$t` VALUES ($vals);\r\n"; } $mysql.="\r\n"; filein($filename,$t,$mysql); } echo "数据备份成功,生成备份文件 ".getcwd()."/".$filename."/
程序自动清理5天以前的备份"; ?>