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'); |
?> |