php备份数据库类分享php备份数据库类分享1234立即学习“PHP免费学习笔记（深入）”；56789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384PHP 8.5.5PHP 8.5.5 是 PHP 8.5 分支的维护更新版本。该版本延续了“小步快跑”的迭代逻辑，通过深度错误修复、底层性能微调以及安全加固，旨在为开发者提供一个更健壮、更高效的运行环境。该版本严格遵守语义化版本规范，不包含破坏性变更。下载/**** @name php备份数据库* @param string $DbHost 连接主机* @param string $DbUser 用户名* @param string $DbPwd 连接密码* @param string $DbName 要备份的数据库* @param string $saveFileName 要保存的文件名, 默认文件保存在当前文件夹中,以日期作区分* @return Null* @example backupMySqlData('localhost', 'root', '123456', 'YourDbName');**/function backupMySqlData($DbHost, $DbUser, $DbPwd, $DbName, $saveFileName = ''){header("Content-type:text/html;charset=utf-8");error_reporting(0);set_time_limit(0);echo '数据备份中，请稍候......';$link = mysql_connect($DbHost, $DbUser, $DbPwd) or die('数据库连接失败: ' . mysql_error());mysql_select_db($DbName) or die('数据库连接失败: ' . mysql_error());mysql_query('set names utf8');// 声明变量$isDropInfo = '';$insertSQL = '';$row = array();$tables = array();$tableStructure = array();$fileName = ($saveFileName ? $saveFileName : 'MySQL_data_bakeup_') . date('YmdHis') . '.sql';// 枚举该数据库所有的表$res = mysql_query("SHOW TABLES FROM $DbName");while ($row = mysql_fetch_row($res)) {$tables[] = $row[0];}mysql_free_result($res);// 枚举所有表的创建语句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);}// 枚举所有表的INSERT语句foreach ($tables as $val) {$res = mysql_query("select * from $val");// 没有数据的表不执行insertwhile ($row = mysql_fetch_row($res)) {$sqlStr = "INSERT INTO `".$val."` VALUES (";foreach($row as $v){$sqlStr .= "'$v',";}//去掉最后一个逗号$sqlStr = substr($sqlStr, 0, strlen($sqlStr) - 1);$sqlStr .= ");\r\n";file_put_contents($fileName, $sqlStr, FILE_APPEND);}mysql_free_result($res);}echo '数据备份成功！';}// 调用此方法backupMySqlData('localhost', 'root', '123456', 'YouDbName');?>http://www.bkjia.com/PHPjc/983323.html www.bkjia.com true http://www.bkjia.com/PHPjc/983323.html TechArticle php备份数据库类分享 php备份数据库类分享 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 4...
php备份数据库类分享_PHP教程
•
👁 0人浏览过