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