3 // vim: expandtab sw=4 ts=4 sts=4:
6 * Get the variables sent or posted to this script and a core script
8 require('./libraries/grab_globals.lib.php3');
9 require('./libraries/common.lib.php3');
10 require('./libraries/zip.lib.php3');
12 PMA_checkParameters(array('what'));
14 // What type of export are we doing?
15 if ($what == 'excel') {
22 * Defines the url to return to in case of error in a sql statement
24 require('./libraries/export/' . $type . '.php3');
27 if ($export_type == 'server') {
28 $err_url = 'server_export.php3?' . PMA_generate_common_url();
29 } elseif ($export_type == 'database') {
30 $err_url = 'db_details_export.php3?' . PMA_generate_common_url($db);
32 $err_url = 'tbl_properties_export.php3?' . PMA_generate_common_url($db, $table);
36 * Increase time limit for script execution and initializes some variables
38 @set_time_limit
($cfg['ExecTimeLimit']);
40 // Start with empty buffer
43 // We send fake headers to avoid browser timeout when buffering
48 * Output handler for all exports, if needed buffering, it stores data into
49 * $dump_buffer, otherwise it prints thems out.
51 * @param string the insert statement
53 * @return bool Whether output suceeded
55 function PMA_exportOutputHandler($line)
59 // Kanji encoding convert feature
60 if (function_exists('PMA_kanji_str_conv')) {
61 $line = PMA_kanji_str_conv($line, $GLOBALS['knjenc'], isset($GLOBALS['xkana']) ?
$GLOBALS['xkana'] : '');
63 // If we have to buffer data, we will perform everything at once at the end
64 if ($GLOBALS['buffer_needed']) {
65 $GLOBALS['dump_buffer'] .= $line;
68 if ($time_start >= $time_now +
30) {
69 $time_start = $time_now;
70 header('X-pmaPing: Pong');
73 if ($GLOBALS['asfile']) {
74 if ($GLOBALS['save_on_server']) {
75 $write_result = @fwrite
($GLOBALS['file_handle'], $line);
76 if (!$write_result ||
($write_result != strlen($line))) {
77 $GLOBALS['message'] = sprintf($GLOBALS['strNoSpace'], htmlspecialchars($save_filename));
81 if ($time_start >= $time_now +
30) {
82 $time_start = $time_now;
83 header('X-pmaPing: Pong');
86 // We export as file - output normally
87 if ($GLOBALS['output_charset_conversion']) {
88 $line = PMA_convert_string($GLOBALS['charset'], $GLOBALS['charset_of_file'], $line);
93 // We export as html - replace special chars
94 echo htmlspecialchars($line);
98 } // end of the 'PMA_exportOutputHandler()' function
100 // Will we save dump on server?
101 $save_on_server = isset($cfg['SaveDir']) && !empty($cfg['SaveDir']) && !empty($onserver);
103 // Ensure compressed formats are associated with the download feature
104 if (empty($asfile)) {
105 if ($save_on_server) {
107 } elseif (isset($compression) && ($compression == 'zip' |
$compression == 'gzip' |
$compression == 'bzip')) {
116 // Defines the default <CR><LF> format
117 $crlf = PMA_whichCrlf();
119 // Do we need to convert charset?
120 $output_charset_conversion = $asfile &&
121 $cfg['AllowAnywhereRecoding'] && $allow_recoding
122 && isset($charset_of_file) && $charset_of_file != $charset;
124 // Set whether we will need buffering
125 $buffer_needed = isset($compression) && ($compression == 'zip' |
$compression == 'gzip' |
$compression == 'bzip');
127 // Generate filename and mime type if needed
129 $pma_uri_parts = parse_url($cfg['PmaAbsoluteUri']);
130 if ($export_type == 'server') {
131 if (isset($remember_template)) {
132 setcookie('pma_server_filename_template', $filename_template , 0,
133 substr($pma_uri_parts['path'], 0, strrpos($pma_uri_parts['path'], '/')),
134 '', ($pma_uri_parts['scheme'] == 'https'));
136 $filename = str_replace('__SERVER__', $GLOBALS['cfg']['Server']['host'], strftime($filename_template));
137 } elseif ($export_type == 'database') {
138 if (isset($remember_template)) {
139 setcookie('pma_db_filename_template', $filename_template , 0,
140 substr($pma_uri_parts['path'], 0, strrpos($pma_uri_parts['path'], '/')),
141 '', ($pma_uri_parts['scheme'] == 'https'));
143 $filename = str_replace('__DB__', $db, str_replace('__SERVER__', $GLOBALS['cfg']['Server']['host'], strftime($filename_template)));
145 if (isset($remember_template)) {
146 setcookie('pma_table_filename_template', $filename_template , 0,
147 substr($pma_uri_parts['path'], 0, strrpos($pma_uri_parts['path'], '/')),
148 '', ($pma_uri_parts['scheme'] == 'https'));
150 $filename = str_replace('__TABLE__', $table, str_replace('__DB__', $db, str_replace('__SERVER__', $GLOBALS['cfg']['Server']['host'], strftime($filename_template))));
153 // convert filename to iso-8859-1, it is safer
154 if (!(isset($cfg['AllowAnywhereRecoding']) && $cfg['AllowAnywhereRecoding'] && $allow_recoding)) {
155 $filename = PMA_convert_string($charset, 'iso-8859-1', $filename);
157 $filename = PMA_convert_string($convcharset, 'iso-8859-1', $filename);
160 // Generate basic dump extension
161 if ($type == 'csv') {
163 $mime_type = 'text/x-csv';
164 } else if ($type == 'xml') {
166 $mime_type = 'text/xml';
167 } else if ($type == 'latex') {
169 $mime_type = 'application/x-tex';
172 // loic1: 'application/octet-stream' is the registered IANA type but
173 // MSIE and Opera seems to prefer 'application/octetstream'
174 $mime_type = (PMA_USR_BROWSER_AGENT
== 'IE' || PMA_USR_BROWSER_AGENT
== 'OPERA')
175 ?
'application/octetstream'
176 : 'application/octet-stream';
179 // If dump is going to be compressed, set correct mime_type and add
180 // compression to extension
181 if (isset($compression) && $compression == 'bzip') {
183 $mime_type = 'application/x-bzip';
184 } else if (isset($compression) && $compression == 'gzip') {
186 $mime_type = 'application/x-gzip';
187 } else if (isset($compression) && $compression == 'zip') {
189 $mime_type = 'application/x-zip';
193 // Open file on server if needed
194 if ($save_on_server) {
195 $save_filename = $cfg['SaveDir'] . ereg_replace('[/\\]','_',$filename);
197 if (file_exists($save_filename) && empty($onserverover)) {
198 $message = sprintf($strFileAlreadyExists, htmlspecialchars($save_filename));
200 if (is_file($save_filename) && !is_writable($save_filename)) {
201 $message = sprintf($strNoPermission, htmlspecialchars($save_filename));
203 if (!$file_handle = @fopen
($save_filename, 'w')) {
204 $message = sprintf($strNoPermission, htmlspecialchars($save_filename));
208 if (isset($message)) {
209 $js_to_run = 'functions.js';
210 include('./header.inc.php3');
211 if ($export_type == 'server') {
212 $active_page = 'server_export.php3';
213 include('./server_export.php3');
214 } elseif ($export_type == 'database') {
215 $active_page = 'db_details_export.php3';
216 include('./db_details_export.php3');
218 $active_page = 'tbl_properties_export.php3';
219 include('./tbl_properties_export.php3');
226 * Send headers depending on whether the user chose to download a dump file
229 if (!$save_on_server) {
232 header('Content-Type: ' . $mime_type);
233 header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
234 // lem9 & loic1: IE need specific headers
235 if (PMA_USR_BROWSER_AGENT
== 'IE') {
236 header('Content-Disposition: inline; filename="' . $filename . '"');
237 header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
238 header('Pragma: public');
240 header('Content-Disposition: attachment; filename="' . $filename . '"');
241 header('Pragma: no-cache');
245 $backup_cfgServer = $cfg['Server'];
246 include('./header.inc.php3');
247 $cfg['Server'] = $backup_cfgServer;
248 unset($backup_cfgServer);
249 echo '<div align="' . $cell_align_left . '">' . "\n";
250 echo ' <pre>' . "\n";
254 // Check if we have something to export
255 if ($export_type == 'database') {
256 $tables = PMA_mysql_list_tables($db);
257 $num_tables = ($tables) ? @mysql_numrows
($tables) : 0;
258 if ($num_tables == 0) {
259 $message = $strNoTablesFound;
260 $js_to_run = 'functions.js';
261 include('./header.inc.php3');
262 if ($export_type == 'server') {
263 $active_page = 'server_export.php3';
264 include('./server_export.php3');
265 } elseif ($export_type == 'database') {
266 $active_page = 'db_details_export.php3';
267 include('./db_details_export.php3');
269 $active_page = 'tbl_properties_export.php3';
270 include('./tbl_properties_export.php3');
276 // Add possibly some comments to export
279 // Will we need relation & co. setup?
280 $do_relation = isset($GLOBALS[$what . '_relation']);
281 $do_comments = isset($GLOBALS[$what . '_comments']);
282 $do_mime = isset($GLOBALS[$what . '_mime']);
283 if ($do_relation ||
$do_comments ||
$do_mime) {
284 require('./libraries/relation.lib.php3');
285 $cfgRelation = PMA_getRelationsParam();
288 require('./libraries/transformations.lib.php3');
294 // Gets the number of tables if a dump of a database has been required
295 if ($export_type == 'server') {
297 * Gets the databases list - if it has not been built yet
299 if ($server > 0 && empty($dblist)) {
300 PMA_availableDatabases();
303 if (isset($db_select)) {
304 $tmp_select = implode($db_select, '|');
305 $tmp_select = '|' . $tmp_select . '|';
307 // Walk over databases
309 while (list(, $current_db) = each($dblist)) {
310 if ((isset($tmp_select) && strpos(' ' . $tmp_select, '|' . $current_db . '|'))
311 ||
!isset($tmp_select)) {
312 PMA_exportDBHeader($current_db);
313 PMA_exportDBCreate($current_db);
314 $tables = PMA_mysql_list_tables($current_db);
315 $num_tables = ($tables) ? @mysql_numrows
($tables) : 0;
317 while ($i < $num_tables) {
318 $table = PMA_mysql_tablename($tables, $i);
319 $local_query = 'SELECT * FROM ' . PMA_backquote($current_db) . '.' . PMA_backquote($table);
320 if (isset($GLOBALS[$what . '_structure'])) PMA_exportStructure($current_db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime);
321 if (isset($GLOBALS[$what . '_data'])) PMA_exportData($current_db, $table, $crlf, $err_url, $local_query);
324 PMA_exportDBFooter($current_db);
327 } elseif ($export_type == 'database') {
328 PMA_exportDBHeader($db);
329 if (isset($table_select)) {
330 $tmp_select = implode($table_select, '|');
331 $tmp_select = '|' . $tmp_select . '|';
334 while ($i < $num_tables) {
335 $table = PMA_mysql_tablename($tables, $i);
336 $local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table);
337 if ((isset($tmp_select) && strpos(' ' . $tmp_select, '|' . $table . '|'))
338 ||
!isset($tmp_select)) {
340 if (isset($GLOBALS[$what . '_structure'])) PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime);
341 if (isset($GLOBALS[$what . '_data'])) PMA_exportData($db, $table, $crlf, $err_url, $local_query);
345 PMA_exportDBFooter($db);
347 PMA_exportDBHeader($db);
348 // We export just one table
350 if ($limit_to > 0 && $limit_from >= 0) {
351 $add_query = ' LIMIT '
352 . (($limit_from > 0) ?
$limit_from . ', ' : '')
358 if (!empty($sql_query)) {
359 $local_query = $sql_query . $add_query;
360 PMA_mysql_select_db($db);
362 $local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $add_query;
365 if (isset($GLOBALS[$what . '_structure'])) PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime);
366 if (isset($GLOBALS[$what . '_data'])) PMA_exportData($db, $table, $crlf, $err_url, $local_query);
367 PMA_exportDBFooter($db);
371 * Send the dump as a file...
373 if (!empty($asfile)) {
374 // Convert the charset if required.
375 if ($output_charset_conversion) {
376 $dump_buffer = PMA_convert_string($GLOBALS['charset'], $GLOBALS['charset_of_file'], $dump_buffer);
379 // Do the compression
380 // 1. as a gzipped file
381 if (isset($compression) && $compression == 'zip') {
382 if (PMA_PHP_INT_VERSION
>= 40000 && @function_exists
('gzcompress')) {
383 if ($type == 'csv' ) {
385 } else if ($type == 'xml') {
390 $zipfile = new zipfile();
391 $zipfile -> addFile($dump_buffer, $filename . $extbis);
392 $dump_buffer = $zipfile -> file();
395 // 2. as a bzipped file
396 else if (isset($compression) && $compression == 'bzip') {
397 if (PMA_PHP_INT_VERSION
>= 40004 && @function_exists
('bzcompress')) {
398 $dump_buffer = bzcompress($dump_buffer);
399 // nijel: eval in next line is because otherwise === causes syntax error on php3
400 if (eval('return($dump_buffer === -8);')) {
401 include('./header.inc.php3');
402 echo sprintf($strBzError, '<a href="http://bugs.php.net/bug.php?id=17300" target="_blank">17300</a>');
403 include('./footer.inc.php3');
408 // 3. as a gzipped file
409 else if (isset($compression) && $compression == 'gzip') {
410 if (PMA_PHP_INT_VERSION
>= 40004 && @function_exists
('gzencode')) {
411 // without the optional parameter level because it bug
412 $dump_buffer = gzencode($dump_buffer);
416 /* If ve saved on server, we have to close file now */
417 if ($save_on_server) {
418 $write_result = @fwrite
($file_handle, $dump_buffer);
419 fclose($file_handle);
420 if (strlen($dump_buffer) !=0 && (!$write_result ||
($write_result != strlen($dump_buffer)))) {
421 $message = sprintf($strNoSpace, htmlspecialchars($save_filename));
423 $message = sprintf($strDumpSaved, htmlspecialchars($save_filename));
426 $js_to_run = 'functions.js';
427 include('./header.inc.php3');
428 if ($export_type == 'server') {
429 $active_page = 'server_export.php3';
430 include('./server_export.php3');
431 } elseif ($export_type == 'database') {
432 $active_page = 'db_details_export.php3';
433 include('./db_details_export.php3');
435 $active_page = 'tbl_properties_export.php3';
436 include('./tbl_properties_export.php3');
444 * Displays the dump...
448 * Close the html tags and add the footers in dump is displayed on screen
450 echo ' </pre>' . "\n";
451 echo '</div>' . "\n";
453 include('./footer.inc.php3');