Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Backend Development > PHP Tutorial > sql file PHP backup database generates SQL file and downloads the function code

sql file PHP backup database generates SQL file and downloads the function code

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-07-29 08:47:58
Original
1160 people have browsed it

Copy code The code is as follows:


/****** Back up database structure ******/
/*
Function name: table2sql()
Function: Convert the table structure into SQL
Function Parameters: $table: The name of the table to be extracted
Return value: Return the extracted results, SQL collection
Function author: heiyeluren
*/
function table2sql($table)
{
global $db;
$tabledump = " DROP TABLE IF EXISTS $table;n";
$createtable = $db--->query("SHOW CREATE TABLE $table");
$create = $db->fetch_row($createtable);
$tabledump .= $create[1].";nn";
return $tabledump;
}
/****** Back up the database structure and all data ******/
/*
Function name: data2sql()
Function: Convert the table structure and data Become SQL
Function parameters: $table: table name to be extracted
Return value: Return the extracted results, SQL collection
Function author: heiyeluren
*/
function data2sql($table)
{
global $db;
$tabledump = "DROP TABLE IF EXISTS $table;n";
$createtable = $db->query("SHOW CREATE TABLE $table");
$create = $db->fetch_row($createtable);
$tabledump .= $create[1].";nn";
$rows = $db->query("SELECT * FROM $table");
$numfields = $db->num_fields($rows);
$numrows = $db->num_rows($rows);
while ($row = $db->fetch_row($rows))
{
$comma = "";
$tabledump .= "INSERT INTO $ table VALUES(";
for($i = 0; $i < $numfields; $i++)
{
$tabledump .= $comma."'".mysql_escape_string($row[$i])."'" ;
$comma = ",";
}
$tabledump .= ");n";
}
$tabledump .= "n";
return $tabledump;
}
?>

Previous article：Amount of high-quality chemical substances to write high-quality PHP programs Next article：register_globals The difference between register_globals parameter OFF and ON in PHP (detailed explanation of register_globals usage)
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Unhandled exception: FormatException: Unexpected character (at character 1) E/flutter (6084): <br /> E/flutter (6084): ^
From 1970-01-01 08:00:00
0
0
0
I failed to follow the teacher’s instructions
From 1970-01-01 08:00:00
0
0
0
PHP path reference settings
From 1970-01-01 08:00:00
0
0
0
I can't get the session value in symfony2 from the ueditor in the plug-in.
From 1970-01-01 08:00:00
0
0
0
Convert html files to word
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template