export_zip.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 59 行

<?
  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;
  }
  for ($T = 0; ($T < $ARRAY_COUNT1); ++$T)
  {
    $TABLE_NAME = $TEMP_ARRAY[$T];
    echo $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 .= ($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 .= '
');
  }
  $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 = ($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;
?>