php备份指定表,php数据备份：单表备份 整表备份 导入数据库

php数据备份的代码，包括单表备份、整表备份、导入数据库，有需要的朋友，不妨参考下了。

1、单表备份

复制代码 代码示例:

class Db

{

var $conn;

function Db($host="localhost",$user="root",$pass="root",$db="test")

{

if(!$this->conn=mysql_connect($host,$user,$pass))

die("can't connect to mysql sever");

mysql_select_db($db,$this->conn);

mysql_query("SET NAMES 'UTF-8'");

}

function execute($sql)

{

return mysql_query($sql,$this->conn);

}

function findCount($sql)

{

$result=$this->execute($sql);

return mysql_num_rows($result);

}

function findBySql($sql)

{

$array=array();

$result=mysql_query($sql);

$i=0;

while($row=mysql_fetch_assoc($result))

{

$array[$i]=$row;

$i++;

}

return $array;

}

//$con的几种情况

//空：返回全部记录

//array：eg. array('id'=>'1') 返回id=1的记录

//string :eg. 'id=1' 返回id=1的记录

function toExtJson($table,$start="0",$limit="10",$cons="")

{

$sql=$this->generateSql($table,$cons);

$totalNum=$this->findCount($sql);

$result=$this->findBySql($sql." LIMIT ".$start." ,".$limit);

$resultNum = count($result);//当前结果数

$str="";

$str.= "{";

$str.= "'totalCount':'$totalNum',";

$str.="'rows':";

$str.="[";

for($i=0;$i

$str.="{";

$count=count($result[$i]);

$j=1;

foreach($result[$i] as $key=>$val)

{

if($j

{

$str.="'".$key."':'".$val."',";

}

elseif($j==$count)

{

$str.="'".$key."':'".$val."'";

}

$j++;

}

$str.="}";

if ($i != $resultNum-1) {

$str.= ",";

}

}

$str.="]";

$str.="}";

return $str;

}

function generateSql($table,$cons)

{

$sql="";//sql条件

$sql="select * from ".$table;

if($cons!="")

{

if(is_array($cons))

{

$k=0;

foreach($cons as $key=>$val)

{

if($k==0)

{

$sql.="where '";

$sql.=$key;

$sql.="'='";

$sql.=$val."'";

}else

{

$sql.="and '";

$sql.=$key;

$sql.="'='";

$sql.=$val."'";

}

$k++;

}

}else

{

$sql.=" where ".$cons;

}

}

return $sql;

}

function toExtXml($table,$start="0",$limit="10",$cons="")

{

$sql=$this->generateSql($table,$cons);

$totalNum=$this->findCount($sql);

$result=$this->findBySql($sql." LIMIT ".$start." ,".$limit);

$resultNum = count($result);//当前结果数

header("Content-Type: text/xml");

$xml="<?xml version=\"1.0\"  encoding=\"utf-8\" ?>\n";

$xml.="\n";

$xml.="\t".$totalNum."\n";

$xml.="\t\n";

for($i=0;$i

$xml.="\t\t\n";

foreach($result[$i] as $key=>$val)

$xml.="\t\t\t".$val."".$key.">\n";

$xml.="\t\t\n";

}

$xml.="\t\n";

$xml.="\n";

return $xml;

}

//输出word表格

function toWord($table,$mapping,$fileName)

{

header('Content-type: application/doc');

header('Content-Disposition: attachment; filename="'.$fileName.'.doc"');

echo '

xmlns:w="urn:schemas-microsoft-com:office:word"

xmlns="[url=http://www.w3.org/TR/REC-html40]http://www.w3.org/TR/REC-html40[/url]">

'.$fileName.'

echo'

if(is_array($mapping))

{

foreach($mapping as $key=>$val)

echo'

'.$val.'';

}

echo'

';

$results=$this->findBySql('select * from '.$table);

foreach($results as $result)

{

echo'

';

foreach($result as $key=>$val)

echo'

'.$val.'';

echo'

';

}

echo'

';

echo'';

echo'';

}

function toExcel($table,$mapping,$fileName)

{

header("Content-type:application/vnd.ms-excel");

header("Content-Disposition:filename=".$fileName.".xls");

echo'

xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns="[url=http://www.w3.org/TR/REC-html40]http://www.w3.org/TR/REC-html40[/url]">

echo'

echo'

';

if(is_array($mapping))

{

foreach($mapping as $key=>$val)

echo'

'.$val.'';

}

echo'

';

$results=$this->findBySql('select * from '.$table);

foreach($results as $result)

{

echo'

';

foreach($result as $key=>$val)

echo'

'.$val.'';

echo'

';

}

echo'

';

echo'';

echo'';

}

function Backup($table)

{

if(is_array ($table))

{

$str="";

foreach($table as $tab)

$str.=$this->get_table_content($tab);

return $str;

}else{

return $this->get_table_content($table);

}

}

function Backuptofile($table,$file)

{

header("Content-disposition: filename=$file.sql");//所保存的文件名

header("Content-type: application/octetstream");

header("Pragma: no-cache");

header("Expires: 0");

if(is_array ($table))

{

$str="";

foreach($table as $tab)

$str.=$this->get_table_content($tab);

echo $str;

}else{

echo $this->get_table_content($table);

}

}

function Restore($table,$file="",$content="")

{

//排除file，content都为空或者都不为空的情况

if(($file==""&&$content=="")||($file!=""&&$content!=""))

echo"参数错误";

$this->truncate($table);

if($file!="")

{

if($this->RestoreFromFile($file))

return true;

else

return false;

}

if($content!="")

{

if($this->RestoreFromContent($content))

return true;

else

return false;

}

}

//清空表，以便恢复数据

function truncate($table)

{

if(is_array ($table))

{

$str="";

foreach($table as $tab)

$this->execute("TRUNCATE TABLE $tab");

}else{

$this->execute("TRUNCATE TABLE $table");

}

}

function get_table_content($table)

{

$results=$this->findBySql("select * from $table");

$temp = "";

$crlf="
";

foreach($results as $result)

{

/*(";

foreach($result as $key=>$val)

{

$schema_insert .= " `".$key."`,";

}

$schema_insert = ereg_replace(",$", "", $schema_insert);

$schema_insert .= ")

*/

$schema_insert = "INSERT INTO  $table VALUES (";

foreach($result as $key=>$val)

{

if($val != "")

$schema_insert .= " '".addslashes($val)."',";

else

$schema_insert .= "NULL,";

}

$schema_insert = ereg_replace(",$", "", $schema_insert);

$schema_insert .= ");$crlf";

$temp = $temp.$schema_insert ;

}

return $temp;

}

function RestoreFromFile($file){

if (false !== ($fp = fopen($file, 'r'))) {

$sql_queries = trim(fread($fp, filesize($file)));

$this->splitMySqlFile($pieces, $sql_queries);

foreach ($pieces as $query) {

if(!$this->execute(trim($query)))

return false;

}

return true;

}

return false;

}

function RestoreFromContent($content)

{

$content = trim($content);

$this->splitMySqlFile($pieces, $content);

foreach ($pieces as $query) {

if(!$this->execute(trim($query)))

return false;

}

return true;

}

function splitMySqlFile(&$ret, $sql)

{

$sql= trim($sql);

$sql=split(';',$sql);

$arr=array();

foreach($sql as $sq)

{

if($sq!="");

$arr[]=$sq;

}

$ret=$arr;

return true;

}

}

$db=new db();

// 生成 word

//$map=array('No','Name','Email','Age');

//echo  $db->toWord('test',$map,'档案');

// 生成 Excel

//$map=array('No','Name','Email','Age');

//echo  $db->toExcel('test',$map,'档案');

// 生成 Xml

//echo  $db->toExtXml('test',0,20);

// 生成 Json

//echo  $db->toExtJson('test',0,20);

//备份

//echo $db->Backuptofile('test','backup');

?>

2、整表备份