php 数据库在线备份代码

php 数据库在线备份代码

function sqldumptable($table, $fp=0) {
  $tabledump = "DROP TABLE IF EXISTS $table;n";
  $tabledump .= "CREATE TABLE $table (n";

  $firstfield=1;

  $fields = mysql_query("SHOW FIELDS FROM $table");
  while ($field = mysql_fetch_array($fields)) {
   if (!$firstfield) {
    $tabledump .= ",n";
   } else {
    $firstfield=0;
   }
   $tabledump .= "   $field[Field] $field[Type]";
   if (!empty($field["Default"])) {
    $tabledump .= " DEFAULT '$field[Default]'";
   }
   if ($field['Null'] != "YES") {
    $tabledump .= " NOT NULL";
   }
   if ($field['Extra'] != "") {
    $tabledump .= " $field[Extra]";
   }
  }
  mysql_free_result($fields);
 
  $keys = mysql_query("SHOW KEYS FROM $table");
  while ($key = mysql_fetch_array($keys)) {
   $kname=$key['Key_name'];
   if ($kname != "PRIMARY" and $key['Non_unique'] == 0) {
    $kname="UNIQUE|$kname";
   }
   if(!is_array($index[$kname])) {
    $index[$kname] = array();
   }
   $index[$kname][] = $key['Column_name'];
  }
  mysql_free_result($keys);

  while(list($kname, $columns) = @each($index)) {
   $tabledump .= ",n";
   $colnames=implode($columns,",");

   if ($kname == "PRIMARY") {
    $tabledump .= "   PRIMARY KEY ($colnames)";
   } else {
    if (substr($kname,0,6) == "UNIQUE") {
     $kname=substr($kname,7);
    }
    $tabledump .= "   KEY $kname ($colnames)";
   }
  }

  $tabledump .= "n);nn";
  if ($fp) {
   fwrite($fp,$tabledump);
  } else {
   echo $tabledump;
  }

  $rows = mysql_query("SELECT * FROM $table");
  $numfields = mysql_num_fields($rows);
  while ($row = mysql_fetch_array($rows)) {
   $tabledump = "INSERT INTO $table VALUES(";

   $fieldcounter=-1;
   $firstfield=1;
   while (++$fieldcounter<$numfields) {
    if (!$firstfield) {
     $tabledump.=", ";
    } else {
     $firstfield=0;
    }

    if (!isset($row[$fieldcounter])) {
     $tabledump .= "NULL";
    } else {
     $tabledump .= "'".mysql_escape_string($row[$fieldcounter])."'";
    }
   }

   $tabledump .= ");n";

   if ($fp) {
    fwrite($fp,$tabledump);
   } else {
    echo $tabledump;
   }
  }
  mysql_free_result($rows);
 }

@mysql_connect($servername,$dbusername,$dbpassword) or die("数据库连接失败");
 @mysql_select_db($dbname) or die("选择数据库失败"); 
 $table = array_flip($_POST['table']);
 $result = mysql_query("SHOW tables");
 echo ($result) ? NULL : "出错: ".mysql_error();

 $filename = basename($_SERVER['HTTP_HOST']."_MySQL.sql");
 header('Content-type: application/unknown');
 header('Content-Disposition: attachment; filename='.$filename);
 $mysqldata = '';
 while ($currow = mysql_fetch_array($result)) {
  if (isset($table[$currow[0]])) {
   $mysqldata.= sqldumptable($currow[0]);
   $mysqldata.= $mysqldata."rn";
  }
 }
 mysql_close();
 exit;

php 获取系统当前路径与检查php配置参数
function getPath($mainpath, $relativepath) {
  global $dir;
  $mainpath_info           = explode('/', $mainpath);
  $relativepath_info       = explode('/', $relativepath);
  $relativepath_info_count = count($relativepath_info);
  for ($i=0; $i<$relativepath_info_count; $i++) {
   if ($relativepath_info[$i] == '.' || $relativepath_info[$i] == '') continue;
   if ($relativepath_info[$i] == '..') {
    $mainpath_info_count = count($mainpath_info);
    unset($mainpath_info[$mainpath_info_count-1]);
    continue;
   }
   $mainpath_info[count($mainpath_info)] = $relativepath_info[$i];
  } //end for
  return implode('/', $mainpath_info);
 }

 // 检查PHP配置参数
 function getphpcfg($varname) {
  switch($result = get_cfg_var($varname)) {
   case 0:
   return "No";
   break;
   case 1:
   return "Yes";
   break;
   default:
   return $result;
   break;
  }
 }

