parse_analyze.lib.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Parse and analyse a SQL query
 *
 * @package PhpMyAdmin
 */
use PMA\libraries\Response;

if (! defined('PHPMYADMIN')) {
    exit;
}

/**
 * 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 = PhpMyAdmin\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);
}