PHP备份数据库生成SQL文件并下载的函数代码_php技巧

 <BR><!?php <BR>/****** 备份数据库结构 ******/ <BR>/* <BR>函数名称：table2sql() <BR>函数功能：把表的结构转换成为SQL <BR>函数参数：$table: 要进行提取的表名 <BR>返 回 值：返回提取后的结果，SQL集合 <BR>函数作者：heiyeluren <BR>*/ <BR>function table2sql($table) <BR>{ <BR>global $db; <BR>$tabledump = "DROP TABLE IF EXISTS $table;n"; <BR>$createtable = $db--->query("SHOW CREATE TABLE $table"); <BR>$create = $db->fetch_row($createtable); <BR>$tabledump .= $create[1].";nn"; <BR>return $tabledump; <BR>} <BR>/****** 备份数据库结构和所有数据 ******/ <BR>/* <BR>函数名称：data2sql() <BR>函数功能：把表的结构和数据转换成为SQL <BR>函数参数：$table: 要进行提取的表名 <BR>返 回 值：返回提取后的结果，SQL集合 <BR>函数作者：heiyeluren <BR>*/ <BR>function data2sql($table) <BR>{ <BR>global $db; <BR>$tabledump = "DROP TABLE IF EXISTS $table;n"; <BR>$createtable = $db->query("S<mark style="color:transparent">本%文来源gaodaimacom搞#^代%!码网@</mark>搞代gaodaima码HOW CREATE TABLE $table"); <BR>$create = $db->fetch_row($createtable); <BR>$tabledump .= $create[1].";nn"; <BR>$rows = $db->query("SELECT * FROM $table"); <BR>$numfields = $db->num_fields($rows); <BR>$numrows = $db->num_rows($rows); <BR>while ($row = $db->fetch_row($rows)) <BR>{ <BR>$comma = ""; <BR>$tabledump .= "INSERT INTO $table VALUES("; <BR>for($i = 0; $i < $numfields; $i++) <BR>{ <BR>$tabledump .= $comma."'".mysql_escape_string($row[$i])."'"; <BR>$comma = ","; <BR>} <BR>$tabledump .= ");n"; <BR>} <BR>$tabledump .= "n"; <BR>return $tabledump; <BR>} <BR>?> <BR><!---ecms -ecms ?php <BR>$host="localhost"; //主机名 <BR>$user="root"; //MYSQL用户名 <BR>$password="root"; //密码 <BR>$dbname="dedecmsv4"; //备份的数据库 <BR>mysql_connect($host,$user,$password); <BR>mysql_select_db($dbname); <BR>$q1=mysql_query("show tables"); <BR>while($t=mysql_fetch_array($q1)){ <BR>$table=$t[0]; <BR>$q2=mysql_query("show create table `$table`"); <BR>$sql=mysql_fetch_array($q2); <BR>$mysql.=$sql['Create Table'].";rnrn";#DDL <BR>$q3=mysql_query("select * from `$table`"); <BR>while($data=mysql_fetch_assoc($q3)) <BR>{ <BR>$keys=array_keys($data); <BR>$keys=array_map('addslashes',$keys); <BR>$keys=join('`,`',$keys); <BR>$keys="`".$keys."`"; <BR>$vals=array_values($data); <BR>$vals=array_map('addslashes',$vals); <BR>$vals=join("','",$vals); <BR>$vals="'".$vals."'"; <BR>$mysql.="insert into `$table`($keys) values($vals);rn"; <BR>} <BR>$mysql.="rn"; <BR>} <BR>$filename=date('Ymd')."_".$dbname.".sql"; //文件名为当天的日期 <BR>$fp = fopen($filename,'w'); <BR>fputs($fp,$mysql); <BR>fclose($fp); <BR>echo "数据备份成功,生成备份文件".$filename; <BR>?> <BR>

喜欢 (0)赏

[搞代码]

分享 (0)