PHP Backup Database

<?PHP/** * * * @name PHP Backup Database * @param string $DbHost Connect host * @param string $DbUser User name * @param string $DbPwd Connection Password * @param string $DbName The database to be backed up * @param string $saveF  Ilename the file name to save, the default file is saved in the current folder, and is distinguished by date * @return Null * @example backupmysqldata (' localhost ', ' root ', ' 123456 ',    ' Yourdbname '); *    */    functionBackupmysqldata ($DbHost,$DbUser,$DBPWD,$DbName,$saveFileName= ' ')    {        Header("Content-type:text/html;charset=utf-8"); error_reporting(0); Set_time_limit(0); Echo' Data backup, please wait ... <br/> '; $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 Variables        $isDropInfo= ' '; $insertSQL= ' '; $row=Array(); $tables=Array(); $tableStructure=Array(); $fileName= ($saveFileName?$saveFileName: ' Mysql_data_bakeup_ ').Date(' Ymdhis '). '. SQL '; //Enumerate all tables of the database        $res=mysql_query("SHOW TABLES from$DbName");  while($row=Mysql_fetch_row($res)) {            $tables[] =$row[0]; }        Mysql_free_result($res); //Enumerate 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); }        //Enumerate INSERT statements for all tables        foreach($tables  as $val) {            $res=mysql_query("SELECT * FROM$val"); //tables with no data do not execute 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 is successful! ‘; }//Call this method Backupmysqldata (' localhost ', ' root ', ' 123456 ', ' youdbname '); ?>

PHP Backup Database