📄 export.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '<html>
<head>
<title>数据库脚本导出</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript Language="JavaScript">
function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }
 if(i==0)
 {
   if(doc';
  echo 'ument.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}
function delete_mail()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {
      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(i==0';
  echo ')
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }
  if(delete_str=="")
  {
     alert("请至少选择其中一个数据表。");
     return;
  }
  URL="export_zip.php?delete_str="+delete_str;
  window.open(URL);
}
function select_one(TABLENAME_COUNT)
{
   el=document.all("email_select").item(TABLENAME_COUNT-1';
  echo ');
   if(!el.checked)el.checked=true;
   else el.checked=false;
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/sys_config.gif" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3"> 数据库脚本导出（以下操作建议在软件开发商指导下进行）</span>
    </td>
     <td class="Big" align="right"><input type="button" value="返回" class="BigButton" onclick="location=\'index.php\'">&nbsp;&nbsp;&nbsp;
    </td>
  </tr>
</table>	
<br>
';
  $query1 = (((''.'SHOW TABLES FROM ').$MYSQL_DB).';');
  $cursor1 = exequery ($connection, $query1);
  echo '<div align="center">
<table border="0" cellspacing="1" width="40%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center">选择</td>
      <td nowrap align="center">数据表</td>
  </tr>
';
  $TABLENAME_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor1))
  {
    ++$TABLENAME_COUNT;
    $TABLE_NAME = strtoupper ($ROW[0]);
    if ((($CUSTOMER_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
    	<td nowrap align="center">&nbsp;<input type="checkbox" name="email_select"  value="';
    echo $TABLE_NAME;
    echo '"  onClick="check_one(self);"></td>
      <td nowrap align="center" onClick="select_one(';
    echo $TABLENAME_COUNT;
    echo ');" style="cursor:hand">';
    echo $TABLE_NAME;
    echo '</td>
    </tr>
';
  }
  echo ' <tr class="TableControl">
 <td colspan="2">
 	  &nbsp;&nbsp;&nbsp;<input type="checkbox" name="allbox" id="allbox_for"  onClick="check_all();"><label for="allbox_for">全选</label> &nbsp;   
    <input type="button"  value="导出" class="SmallButton" onClick="delete_mail();" title="导出所选数据表"> &nbsp;
 </td>
</tr>
</table>
<br>
<input type="button" value="返回" class="BigButton" onclick="location=';
  echo '\'index.php\'">
</div> 
</body>
</html>
';
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -