phpmyadmin/server_databases.php at master · apoorvkhare07/phpmyadmin · GitHub

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
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Handles server databases page.
 *
 * @package PhpMyAdmin
 */
declare(strict_types=1);

use PhpMyAdmin\CheckUserPrivileges;
use PhpMyAdmin\Controllers\Server\DatabasesController;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Response;

if (! defined('ROOT_PATH')) {
    define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
}

require_once ROOT_PATH . 'libraries/common.inc.php';

/** @var DatabasesController $controller */
$controller = $containerBuilder->get(DatabasesController::class);

/** @var Response $response */
$response = $containerBuilder->get(Response::class);

/** @var DatabaseInterface $dbi */
$dbi = $containerBuilder->get(DatabaseInterface::class);

$checkUserPrivileges = new CheckUserPrivileges($dbi);
$checkUserPrivileges->getPrivileges();

if ( ! empty($_REQUEST['favorite_db'])) {
    $json = $controller->addRemoveFavoriteDatabaseAction([
        'favorite_database' => $_REQUEST['favorite_db'],
        'favoriteDatabases' => $_REQUEST['favoriteDatabases'] ?? null,
        'sync_favorite_databases' => $_REQUEST['sync_favorite_databases'] ?? null,
        'add_favorite' => $_REQUEST['add_favorite'] ?? null,
        'remove_favorite' => $_REQUEST['remove_favorite'] ?? null,
    ]);
    if ($json !== null) {
        $response->addJSON($json);
    }
}
elseif (isset($_POST['drop_selected_dbs'])
    && $response->isAjax()
    && ($dbi->isSuperuser() || $GLOBALS['cfg']['AllowUserDropDatabase'])
) {
    $response->addJSON($controller->dropDatabasesAction([
        'drop_selected_dbs' => $_POST['drop_selected_dbs'],
        'selected_dbs' => $_POST['selected_dbs'] ?? null,
    ]));
} elseif (isset($_POST['new_db'])
    && $response->isAjax()
) {
    $response->addJSON($controller->createDatabaseAction([
        'new_db' => $_POST['new_db'],
        'db_collation' => $_POST['db_collation'] ?? null,
    ]));
} else {
    $header = $response->getHeader();
    $scripts = $header->getScripts();
    $scripts->addFile('server/databases.js');

    $response->addHTML($controller->indexAction([
        'statistics' => $_REQUEST['statistics'] ?? null,
        'pos' => $_REQUEST['pos'] ?? null,
        'sort_by' => $_REQUEST['sort_by'] ?? null,
        'sort_order' => $_REQUEST['sort_order'] ?? null,
    ]));
}