<?php require 'database.php'; Database::setUsername('root'); Database::setPassword(''); Database::setHostname('localhost'); Database::setDatabase('test'); Database::setDBLink('default'); Database::connect(); $rowSingleAccount1 = Database::fetch("SELECT * FROM account WHERE id = :id", [['id', 1, 'int']]); $rowSingleAccount2 = Database::fetch("SELECT * FROM account WHERE id = :id", [['id', 1, 'int']]); echo '<pre>'; print_r($rowSingleAccount1); print_r($rowSingleAccount2); echo '</pre>'; $rowMultiAccount = Database::fetchAll("SELECT * FROM account"); echo '<pre>'; print_r($rowMultiAccount); echo '</pre>'; // $fullname = 'Peter'; // Database::exec("INSERT INTO account(fullname) // VALUES(:fullname)", [ // ['fullname', $fullname, 'str'] // ]); echo '<hr />'; echo '<pre>'; print_r(Database::getStatistics()); echo '</pre>';
<? $INC_PATH = "/home/imperial/domains/game.imperial-battle.com/private_html/includes_01/"; require($INC_PATH.'classes/class.database.php'); require($INC_PATH.'classes/class.user.php'); require($INC_PATH.'classes/class.battleenginecollection.php'); session_start(); require($INC_PATH.'config.inc.php'); require($INC_PATH.'functions.inc.php'); /* New database object */ $db = new Database; $db->setIP($dbconf['ip']); $db->setPort($dbconf['port']); $db->setUsername($dbconf['username']); $db->setPassword($dbconf['password']); $db->setDatabase($dbconf['database']); $db->connect(); $db->selectDatabase(); /* New user object */ if ((!$user) && (!$_SESSION['user'])) { $user = new User($table['players'], 'id', 'username', 'password', $db); $_SESSION['user'] = $user; } if (($_SESSION['user']) && (!$user)) { $user = $_SESSION['user']; } ?>
public function loadForSource($url) { $datasrc = dirname(dirname(__FILE__)) . '/Resources/data/databases/DataSources.xml'; if (extension_loaded('apc') && ini_get('apc.enabled')) { $xml = $this->loadFileFromCache($url); $simulator = new \SimpleXMLElement($xml, LIBXML_NOWARNING, false); $xml = $this->loadFileFromCache($datasrc); $datasources = new \SimpleXMLElement($xml, LIBXML_NOWARNING, false); } else { $simulator = new \SimpleXMLElement($url, LIBXML_NOWARNING, true); $datasources = new \SimpleXMLElement($datasrc, LIBXML_NOWARNING, true); } foreach ($datasources->DataSource as $datasource) { $datasourceObj = new DataSource($this, (int) $datasource['id'], (string) $datasource['name'], (string) $datasource['type']); $datasourceObj->setUri((string) $datasource['uri']); $datasourceObj->setMethod((string) $datasource['method']); $datasourceObj->setDatabase((int) $datasource['database']); $datasourceObj->setDescription((string) $datasource->Description); $this->datasources[] = $datasourceObj; } if ($datasources->Databases) { foreach ($datasources->Databases->Database as $database) { $databaseObj = new Database($this, (int) $database['id'], (string) $database['type'], (string) $database['name']); $databaseObj->setLabel((string) $database['label']); $databaseObj->setHost((string) $database['host']); $databaseObj->setPort((int) $database['port']); $databaseObj->setUser((string) $database['user']); if ((string) $database['password'] != '') { $databaseObj->setPassword((string) $database['password']); } elseif ((string) $database['user'] != '') { try { $user = $this->controller->get('kernel')->getContainer()->getParameter('database_user'); if ((string) $database['user'] == $user) { $databaseObj->setPassword($this->controller->get('kernel')->getContainer()->getParameter('database_password')); } } catch (\Exception $e) { } } $this->databases[] = $databaseObj; } } if ($simulator->DataSet) { foreach ($simulator->DataSet->children() as $child) { if ($child->getName() == "DataGroup") { foreach ($child->Data as $data) { $dataObj = new Data($this, (int) $data['id'], (string) $data['name']); $dataObj->setLabel((string) $data['label']); $dataObj->setType((string) $data['type']); $this->datas[] = $dataObj; } } elseif ($child->getName() == "Data") { $dataObj = new Data($this, (int) $child['id'], (string) $child['name']); $dataObj->setLabel((string) $child['label']); $dataObj->setType((string) $child['type']); $this->datas[] = $dataObj; } } } if ($simulator->Sources) { foreach ($simulator->Sources->Source as $source) { $sourceObj = new Source($this, (int) $source['id'], (string) $source['datasource'], (string) $source['returnType']); $sourceObj->setRequest((string) $source['request']); $sourceObj->setSeparator((string) $source['separator']); $sourceObj->setDelimiter((string) $source['delimiter']); $sourceObj->setReturnPath((string) $source['returnPath']); foreach ($source->Parameter as $parameter) { $parameterObj = new Parameter($sourceObj, (string) $parameter['type']); $parameterObj->setName((string) $parameter['name']); $parameterObj->setFormat((string) $parameter['format']); $parameterObj->setData((int) $parameter['data']); $sourceObj->addParameter($parameterObj); } $this->sources[] = $sourceObj; } } }
protected function getDatabase($datasource, $withDbName = true) { $dbid = (int) $datasource['database']; $databases = $this->datasources->xpath("/DataSources/Databases/Database[@id='" . $dbid . "']"); $dbtype = (string) $databases[0]['type']; $dbname = (string) $databases[0]['name']; $database = new Database(null, $dbid, $dbtype, $dbname); if ((string) $databases[0]['label'] != "") { $database->setLabel((string) $databases[0]['label']); } else { $database->setLabel($dbname); } if ((string) $databases[0]['host'] != "") { $database->setHost((string) $databases[0]['host']); } if ((string) $databases[0]['port'] != "") { $database->setPort((int) $databases[0]['port']); } if ((string) $databases[0]['user'] != "") { $database->setUser((string) $databases[0]['user']); } if ((string) $databases[0]['password'] != "") { $database->setPassword((string) $databases[0]['password']); } elseif ((string) $databases[0]['user'] != "") { try { $user = $this->parameters['database_user']; if ((string) $databases[0]['user'] == $user) { $database->setPassword($this->parameters['database_password']); } } catch (\Exception $e) { } } $database->connect($withDbName); return $database; }