📄 export_ok.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/zip.php" );
$FILE_CONTENT = "";
$TEMP_ARRAY = explode( ",", $delete_str );
$ARRAY_COUNT1 = sizeof( $TEMP_ARRAY );
if ( $TEMP_ARRAY[$ARRAY_COUNT1 - 1] == "" )
{
--$ARRAY_COUNT1;
}
$T = 0;
for ( ; $T < $ARRAY_COUNT1; ++$T )
{
$TABLE_NAME = $TEMP_ARRAY[$T];
echo $TABLE_NAME;
$FILE_CONTENT .= "DROP TABLE IF EXISTS ".$TABLE_NAME.";\n";
$query = "SHOW CREATE TABLE ".$TABLE_NAME;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_row( $cursor ) )
{
$CREATE_STR = $ROW[1];
}
$FILE_CONTENT .= $CREATE_STR.";\n\n";
$query = "SELECT * FROM ".$TABLE_NAME;
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_row( $cursor ) )
{
$COMMA = "";
$INSERT_STR = "INSERT INTO ".$TABLE_NAME." VALUES(";
$FIELD_NUM = mysql_num_fields( $cursor );
$I = 0;
for ( ; $I < $FIELD_NUM; ++$I )
{
$INSERT_STR .= $COMMA."'".mysql_escape_string( $ROW[$I] )."'";
$COMMA = ",";
}
$INSERT_STR .= ");\n";
$FILE_CONTENT .= $INSERT_STR;
}
$FILE_CONTENT .= "\n\n";
}
$EXPORT_DATE = date( "Y-m-d", time( ) );
$filename = "OA_".$EXPORT_DATE;
$BACKUP_DIR = realpath( $DATA_DIR."/../../" )."\\sql";
if ( file_exists( $BACKUP_DIR ) )
{
}
if ( !is_dir( $BACKUP_DIR ) )
{
mkdir( $BACKUP_DIR );
}
$fp = fopen( $BACKUP_DIR.$filename.".sql", "rb" );
if ( !@fwrite( $fp, $FILE_CONTENT ) )
{
@fclose( $fp );
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -