php数据库备份还原函数
发布时间：2022-07-28 10:22:53 所属栏目：PHP教程 来源：互联网
导读：文章提供一款备份还原函数这是利用php写的可以备份也可以还原的函数,同时也支持备份后保存到本地的代码,好了下面看源码. //备份还原函数 function write_file($sql,$filename) { $re=true; if(!@$fp=fopen(./www.phpfensi.com/.$filename,w+)) {$re=false; e
|
文章提供一款备份还原函数这是利用php写的可以备份也可以还原的函数,同时也支持备份后保存到本地的代码,好了下面看源码. //备份还原函数 function write_file($sql,$filename) { $re=true; if(!@$fp=fopen("./www.phpfensi.com/".$filename,"w+")) {$re=false; echo "failed to open target file";} if(!@fwrite($fp,$sql)) {$re=false; echo "failed to write file";} if(!@fclose($fp)) {$re=false; echo "failed to close target file";} return $re; } function down_file($sql,$filename){ ob_end_clean(); header("content-encoding: none"); header("content-type: ".(strpos($_server['http_user_agent'], 'msie') ? 'application/octetstream' : 'application/octet-stream')); header("content-disposition: ".(strpos($_server['http_user_agent'], 'msie') ? 'inline; ' : 'attachment; ')."filename=".$filename); header("content-length: ".strlen($sql)); header("pragma: no-cache"); header("expires: 0"); echo $sql; $e=ob_get_contents(); ob_end_clean(); } function writeable($dir){ if(!is_dir($dir)) { @mkdir($dir, 0777); } if(is_dir($dir)){ if($fp = @fopen("$dir/test.test", 'w')){ @fclose($fp); @unlink("$dir/test.test"); $writeable = 1; }else { $writeable = 0; } } return $writeable; } function make_header($table){ global $db; $sql="drop table if exists `".$table."`; "; $db->query("show create table ".$table); $db->nextrecord(); $tmp=preg_replace("/ /","",$db->f("create table")); $sql.=$tmp."; "; return $sql; } function make_record($table,$num_fields){ global $db; $comma=""; $sql .= "insert into ".$table." values("; for($i = 0; $i < $num_fields; $i++) {$sql .= ($comma."'".mysql教程_escape_string($db->record[$i])."'"); $comma = ",";} $sql .= "); "; return $sql; } function show_msg($msgs){ $i=0; $tm1="<table width='100%' border='0' cellpadding='0' cellspacing='1'><tr><td><font color='red'><b>提示信息：</b></font></td></tr><tr><td><ul>"; while (list($k,$v)=each($msgs)){ $i=$i+1; $t1="<li>$i.".$v."</li>"; $t=$t.$t1; } $tm2="</ul></td></tr></table>"; return $tm1.$t.$tm2; } function pageend(){ exit(); } function import($fname) { global $db; $sqls=file($fname); foreach($sqls as $sql){ str_replace(" ","",$sql); str_replace(" ","",$sql); if(!$db->query(trim($sql))) return false; }//开源代码phpfensi.com return true; } （编辑：珠海站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
