break; } // We export just one table if ($limit_to > 0 && $limit_from >= 0) { $add_query = ' LIMIT ' . ($limit_from > 0 ? $limit_from . ', ' : '') . $limit_to; } else { $add_query = ''; } if (!empty($sql_query)) { $local_query = $sql_query . $add_query; PMA_DBI_select_db($db); } else { $local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $add_query; } if (isset($GLOBALS[$what . '_structure'])) { if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates)) { break; } } if (isset($GLOBALS[$what . '_data'])) { if (!PMA_exportData($db, $table, $crlf, $err_url, $local_query)) { break; } } if (!PMA_exportDBFooter($db)) { break; } } if (!PMA_exportFooter()) { break; }
// remove trailing semicolon before adding a LIMIT $sql_query = preg_replace('%;\\s*$%', '', $sql_query); } $local_query = $sql_query . $add_query; PMA_DBI_select_db($db); } else { $local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $add_query; } if (!PMA_exportData($db, $table, $crlf, $err_url, $local_query)) { break; } } // now export the triggers (needs to be done after the data because // triggers can modify already imported tables) if (isset($GLOBALS[$what . '_structure'])) { if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, 'triggers', $export_type)) { break 2; } } if (!PMA_exportDBFooter($db)) { break; } } if (!PMA_exportFooter()) { break; } } while (false); // End of fake loop if ($save_on_server && isset($message)) { $GLOBALS['js_include'][] = 'functions.js'; require_once './libraries/header.inc.php';
if (!PMA_exportDBFooter($db)) { break; } } else { if (!PMA_exportDBHeader($db)) { break; } // We export just one table if ($limit_to > 0 && $limit_from >= 0) { $add_query = ' LIMIT ' . ($limit_from > 0 ? $limit_from . ', ' : '') . $limit_to; } else { $add_query = ''; } $is_view = PMA_Table::isView($db, $table); if (isset($GLOBALS[$what . '_structure'])) { if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, $is_view ? 'create_view' : 'create_table', $export_type)) { break; } } // If this is an export of a single view, we have to export data; // for example, a PDF report if (isset($GLOBALS[$what . '_data'])) { if (!empty($sql_query)) { // only preg_replace if needed if (!empty($add_query)) { // remove trailing semicolon before adding a LIMIT $sql_query = preg_replace('%;\\s*$%', '', $sql_query); } $local_query = $sql_query . $add_query; PMA_DBI_select_db($db); } else {