export.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

<?
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'))
	{
		if (!($TABLE_NAME == 'SYS_LOG'))
		{
			if (!($TABLE_NAME == 'SMS'))
			{
				$FILE_CONTENT .= 'DROP TABLE IF EXISTS ' . $TABLE_NAME . ';
';
				$query = 'SHOW CREATE TABLE ' . $TABLE_NAME;
				$cursor = exequery ($connection, $query);
				if ($ROW = mysql_fetch_row ($cursor))
				{
					$CREATE_STR = $ROW[1];
				}
				$FILE_CONTENT .= $CREATE_STR . ';
';
				$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);
					for ($I = 0; $I < $FIELD_NUM; ++$I)
					{
						$INSERT_STR .= $COMMA . '\'' . mysql_escape_string ($ROW[$I]) . '\'';
						$COMMA = ',';
					}
					$INSERT_STR .= ');
';
					$FILE_CONTENT .= $INSERT_STR;
				}
				$FILE_CONTENT .= '
';
				continue;
			}
			continue;
		}
		continue;
	}
}
$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');
for ($POS = 0; $POS <= strlen ($FILE_CONTENT); $POS += 2000)
{
	echo substr ($FILE_CONTENT, $POS, 2000);
}
?>