$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++;
} 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)) {