/** * Handle remembered sorting order, only for single table query * * @param string $db database name * @param string $table table name * @param array &$analyzed_sql_results the analyzed query results * @param string &$full_sql_query SQL query * * @return void */ function PMA_handleSortOrder($db, $table, &$analyzed_sql_results, &$full_sql_query) { $pmatable = new Table($table, $db); if (empty($analyzed_sql_results['order'])) { // Retrieving the name of the column we should sort after. $sortCol = $pmatable->getUiProp(Table::PROP_SORTED_COLUMN); if (empty($sortCol)) { return; } // Remove the name of the table from the retrieved field name. $sortCol = str_replace(PMA\libraries\Util::backquote($table) . '.', '', $sortCol); // Create the new query. $full_sql_query = SqlParser\Utils\Query::replaceClause($analyzed_sql_results['statement'], $analyzed_sql_results['parser']->list, 'ORDER BY ' . $sortCol); // TODO: Avoid reparsing the query. $analyzed_sql_results = SqlParser\Utils\Query::getAll($full_sql_query); } else { // Store the remembered table into session. $pmatable->setUiProp(Table::PROP_SORTED_COLUMN, SqlParser\Utils\Query::getClause($analyzed_sql_results['statement'], $analyzed_sql_results['parser']->list, 'ORDER BY')); } }
/** * Calls the parser on a query * * @param string $sql_query the query to parse * @param string $db the current database * * @return array * * @access public */ function PMA_parseAnalyze($sql_query, $db) { // @todo: move to returned results (also in all the calling chain) $GLOBALS['unparsed_sql'] = $sql_query; // Get details about the SQL query. $analyzed_sql_results = SqlParser\Utils\Query::getAll($sql_query); extract($analyzed_sql_results); $table = ''; // If the targeted table (and database) are different than the ones that is // currently browsed, edit `$db` and `$table` to match them so other elements // (page headers, links, navigation panel) can be updated properly. if (!empty($analyzed_sql_results['select_tables'])) { // Previous table and database name is stored to check if it changed. $prev_db = $db; if (count($analyzed_sql_results['select_tables']) > 1) { /** * @todo if there are more than one table name in the Select: * - do not extract the first table name * - do not show a table name in the page header * - do not display the sub-pages links) */ $table = ''; } else { $table = $analyzed_sql_results['select_tables'][0][0]; if (!empty($analyzed_sql_results['select_tables'][0][1])) { $db = $analyzed_sql_results['select_tables'][0][1]; } } // There is no point checking if a reload is required if we already decided // to reload. Also, no reload is required for AJAX requests. $response = Response::getInstance(); if (empty($reload) && !$response->isAjax()) { // NOTE: Database names are case-insensitive. $reload = strcasecmp($db, $prev_db) != 0; } // Updating the array. $analyzed_sql_results['reload'] = $reload; } return array($analyzed_sql_results, $db, $table); }
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Parse and analyse a SQL query * * @package PhpMyAdmin */ if (!defined('PHPMYADMIN')) { exit; } $GLOBALS['unparsed_sql'] = $sql_query; // Get details about the SQL query. $analyzed_sql_results = SqlParser\Utils\Query::getAll($sql_query); // TODO: Refactor this. extract($analyzed_sql_results); // If the targeted table (and database) are different than the ones that is // currently browsed, edit `$db` and `$table` to match them so other elements // (page headers, links, navigation panel) can be updated properly. if (!empty($analyzed_sql_results['select_tables'])) { // Previous table and database name is stored to check if it changed. $prev_db = $db; if (count($analyzed_sql_results['select_tables']) > 1) { /** * @todo if there are more than one table name in the Select: * - do not extract the first table name * - do not show a table name in the page header * - do not display the sub-pages links) */ $table = ''; } else {