PHP Backup Database class sharing, PHP backup Database _php Tutorial

PHP Backup Database class sharing, PHP backup database

PHP Backup Database class sharing

<?php/** * * @name PHP Backup DATABASE * @param string $DbHost Connect host * @param string $DbUser username * @param str  ing $DbPwd connection Password * @param string $DbName The database to be backed up * @param string $saveFileName The name of the file to be saved, the default file is saved in the current folder and is distinguished by date  * @return Null * @example backupmysqldata (' localhost ', ' root ', ' 123456 ', ' yourdbname '); * */function Backupmysqldata ($DbHost, $DbUser, $DBPWD, $DbName, $saveFileName = ') {Header ("content-type:text/htm    L;charset=utf-8 ");    error_reporting (0);    Set_time_limit (0); echo ' Data backup, please wait ...
';    $link = mysql_connect ($DbHost, $DbUser, $DbPwd) or Die (' Database connection failed: '. mysql_error ());    mysql_select_db ($DbName) or Die (' Database connection failed: '. mysql_error ());        mysql_query (' Set names UTF8 ');    Declaring a variable $isDropInfo = ';    $insertSQL = ";    $row = Array ();    $tables = Array ();    $tableStructure = Array (); $fileName = ($saveFileName? $saveFileName: ' Mysql_data_bakeup_ '). Date (' Ymdhis ').    '. SQL ';    Enumerates all Tables $res = mysql_query ("SHOW TABLES from $DbName") of the database;    while ($row = Mysql_fetch_row ($res)) {$tables [] = $row [0];    } mysql_free_result ($res);      Enumerates creation statements for all tables foreach ($tables as $val) {$res = mysql_query ("Show create Table $val", $link);      $row = Mysql_fetch_row ($res); $isDropInfo = "DROP TABLE IF EXISTS '". $val.      "'; \ r \ n"; $tableStructure = $isDropInfo. $row [1].      "; \ r \ n";      File_put_contents ($fileName, $tableStructure, file_append);    Mysql_free_result ($res); }//Enumerates the INSERT statements for all tables foreach ($tableS as $val) {$res = mysql_query ("SELECT * from $val"); Tables without data do not perform INSERT while ($row = Mysql_fetch_row ($res)) {$sqlStr = "INSERT into '". $val. "        ' VALUES (';        foreach ($row as $v) {$sqlStr. = "' $v ',";        }//Remove the last comma $sqlStr = substr ($sqlStr, 0, strlen ($sqlStr)-1);        $sqlStr. = "); \ r \ n";      File_put_contents ($fileName, $SQLSTR, file_append);    } mysql_free_result ($res); } Echo ' data backup was successful!  ';  }//Call this method Backupmysqldata (' localhost ', ' root ', ' 123456 ', ' youdbname '); ?>

The above mentioned is the whole content of this article, I hope you can like.

http://www.bkjia.com/PHPjc/984006.html www.bkjia.com true http://www.bkjia.com/PHPjc/984006.html techarticle PHP backup Database class share, PHP Backup database PHP backup database class share PHP/** * * @name PHP Backup DATABASE * @param string $DbHost Connect host * @param string $DbUser user name: .

