0x1998 - MANAGER
Edit File: ParseAnalyze.php
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Parse and analyse a SQL query * * @package PhpMyAdmin */ namespace PhpMyAdmin; use PhpMyAdmin\Response; use PhpMyAdmin\SqlParser\Utils\Query; /** * PhpMyAdmin\ParseAnalyze class * * @package PhpMyAdmin */ class ParseAnalyze { /** * Calls the parser on a query * * @param string $sql_query the query to parse * @param string $db the current database * * @return array * * @access public */ public static function sqlQuery($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 = 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); } }