| 0,0 → 1,116 |
|---|
| <?php |
| /* $Id: tbl_properties_export.php,v 2.17 2005/12/08 16:13:51 nijel Exp $ */ |
| // vim: expandtab sw=4 ts=4 sts=4: |
| |
| require_once('./libraries/common.lib.php'); |
| |
| /** |
| * Gets tables informations and displays top links |
| */ |
| require_once('./libraries/tbl_properties_common.php'); |
| $url_query .= '&goto=tbl_properties_export.php&back=tbl_properties_export.php'; |
| require_once('./libraries/tbl_properties_table_info.inc.php'); |
| |
| // Dump of a table |
| |
| $export_page_title = $strViewDump; |
| |
| // When we have some query, we need to remove LIMIT from that and possibly |
| // generate WHERE clause (if we are asked to export specific rows) |
| |
| if (isset($sql_query)) { |
| // Parse query so we can work with tokens |
| $parsed_sql = PMA_SQP_parse($sql_query); |
| |
| // Need to generate WHERE clause? |
| if (isset($primary_key)) { |
| // Yes => rebuild query from scracts, this doesn't work with nested |
| // selects :-( |
| $analyzed_sql = PMA_SQP_analyze($parsed_sql); |
| $sql_query = 'SELECT '; |
| |
| if (isset($analyzed_sql[0]['queryflags']['distinct'])) { |
| $sql_query .= ' DISTINCT '; |
| } |
| |
| $sql_query .= $analyzed_sql[0]['select_expr_clause']; |
| |
| if (!empty($analyzed_sql[0]['from_clause'])) { |
| $sql_query .= ' FROM ' . $analyzed_sql[0]['from_clause']; |
| } |
| |
| if (isset($primary_key) && is_array($primary_key)) { |
| $sql_query .= ' WHERE '; |
| $conj = ''; |
| foreach ($primary_key AS $i => $key) { |
| $sql_query .= $conj . '( ' . $key . ' ) '; |
| $conj = 'OR '; |
| } |
| } elseif (!empty($analyzed_sql[0]['where_clause'])) { |
| $sql_query .= ' WHERE ' . $analyzed_sql[0]['where_clause']; |
| } |
| if (!empty($analyzed_sql[0]['group_by_clause'])) { |
| $sql_query .= ' GROUP BY ' . $analyzed_sql[0]['group_by_clause']; |
| } |
| if (!empty($analyzed_sql[0]['having_clause'])) { |
| $sql_query .= ' HAVING ' . $analyzed_sql[0]['having_clause']; |
| } |
| if (!empty($analyzed_sql[0]['order_by_clause'])) { |
| $sql_query .= ' ORDER BY ' . $analyzed_sql[0]['order_by_clause']; |
| } |
| } else { |
| // Just crop LIMIT clause |
| $inside_bracket = FALSE; |
| for ($i = $parsed_sql['len'] - 1; $i >= 0; $i--) { |
| if ($parsed_sql[$i]['type'] == 'punct_bracket_close_round') { |
| $inside_bracket = TRUE; |
| continue; |
| } |
| if ($parsed_sql[$i]['type'] == 'punct_bracket_open_round') { |
| $inside_bracket = FALSE; |
| continue; |
| } |
| if (!$inside_bracket && $parsed_sql[$i]['type'] == 'alpha_reservedWord' && strtoupper($parsed_sql[$i]['data']) == 'LIMIT') { |
| // We found LIMIT to remove |
| |
| $sql_query = ''; |
| |
| // Concatenate parts before |
| for ($j = 0; $j < $i; $j++) { |
| $sql_query .= $parsed_sql[$j]['data'] . ' '; |
| } |
| |
| // Skip LIMIT |
| $i++; |
| while ($i < $parsed_sql['len'] && |
| ($parsed_sql[$i]['type'] != 'alpha_reservedWord' || |
| ($parsed_sql[$i]['type'] == 'alpha_reservedWord' && $parsed_sql[$i]['data'] == 'OFFSET'))) { |
| $i++; |
| } |
| |
| // Add remaining parts |
| while ($i < $parsed_sql['len']) { |
| $sql_query .= $parsed_sql[$i]['data'] . ' '; |
| $i++; |
| } |
| break; |
| } |
| } |
| } |
| $message = $GLOBALS['strSuccess']; |
| } |
| |
| /** |
| * Displays top menu links |
| */ |
| require('./libraries/tbl_properties_links.inc.php'); |
| |
| $export_type = 'table'; |
| require_once('./libraries/display_export.lib.php'); |
| |
| |
| /** |
| * Displays the footer |
| */ |
| require_once('./libraries/footer.inc.php'); |
| ?> |