} } } foreach ($views as $view) { // no data export for a view if (isset($GLOBALS[$what . '_structure'])) { if (!PMA_exportStructure($db, $view, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, 'create_view', $export_type)) { break 2; } } } 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;
while ($i < $num_tables) { $table = PMA_mysql_tablename($tables, $i); $local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table); if (isset($tmp_select) && strpos(' ' . $tmp_select, '|' . $table . '|') || !isset($tmp_select)) { if (isset($GLOBALS[$what . '_structure'])) { PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates); } if (isset($GLOBALS[$what . '_data'])) { PMA_exportData($db, $table, $crlf, $err_url, $local_query); } } $i++; } PMA_exportDBFooter($db); } else { PMA_exportDBHeader($db); // 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_mysql_select_db($db); } else { $local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $add_query; } if (isset($GLOBALS[$what . '_structure'])) { PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates); }