libraries/classes/ListDatabase.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * holds the ListDatabase class
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 declare(strict_types=1);
   9
  10 namespace PhpMyAdmin;
  11
  12 use PhpMyAdmin\ListAbstract;
  13 use PhpMyAdmin\Util;
  14
  15 /**
  16  * handles database lists
  17  *
  18  * <code>
  19  * $ListDatabase = new ListDatabase();
  20  * </code>
  21  *
  22  * @todo this object should be attached to the PMA_Server object
  23  *
  24  * @package PhpMyAdmin
  25  * @since   phpMyAdmin 2.9.10
  26  */
  27 class ListDatabase extends ListAbstract
  28 {
  29     /**
  30      * Constructor
  31      */
  32     public function __construct()
  33     {
  34         parent::__construct();
  35
  36         $checkUserPrivileges = new CheckUserPrivileges($GLOBALS['dbi']);
  37         $checkUserPrivileges->getPrivileges();
  38
  39         $this->build();
  40     }
  41
  42     /**
  43      * checks if the configuration wants to hide some databases
  44      *
  45      * @return void
  46      */
  47     protected function checkHideDatabase()
  48     {
  49         if (empty($GLOBALS['cfg']['Server']['hide_db'])) {
  50             return;
  51         }
  52
  53         foreach ($this->getArrayCopy() as $key => $db) {
  54             if (preg_match('/' . $GLOBALS['cfg']['Server']['hide_db'] . '/', $db)) {
  55                 $this->offsetUnset($key);
  56             }
  57         }
  58     }
  59
  60     /**
  61      * retrieves database list from server
  62      *
  63      * @param string $like_db_name usually a db_name containing wildcards
  64      *
  65      * @return array
  66      */
  67     protected function retrieve($like_db_name = null)
  68     {
  69         $database_list = [];
  70         $command = "";
  71         if (! $GLOBALS['cfg']['Server']['DisableIS']) {
  72             $command .= "SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`";
  73             if (null !== $like_db_name) {
  74                 $command .= " WHERE `SCHEMA_NAME` LIKE '" . $like_db_name . "'";
  75             }
  76         } else {
  77             if ($GLOBALS['dbs_to_test'] === false || null !== $like_db_name) {
  78                 $command .= "SHOW DATABASES";
  79                 if (null !== $like_db_name) {
  80                     $command .= " LIKE '" . $like_db_name . "'";
  81                 }
  82             } else {
  83                 foreach ($GLOBALS['dbs_to_test'] as $db) {
  84                     $database_list = array_merge(
  85                         $database_list,
  86                         $this->retrieve($db)
  87                     );
  88                 }
  89             }
  90         }
  91
  92         if ($command) {
  93             $database_list = $GLOBALS['dbi']->fetchResult(
  94                 $command,
  95                 null,
  96                 null
  97             );
  98         }
  99
 100         if ($GLOBALS['cfg']['NaturalOrder']) {
 101             usort($database_list, 'strnatcasecmp');
 102         } else {
 103             // need to sort anyway, otherwise information_schema
 104             // goes at the top
 105             sort($database_list);
 106         }
 107
 108         return $database_list;
 109     }
 110
 111     /**
 112      * builds up the list
 113      *
 114      * @return void
 115      */
 116     public function build()
 117     {
 118         if (! $this->checkOnlyDatabase()) {
 119             $items = $this->retrieve();
 120             $this->exchangeArray($items);
 121         }
 122
 123         $this->checkHideDatabase();
 124     }
 125
 126     /**
 127      * checks the only_db configuration
 128      *
 129      * @return boolean false if there is no only_db, otherwise true
 130      */
 131     protected function checkOnlyDatabase()
 132     {
 133         if (is_string($GLOBALS['cfg']['Server']['only_db'])
 134             && strlen($GLOBALS['cfg']['Server']['only_db']) > 0
 135         ) {
 136             $GLOBALS['cfg']['Server']['only_db'] = [
 137                 $GLOBALS['cfg']['Server']['only_db'],
 138             ];
 139         }
 140
 141         if (! is_array($GLOBALS['cfg']['Server']['only_db'])) {
 142             return false;
 143         }
 144
 145         $items = [];
 146
 147         foreach ($GLOBALS['cfg']['Server']['only_db'] as $each_only_db) {
 148             // check if the db name contains wildcard,
 149             // thus containing not escaped _ or %
 150             if (! preg_match('/(^|[^\\\\])(_|%)/', $each_only_db)) {
 151                 // ... not contains wildcard
 152                 $items[] = Util::unescapeMysqlWildcards($each_only_db);
 153                 continue;
 154             }
 155
 156             $items = array_merge($items, $this->retrieve($each_only_db));
 157         }
 158
 159         $this->exchangeArray($items);
 160
 161         return true;
 162     }
 163
 164     /**
 165      * returns default item
 166      *
 167      * @return string default item
 168      */
 169     public function getDefault()
 170     {
 171         if (strlen($GLOBALS['db']) > 0) {
 172             return $GLOBALS['db'];
 173         }
 174
 175         return $this->getEmpty();
 176     }
 177 }