/** * it loads data about all servers, and return array of them * * @return array array of DatabaseServers */ public static function getServers() { self::setUpConnection(); $select = self::$db->select(); $databaseServer = new DatabaseServer(); $data = $select->From($databaseServer->getTableName())->query()->fetchAll(); $servers = array(); foreach ($data as $row) { $server = new DatabaseServer(); $server->setData($row); $servers[] = $server; } return $servers; }
/** * method bases on url server name and creates appropriate server object * * @param string $urlName * @return DatabaseServer */ public static function getServer($urlName) { self::setUpConnection(); $sampleServer = new DatabaseServer(); if (!is_null($urlName)) { $select = self::$db->select(); $data = $select->From($sampleServer->getTableName())->Where('urlName = ?', $urlName)->query()->fetch(); if ($data) { $server = new DatabaseServer(); $server->setData($data); return $server; } } //return default server $select = self::$db->select(); $data = $select->From($sampleServer->getTableName())->query()->fetch(); $server = new DatabaseServer(); $server->setData($data); return $server; }