php数据库备份还原函数_PHP教程
php教程数据库教程备份还原函数
文章提供一款备份还原函数这是利用php写的可以备份也可以还原的函数，同时也支持备份后保存到本地的代码哦，好了下面看源码。
*/
//备份还原函数
function write_file($sql,$filename) {
$re=true;
if(fopen("./www.bKjia.c0m/".$filename,"w">!@$fp=fopen("./www.bKjia.c0m/".$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."`;n";
$db->query("show create table ".$table);
$db->nextrecord();
$tmp=preg_replace("/n/","",$db->f("create table"));
$sql.=$tmp.";n";
return $sql;
}function make_record($table,$num_fields){
global $db;
$comma="";
$sql .= "insert into ".$table." values(";
for($i = 0; $i {$sql .= ($comma."'".mysql教程_escape_string($db->record[$i])."'"); $comma = ",";}
$sql .= ");n";
return $sql;
}function show_msg($msgs){
$i=0;
$tm1="";
提示信息： ";
while (list($k,$v)=each($msgs)){
$i=$i+1;
$t1="- $i.".$v."
";
$t=$t.$t1;
}
$tm2="
return $tm1.$t.$tm2;
}function pageend(){
exit();
}function import($fname) {
global $db;
$sqls=file($fname);
foreach($sqls as $sql){
str_replace("r","",$sql);
str_replace("n","",$sql);
if(!$db->query(trim($sql))) return false;
}
return true;
}
?>