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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
|
<?php
declare(strict_types=1);
namespace PhpMyAdmin;
use PhpMyAdmin\Controllers\Database\SqlController;
use function __;
use function defined;
final class DbTableExists
{
/**
* Ensure the database and the table exist (else move to the "parent" script) and display headers.
*/
public static function check(string $db, string $table, bool $isTransformationWrapper = false): void
{
self::checkDatabase($db, $isTransformationWrapper);
self::checkTable($db, $table, $isTransformationWrapper);
}
private static function checkDatabase(string $db, bool $isTransformationWrapper): void
{
$GLOBALS['message'] = $GLOBALS['message'] ?? null;
$GLOBALS['show_as_php'] = $GLOBALS['show_as_php'] ?? null;
if (! empty($GLOBALS['is_db'])) {
return;
}
$GLOBALS['is_db'] = false;
if ($db !== '') {
$GLOBALS['is_db'] = @$GLOBALS['dbi']->selectDb($db);
}
if ($GLOBALS['is_db'] || $isTransformationWrapper) {
return;
}
$response = ResponseRenderer::getInstance();
if ($response->isAjax()) {
$response->setRequestStatus(false);
$response->addJSON(
'message',
Message::error(__('No databases selected.'))
);
exit;
}
$urlParams = ['reload' => 1];
if (isset($GLOBALS['message'])) {
$urlParams['message'] = $GLOBALS['message'];
}
if (! empty($GLOBALS['sql_query'])) {
$urlParams['sql_query'] = $GLOBALS['sql_query'];
}
if (isset($GLOBALS['show_as_php'])) {
$urlParams['show_as_php'] = $GLOBALS['show_as_php'];
}
Core::sendHeaderLocation('./index.php?route=/' . Url::getCommonRaw($urlParams, '&'));
exit;
}
private static function checkTable(string $db, string $table, bool $isTransformationWrapper): void
{
$GLOBALS['containerBuilder'] = $GLOBALS['containerBuilder'] ?? null;
if (! empty($GLOBALS['is_table']) || defined('PMA_SUBMIT_MULT') || defined('TABLE_MAY_BE_ABSENT')) {
return;
}
$GLOBALS['is_table'] = false;
if ($table !== '') {
$GLOBALS['is_table'] = $GLOBALS['dbi']->getCache()->getCachedTableContent([$db, $table], false);
if ($GLOBALS['is_table']) {
return;
}
$result = $GLOBALS['dbi']->tryQuery('SHOW TABLES LIKE \'' . $GLOBALS['dbi']->escapeString($table) . '\';');
$GLOBALS['is_table'] = $result && $result->numRows();
}
if ($GLOBALS['is_table']) {
return;
}
if ($isTransformationWrapper) {
exit;
}
if ($table !== '') {
/**
* SHOW TABLES doesn't show temporary tables, so try select
* (as it can happen just in case temporary table, it should be fast):
*/
$result = $GLOBALS['dbi']->tryQuery('SELECT COUNT(*) FROM ' . Util::backquote($table) . ';');
$GLOBALS['is_table'] = $result && $result->numRows();
}
if ($GLOBALS['is_table']) {
return;
}
/** @var SqlController $controller */
$controller = $GLOBALS['containerBuilder']->get(SqlController::class);
$controller(Common::getRequest());
exit;
}
}
|