php数据库备份还原函数
发布:smiling 来源: PHP粉丝网 添加日期:2014-09-11 20:24:53 浏览: 评论:0
文章提供一款备份还原函数这是利用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;
- }
Tags: php数据库备份 php数据还原
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)