123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 |
- <?php
- namespace PhpMyAdmin;
- use PhpMyAdmin\Response;
- use PhpMyAdmin\SqlParser\Utils\Query;
- class ParseAnalyze
- {
-
- public static function sqlQuery($sql_query, $db)
- {
-
- $GLOBALS['unparsed_sql'] = $sql_query;
-
- $analyzed_sql_results = Query::getAll($sql_query);
- extract($analyzed_sql_results);
- $table = '';
-
-
-
- if (!empty($analyzed_sql_results['select_tables'])) {
-
- $prev_db = $db;
- if (count($analyzed_sql_results['select_tables']) > 1) {
-
- $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];
- }
- }
-
-
- $response = Response::getInstance();
- if (empty($reload) && ! $response->isAjax()) {
-
- $reload = strcasecmp($db, $prev_db) != 0;
- }
-
- $analyzed_sql_results['reload'] = $reload;
- }
- return array($analyzed_sql_results, $db, $table);
- }
- }
|