PHP 데이터 백업: 단일 테이블 백업, 전체 테이블 백업, 데이터베이스 가져오기

';

if(is_array($mapping))

{

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

echo'

';

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

foreach($results as $result)

{

echo'

';

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

echo'

';

에코'

';

}

echo'

class Db
{
 var $conn;

 함수 Db($host="localhost",$user="root",$pass="root",$db="test")
 {
 if(!$this- >conn=mysql_connect($host,$user,$pass))
 die("mysql 서버에 연결할 수 없습니다.");
 mysql_select_db($db,$this->conn);
 mysql_query("SET NAMES 'UTF-8'");
 }

 함수 실행($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적几种情况
 //공:返回전체부记录
 //배열: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.="'행':";
 $str.="[";
 for($i=0;$i<$resultNum;$i ){
 $str.="{";
 $count=count($result[$i]);
 $j=1;
 foreach($result[$i] as $key=>$val)
 {
 if($j<$count)
 {
 $str.="'". $key."':'".$val."',";
 }
 elseif($j==$count)
 {
 $str.="'".$key."':'".$val."'";
 }
 $j ;
 }

 $str.="}";
 if ($i != $resultNum-1) {
 $str.= ",";
 }
 }
 $str.="]";
 $str.="}";
 $str을 반환합니다;
 }

 함수 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.=" 여기서 ".$cons;
 }
 }
 return $sql;
 }

 함수 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="n";
 $xml.="n";
 $xml.="t".$totalNum."n";
 $xml.="tn";
 for($i=0;$i<$resultNum;$i ){
 $xml.="ttn";
 foreach($result[$i] as $key=>$val)
 $xml.="ttt<".$key.">".$val."n";
 $xml.="ttn";
 }
 $xml.="tn";
 $xml.="n";
 $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= "http://www.w3.org/TR/REC-html40">
 <머리>

 '.$fileName.'

 ';
 echo'<테이블 테두리=1>

'.$val.' }

echo'

'.$val.'

';

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= "http://www.w3.org/TR/REC-html40">

<머리>

<본문 링크=파란색 vlink=보라색 왼쪽 여백=0 상단 여백=0>';

echo'';

에코'

';

if(is_array($mapping))

{

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

echo'

';

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

foreach($results as $result)

{

echo'

';

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

echo'

';

에코'

';

}

echo'

'.$val.' }

echo'

'.$val.'

';

echo'';

echo'';

}

function Backup($table)

{

if(is_array ($table))

{

$str="";

foreach($table을 $tab으로)

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

$str을 반환합니다;

}else{

return $this->get_table_content($table);

}

}

function Backuptofile($table,$file)

{

header("Content-disposition: filename=$file.sql");//所保存적문명

header("콘텐츠 유형: 애플리케이션/옥텟스트림");

header("Pragma: no-cache");

header("만료일: 0");

if(is_array ($table))

{

$str="";

foreach($table을 $tab으로)

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

에코 $str;

}else{

echo $this->get_table_content($table)

}

}

function Restore($table,$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 = "$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 ;

}

$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=trimm($sql)

$sql=split(';',$sql); 🎜> $arr=array();

foreach($sql as $sq)

{

if($sq!="")

$arr[]=$sq; > }

$ret=$arr;

return true;

}

$db=new db()

// 단어 생성 /$map=array('아니요','이름','이메일','나이')

//echo $db->toWord('test',$map,'File')

//Excel 생성

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

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

// XML 생성

//echo $db->toExtXml('test',0,20)// Json 생성

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

//Backup

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

코드 복사

2. 테이블 전체 백업

1

2 다음 페이지 마지막 페이지