<?php
doformheader("backup", "sqltable");
maketableheader("备份包括的数据表");
$result = $DB_site->query("SHOW tables");
while ($currow = $DB_site->fetch_array($result)) {
makeyesnocode($currow[0], "table[{$currow['0']}]", 1);
}
doformfooter("备份");
doformheader("backup", "sqlfile");
maketableheader("保存文件到服务器:");
makeinputcode("在服务器上的路径和文件名", "filename", "bak/dbbackup-" . date("m-d-Y", time()) . ".sql", 0, 60);
echo "<tr class='firstalt'><td colspan='2'><p><b>在这个目录必须有PHP写入权限</b> (一般设置 chmod 0777)</p></td></tr>\n";
echo "<tr class='firstalt'><td colspan='2'><p><b>警告:</b> 不要把你的备份置于一个Internet可访问的目录. 如果可能最好把它放到WEB根目录以外!</p></td></tr>\n";
doformfooter("保存文件");
doformheader("backup", "csvtable");
maketableheader("CSV 方式导出:");
echo "<tr class='" . getrowbg() . "'>\n<td><p>选择数据表:</p></td>\n<td><p>";
echo "<select name=\"table\" size=\"1\">\n";
$result = $DB_site->query("SHOW tables");
while ($currow = $DB_site->fetch_array($result)) {
echo "<option value=\"{$currow['0']}\">{$currow['0']}</option>\n";
}
echo "</select></p></td></tr>\n\n";
makeinputcode("分隔", "separator", ",");
makeinputcode("注释", "quotes", "'");
makeyesnocode("显示 column 名字", "showhead", 1);
doformfooter("确定");
}
if ($HTTP_POST_VARS['action'] == "sqlfile") {
include "conf/admin.php";
$filehandle = fopen($filename, "w");
function makenavselect($title, $extra = "", $chs = "")
{
global $cpnavjs, $options;
if ($cpnavjs) {
echo "<tr align=\"right\"><td>\n<select class=\"tblhead\" onchange=\"navlink(this.options[this.selectedIndex].value,this.form)\">\n";
echo "<option value=\"\">" . htmlspecialchars($title) . "</option>\n<option class=\"opt\" value=\"\"> </option>\n";
echo "{$options}<option class=\"opt\" value=\"\"> </option>\n<option value=\"\">- - - - - - - - - - - - - - -</option>\n</select>";
} else {
echo "<tr><td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\" id=\"navtable\">\n";
maketableheader($title, "", 1, 1);
echo "</table>\n{$options}";
}
echo "</td></tr>{$chs}\n";
echo iif($extra != "", "<tr><td>{$extra}</td></tr>", "");
$options = "";
}
