export.php

通达OA2007SE源代码 非常好的

<?
  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 == ''))
    {
      continue;
    }
    else
    {
      ($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);
  }
?>