export.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 55 行

<?
include_once 'inc/auth.php';
ob_end_clean ();
$FILE_CONTENT = '';
$TABLE_NAME_STR = 'SYS_CODE';
$TABLE_NAME_ARRAY = explode (',', $TABLE_NAME_STR);
$ARRAY_COUNT = sizeof ($TABLE_NAME_ARRAY);
for ($J = 0; $J < $ARRAY_COUNT; ++$J)
{
	$TABLE_NAME = $TABLE_NAME_ARRAY[$J];
	if (!($TABLE_NAME == ''))
	{
		$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 .= strtoupper ($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;
	}
}
$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=CODE_' . $EXPORT_DATE . '.sql');
for ($POS = 0; $POS <= strlen ($FILE_CONTENT); $POS += 2000)
{
	echo substr ($FILE_CONTENT, $POS, 2000);
}
?>