示例#1
0
$query = read_var_get_or_post('query', '');
if ($table == '' && $query == '') {
    exit;
}
if ($table == '') {
    $table = 'q';
    $force_names = read_var_get_or_post('force_names', 1) == 1;
}
if ($query == '') {
    $query = "SELECT * FROM `" . mysql_escape_string($db) . "`.`" . mysql_escape_string($table) . "`";
} else {
    $out_query = $query;
}
$filename = read_var_get_or_post('filename', $db . '_' . $table . "_" . date("YmdHi") . '.csv');
$csvdelimiter = read_var_get_or_post('d', ',');
$csvencoding = read_var_get_or_post('e', 'UTF-8');
unset($n);
if (!preg_match('/\\.csv/', $filename)) {
    $filename .= '.csv';
}
$result = $sql->query($query);
header("Content-Type: text/plain; charset={$csvencoding}");
header("Content-Disposition: attachment; filename=" . $filename);
while ($row = $sql->fetcha($result)) {
    $k = 1;
    $str = '';
    foreach ($row as $v) {
        if ($k > 1) {
            $str .= $csvdelimiter;
        }
        $k++;
示例#2
0
}
if ($table != '') {
    $show_indexes = "SHOW INDEXES FROM `" . mysql_escape_string($table) . "`";
    $show_columns = "SHOW FULL COLUMNS FROM `" . mysql_escape_string($table) . "`";
    $show_create = "SHOW CREATE TABLE `" . mysql_escape_string($table) . "`";
}
if ($table == '') {
    $table = 'q';
    $force_names = true;
}
if ($query == '') {
    $query = "SELECT * FROM `" . mysql_escape_string($db) . "`.`" . mysql_escape_string($table) . "`";
} else {
    $out_query = $query;
}
$filename = read_var_get_or_post('filename', $db . '_' . $table . "_" . date("YmdHi") . '.xml');
header("Content-type: text/xml; charset=utf-8");
header("Content-Disposition: attachment; filename=" . $filename);
print '<?xml version="1.0" encoding="UTF-8" ?>' . "\n";
print "<table_dump version='1.1' software='mysql' software_version='" . htmlspecialchars(db_version(), ENT_QUOTES) . "'>\n";
print "<definition name='" . htmlspecialchars($table, ENT_QUOTES) . "'>\n";
if (isset($show_create)) {
    output_create($show_create);
}
if (isset($show_columns)) {
    output_columns($show_columns);
}
if (isset($show_indexes)) {
    output_indexes($show_indexes);
}
if (isset($out_query)) {