PHP data backup: single table backup, entire table backup, import database

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


        '.$fileName.'

        ';
        echo'';          if(is_array($mapping))          {            foreach($mapping as $key=>$val)         echo'';          }          echo'';          $results=$this->findBySql('select * from '.$table);          foreach($results as $result)          {            echo'';            foreach($result as $key=>$val)         echo'';         echo'';          }          echo'



'.$val.'







'.$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">





        ';
        echo'';             echo'';          if(is_array($mapping))          {            foreach($mapping as $key=>$val)         echo'';          }          echo'';          $results=$this->findBySql('select * from '.$table);          foreach($results as $result)          {            echo'';            foreach($result as $key=>$val)         echo'';         echo'';          }          echo'




'.$val.'







'.$val.'


';
        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="")
 {
 //Exclude file, content is all Empty or neither empty
 if(($file==""&&$content=="")||($file!=""&&$content!=""))
 echo "Parameter error" ;
 $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;
 }
 }

 //Clear the table for recovery Data
 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();

// Generate word
//$map=array('No','Name','Email','Age');
 //echo $db->toWord('test',$map,'File');

// Generate Excel
//$map=array('No','Name','Email','Age ');
//echo $db->toExcel('test',$map,'file');

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

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

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

2. Backup the entire table1 2 Next page Last page