export_zip.php

极限网络智能办公系统 - Office Automation 2008 官方100％ 源码

<?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;
$zip = new zip( );
$zipfiles[] = array(
	"{$filename}.sql",
	$FILE_CONTENT
);
$zip->Add( $zipfiles, 1 );
$code = $zip->get_file( );
$filename .= ".zip";
ob_end_clean( );
header( "Cache-control: private" );
header( "Content-type: application/x-zip" );
header( "Accept-Ranges: bytes" );
header( "Accept-Length: ".strlen( $code ) );
header( "Content-Disposition: attachment;filename=".$filename );
echo $code;
?>