export.php

来自「泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5」· PHP 代码 · 共 55 行

<?php

include_once( "inc/auth.php" );
ob_end_clean( );
$FILE_CONTENT = "";
$query_db = "SHOW TABLES FROM {$MYSQL_DB}";
$cursor_db = exequery( $connection, $query_db );
while ( $ROW = mysql_fetch_row( $cursor_db ) )
{
	$TABLE_NAME = strtoupper( $ROW[0] );
	if ( $TABLE_NAME == "POST_TEL" )
	{
	}
	else
	{
		$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( ) );
header( "Cache-control: private" );
header( "Content-Type: application/octetstream" );
header( "Accept-Ranges: bytes" );
header( "Accept-Length: ".strlen( $FILE_CONTENT ) );
header( "Content-Disposition: attachment;filename=OA_".$EXPORT_DATE.".sql" );
$POS = 0;
for ( ;	$POS <= strlen( $FILE_CONTENT );	$POS += 2000	)
{
	echo substr( $FILE_CONTENT, $POS, 2000 );
}
?>