function copy($from, $to) {
  if ($this->abspath($to)=="/") $to=$this->basedir;
  if ($this->dirname($from) == $this->dirname($to)) $to = $this->dirname($to).'/复件'.basename($from);
  if (!is_dir($from)) {
   return @copy($from, $to);
  } else {
   if (!is_dir($to)) @mkdir($to);
   $path = opendir($from);
   while( $file = readdir( $path ) ) {
    if (($file=='.')||($file=='..')) continue;
    if (is_dir($from.'/'.$file)) $this->copy($from.'/'.$file, $to.'/'.$file);
    else echo basename($file), copy($from.'/'.$file, $to.'/'.$file) ? ' Success!' : ' False.', '<br />';
   }
   return true;
  }
 }

PHP连接MYSQL数据库类
mysql.php
<?php

Class Dirver{
 

  //连接数据库
  //link database
  function DBLink($dbhost='localhost', $dbuser='root', $password='', $dbname='', $pconnect=0){
    $this->LinkID[$this->Line] = ($pconnect == 1)? @mysql_pconnect($dbhost, $dbuser, $password) : @mysql_connect($dbhost, $dbuser, $password) or die("Connect to MySQL ($dbhost,$dbuser) failed");
    //选择连接数据库
    //choose to link database
    @mysql_select_db($dbname, $this->LinkID[$this->Line]) or die('Cannot use database '.$dbname);
    return $this->LinkID[$this->Line];
  }
 
  //查询语句
  //view qurry
  function query($query,$limit='') {
    $this -> nums ++;
    //检测如果有限制数据集则处理
    //test if there is finite data,then function
    if($limit>0){
      $query = $query.' LIMIT '.$limit;
    }
    $this-> Lists[$this->Line][] = $query;
   
   
    $querys = mysql_query($query,$this->LinkID[$this->Line]);
    if(!$querys){
      $this->DB_Error($query);
    }
    return $querys;
  }
 
  //返回数组资料
  //back to array info
  function fetch_array($query) {
    return @mysql_fetch_array($query, MYSQL_ASSOC);
  }
 
  //返回数组资料
  //back to array info
  function result($query) {
    return @mysql_result($query,$this->LinkID[$this->Line]);
  }
 
  //返回数组资料行
  //back to row info
  function rows($query) {
    return $this->fetch_array($this->query($query));
  }
 
 
  //返回数组行
  //back to numrows
  function nums($query) {
    return $this->num_rows($this->query($query));
  }
 
  //取得返回列的数目
  //fetch the numbers backing out
  function num_rows($query){
    return @mysql_num_rows($query);
  }
 
  //返回单列的各字段
  //return to every field of single row
  function fetch_row($query) {
    return @mysql_fetch_row($query);
  }
 
  //返回最后一次使用 INSERT 指令的 ID
  //return to inserted ID used last time
  function insert_id(){
    return @mysql_insert_id($this->LinkID[$this->Line]);
  }
 
  //关闭当前数据库连接
  //close current database link
  function close(){
    return @mysql_close($this->LinkID[$this->Line]);
  }
 
  //检测mysql版本
  //test mysql version
  function version(){
    $query = @mysql_query("SELECT VERSION()",$this->LinkID[$this->Line]);
    return  @mysql_result($query, 0);
  }
 

  //返回友情提示信息
  //return to kindly note
  function DB_Error_t($query=''){
 
  }
  function DB_Error($query=''){
    global $PHP_SELF;
     
      //出错语句提示
      //error sentence
      $errors = preg_replace("/'(.+?)'/is","&nbsp;'<font color='#8899DF'><b>\1</b></font>'&nbsp;",mysql_error());
     

        $charset ='';
        //提示语言
        //language noted
        $lang = Array('This SQL Error Info!', 'Error Script:', 'Present time:',
              'Http Host:', 'Server Name:', 'Server Software:',
              'Host IP Address:', 'Remote User Agent:', 'Current File:',
              'Current Line:', 'Line.', 'The Error number:',
              'The specific Error was:', 'SQL Query :', 'Not discover whateverly SQL Sentence ！');
        //时间处理
        //time
        $nowdate = date('Y-m-d H:i A');
        $errors = preg_replace("/'(.+?)'/is","'<font color='#8899DF'><b>\1</b></font>'",mysql_error());
     
      //检测是否有语句
      //test if there is any sentence.
      if($query==''){
        $query = $lang[14];
      }
     
      echo "<html>
  <head>
  <meta http-equiv='Content-Type' content='text/html; charset=$charset'>
  <title>$lang[0]</title>
  </head>
  <body>
  </body>
  </html>
  <table style='BORDER-COLLAPSE: collapse;font-size:9pt;' borderColor='#a8b7c6' cellSpacing='1' width='100%' border='1' cellpadding='3' align='center'>
          <tr>
            <td bgColor='#F9F9F9' height='38' colspan='2'>
            <font size='4' face='Arial' color='#800000'>$lang[0]</font></td>
          </tr>
          <tr>
            <td bgColor='#F9F9F9' width='165'>
            <p align='right'>$lang[2]</td>
            <td bgColor='#F9F9F9'>$nowdate</td>
          </tr>
          <tr>
            <td bgColor='#F9F9F9' width='165'>
            <p align='right'>$lang[3]</td>
            <td bgColor='#F9F9F9'><b>".$_SERVER['HTTP_HOST']."</b></td>
          </tr>
          <tr>
            <td bgColor='#F9F9F9' width='165'>
            <p align='right'>$lang[4]</td>
            <td bgColor='#F9F9F9'>".$_SERVER['SERVER_NAME']."</td>
          </tr>
          <tr>
            <td bgColor='#F9F9F9' width='165'>
            <p align='right'>$lang[5]</td>
            <td bgColor='#F9F9F9'>".$_SERVER['SERVER_SOFTWARE']."</td>
          </tr>
          <tr>
            <td bgColor='#F9F9F9' width='165'>
            <p align='right'>$lang[6]</td>
            <td bgColor='#F9F9F9'><font color="#800000">".$_SERVER['REMOTE_ADDR']."</font></td>
          </tr>
          <tr>
            <td bgColor='#F9F9F9' width='165'>
            <p align='right'>$lang[7]</td>
            <td bgColor='#F9F9F9'><font color="#000080">".$_SERVER['HTTP_USER_AGENT'].";</font></td>
          </tr>
          <tr>
            <td bgColor='#F9F9F9' width='165'>
            <p align='right'>$lang[11]</td>
            <td bgColor='#F9F9F9'><b>".mysql_errno()."</b></td>
          </tr>
          <tr>
            <td bgColor='#F9F9F9' width='165'>
            <p align='right'>$lang[12]</td>
            <td bgColor='#F9F9F9'>$errors</td>
          </tr>
          <tr>
            <td bgColor='#F9F9F9' width='165'>
            <p align='right'>$lang[13]</td>
            <td bgColor='#F9F9F9'>$query</td>
          </tr>
        </table>
          </td>
        </tr>
      </table>";
    exit;
  }

}
?>

require_once("Config.inc.php");//系统配置文件

    /*
    $DBHOST="localhost"; //主机名
    $DBUSER="root"; // 数据库用户名
    $DBPWD=""; //密码
    $DBNAME="test" ; //数据库名
    */
    //定义数据库类

    class DataBase
    {
        //定义属性

        var $mConnId;        //连接标识        

        var $mSqlString; //待执行的SQL语句

        var $mResultArray;    //执行Select语句返回的结果数组        

        
        //__construct(),构造函数,建立数据库的连接

        function __construct($pHost,$pUser,$pPwd,$pDbName){            
            $this->mConnId=mysql_connect ($pHost,$pUser,$pPwd);//建立连接

            mysql_select_db($pDbName, $this->mConnId);    //选择数据库

            mysql_query("set names 'gbk'");//设置数据库编码为GBK

        }
        
        //__destruct：析构函数，断开连接

        function __destruct(){
            mysql_close($this->mConnId); //此处还有问题......

        }
        
        //执行SQL语句

        function ExecuteSql(){
            mysql_query($this->mSqlString);
        }
        
        //查询数据，返回值为对象数组，数组中的每一元素为一行记录构成的对象

        function Query(){
            $i=0;
            $query_result=mysql_query($this->mSqlString,$this->mConnId);
            while($row=mysql_fetch_object($query_result)){
                $this->mResultArray[$i++]=$row;
            }
        }
    
    }//class DataBase


    //以下为测试用

    $db=new DataBase($DBHOST,$DBUSER,$DBPWD,$DBNAME);
    $db->mSqlString="update student set phone='123' where id='04261001' ";
    $db->ExecuteSql();
    $db->mSqlString="select * from student where id='04261001' ";
    $db->Query();
    print_r($db->mResultArray);//输出测试结果