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 namespace PhpMyAdmin;
   9
  10 use PhpMyAdmin\ListAbstract;
  11 use PhpMyAdmin\Util;
  12
  13 require_once './libraries/check_user_privileges.inc.php';
  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         $this->build();
  36     }
  37
  38     /**
  39      * checks if the configuration wants to hide some databases
  40      *
  41      * @return void
  42      */
  43     protected function checkHideDatabase()
  44     {
  45         if (empty($GLOBALS['cfg']['Server']['hide_db'])) {
  46             return;
  47         }
  48
  49         foreach ($this->getArrayCopy() as $key => $db) {
  50             if (preg_match('/' . $GLOBALS['cfg']['Server']['hide_db'] . '/', $db)) {
  51                 $this->offsetUnset($key);
  52             }
  53         }
  54     }
  55
  56     /**
  57      * retrieves database list from server
  58      *
  59      * @param string $like_db_name usually a db_name containing wildcards
  60      *
  61      * @return array
  62      */
  63     protected function retrieve($like_db_name = null)
  64     {
  65         $database_list = array();
  66         $command = "";
  67         if (! $GLOBALS['cfg']['Server']['DisableIS']) {
  68             $command .= "SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`";
  69             if (null !== $like_db_name) {
  70                 $command .= " WHERE `SCHEMA_NAME` LIKE '" . $like_db_name . "'";
  71             }
  72         } else {
  73             if ($GLOBALS['dbs_to_test'] === false || null !== $like_db_name) {
  74                 $command .= "SHOW DATABASES";
  75                 if (null !== $like_db_name) {
  76                     $command .= " LIKE '" . $like_db_name . "'";
  77                 }
  78             } else {
  79                 foreach ($GLOBALS['dbs_to_test'] as $db) {
  80                     $database_list = array_merge(
  81                         $database_list, $this->retrieve($db)
  82                     );
  83                 }
  84             }
  85         }
  86
  87         if ($command) {
  88             $database_list = $GLOBALS['dbi']->fetchResult(
  89                 $command, null, null
  90             );
  91         }
  92
  93         if ($GLOBALS['cfg']['NaturalOrder']) {
  94             usort($database_list, 'strnatcasecmp');
  95         } else {
  96             // need to sort anyway, otherwise information_schema
  97             // goes at the top
  98             sort($database_list);
  99         }
 100
 101         return $database_list;
 102     }
 103
 104     /**
 105      * builds up the list
 106      *
 107      * @return void
 108      */
 109     public function build()
 110     {
 111         if (! $this->checkOnlyDatabase()) {
 112             $items = $this->retrieve();
 113             $this->exchangeArray($items);
 114         }
 115
 116         $this->checkHideDatabase();
 117     }
 118
 119     /**
 120      * checks the only_db configuration
 121      *
 122      * @return boolean false if there is no only_db, otherwise true
 123      */
 124     protected function checkOnlyDatabase()
 125     {
 126         if (is_string($GLOBALS['cfg']['Server']['only_db'])
 127             && strlen($GLOBALS['cfg']['Server']['only_db']) > 0
 128         ) {
 129             $GLOBALS['cfg']['Server']['only_db'] = array(
 130                 $GLOBALS['cfg']['Server']['only_db']
 131             );
 132         }
 133
 134         if (! is_array($GLOBALS['cfg']['Server']['only_db'])) {
 135             return false;
 136         }
 137
 138         $items = array();
 139
 140         foreach ($GLOBALS['cfg']['Server']['only_db'] as $each_only_db) {
 141
 142             // check if the db name contains wildcard,
 143             // thus containing not escaped _ or %
 144             if (! preg_match('/(^|[^\\\\])(_|%)/', $each_only_db)) {
 145                 // ... not contains wildcard
 146                 $items[] = Util::unescapeMysqlWildcards($each_only_db);
 147                 continue;
 148             }
 149
 150             $items = array_merge($items, $this->retrieve($each_only_db));
 151         }
 152
 153         $this->exchangeArray($items);
 154
 155         return true;
 156     }
 157
 158     /**
 159      * returns default item
 160      *
 161      * @return string default item
 162      */
 163     public function getDefault()
 164     {
 165         if (strlen($GLOBALS['db']) > 0) {
 166             return $GLOBALS['db'];
 167         }
 168
 169         return $this->getEmpty();
 170     }
 171 }