/** * Initializes the PDO-Object, used for Database-Queries * * triggers an error when */ private function initDatabaseConnections() { try { $connector = new DBConnect(); $connector->initDatabaseFromXML(); $this->_pdo = $connector->getPdo(); $this->_em = $connector->getDoctrineEntityManager(); $this->_pdo->query('SET @activeSchoolyear := (SELECT ID FROM SystemSchoolyears WHERE active = "1" LIMIT 1); '); } catch (PDOException $e) { echo $e->getMessage(); die("Sorry, could not connect to the database with pdo."); } }
<?php /** * This file is outdated, but still needed by parts of the program * They use "global $db" to get access to the database * @todo: Remove this file and replace the occurences with DBConnect.php and the Class DBConnect */ require_once dirname(__FILE__) . '/DBConnect.php'; // $dbObject = new DBConnect($host, $username, $password, $database); $dbObject = new DBConnect(); $dbObject->initDatabaseFromXML(); $db = $dbObject->getDatabase();
/** * Initializes the PDO-Object, used for Database-Queries * * triggers an error when the PDO-Object could not be created */ private function initDatabaseConnections() { try { $connector = new DBConnect(); $connector->initDatabaseFromXML(); $this->_pdo = $connector->getPdo(); $this->_em = $connector->getDoctrineEntityManager(); $this->_pdo->query('SET @activeSchoolyear := (SELECT ID FROM SystemSchoolyears WHERE active = "1");'); } catch (Exception $e) { trigger_error('Could not create the PDO-Object!'); } }
/** * Enter description here... */ function navBar($showPage, $table, $headmod, $mod, $action, $filter) { require_once 'sql_access/DBConnect.php'; $dbObject = new DBConnect(); $dbObject->initDatabaseFromXML(); $db = $dbObject->getDatabase(); $db->query('set names "utf8";'); $query = sql_prev_inj(sprintf('SELECT COUNT(*) AS total FROM %s', $table)); $result = $db->query($query); if (!$result) { throw new Exception('Fehler: Nichts gefunden!'); } $row = $result->fetch_array(MYSQLI_ASSOC); $maxPages = ceil($row['total'] / 10); $string = ""; if ($showPage > 1) { $string .= '<a href="?sitePointer=1§ion=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '"><<</a> '; $string .= '<a href="?sitePointer=' . ($showPage - 1) . '§ion=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '"><</a> '; } for ($x = $showPage - 5; $x <= $showPage + 5; $x++) { if ($x > 0 && $x < $showPage || $x > $showPage && $x <= $maxPages) { $string .= '<a href="?sitePointer=' . $x . '§ion=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '">' . $x . '</a> '; } if ($x == $showPage) { $string .= $x . ' '; } } if ($showPage < $maxPages) { $string .= '<a href="?sitePointer=' . ($showPage + 1) . '§ion=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '">></a> '; $string .= '<a href="?sitePointer=' . $maxPages . '§ion=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '">>></a> '; } return $string; }
/** * Inits the Database of this Class */ protected static function dbInit() { if (!isset(self::$db)) { $dbObject = new DBConnect(); $dbObject->initDatabaseFromXML(); self::$db = $dbObject->getDatabase(); self::$db->query('set names "utf8";'); } }