blob: 083ceae8934589c36144cc90b9152a62d745fa38 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
<?php
/**
* Parse and analyse a SQL query
*/
declare(strict_types=1);
namespace PhpMyAdmin;
use PhpMyAdmin\SqlParser\Utils\Query;
use function count;
use function strcasecmp;
/**
* PhpMyAdmin\ParseAnalyze class
*/
class ParseAnalyze
{
/**
* Calls the parser on a query
*
* @param string $sqlQuery the query to parse
* @param string $db the current database
*
* @return array<int, StatementInfo|string>
* @psalm-return array{StatementInfo, string, string}
*/
public static function sqlQuery(string $sqlQuery, string $db): array
{
// @todo: move to returned results (also in all the calling chain)
$GLOBALS['unparsed_sql'] = $sqlQuery;
$info = Query::getAll($sqlQuery);
$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($info['select_tables'])) {
// Previous table and database name is stored to check if it changed.
$previousDb = $db;
if (count($info['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 = $info['select_tables'][0][0] ?? '';
if (isset($info['select_tables'][0][1])) {
$db = $info['select_tables'][0][1];
}
}
// There is no point checking if a reloading is required if we already decided
// to reload. Also, no reload is required for AJAX requests.
$response = ResponseRenderer::getInstance();
if (empty($info['reload']) && ! $response->isAjax()) {
// NOTE: Database names are case-insensitive.
$info['reload'] = strcasecmp($db, $previousDb) !== 0;
}
}
return [StatementInfo::fromArray($info), $db, $table];
}
}
|