PHP DBConnect::initDatabaseFromXML Examples

Example #1

File: Administrator.php Project: babesk/babesk

    /**
     * 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.");
        }
    }

Example #2

File: databaseDistributor.php Project: Auwibana/babesk

<?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();

Example #3

File: Web.php Project: Auwibana/babesk

    /**
     * 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!');
        }
    }

Example #4

File: functions.php Project: Auwibana/babesk

/**
 * 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&section=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '"><<</a>&nbsp;&nbsp;';
        $string .= '<a href="?sitePointer=' . ($showPage - 1) . '&section=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '"><</a>&nbsp;&nbsp;';
    }
    for ($x = $showPage - 5; $x <= $showPage + 5; $x++) {
        if ($x > 0 && $x < $showPage || $x > $showPage && $x <= $maxPages) {
            $string .= '<a href="?sitePointer=' . $x . '&section=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '">' . $x . '</a>&nbsp;&nbsp;';
        }
        if ($x == $showPage) {
            $string .= $x . '&nbsp;&nbsp;';
        }
    }
    if ($showPage < $maxPages) {
        $string .= '<a href="?sitePointer=' . ($showPage + 1) . '&section=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '">></a>&nbsp;&nbsp;';
        $string .= '<a href="?sitePointer=' . $maxPages . '&section=' . $headmod . '|' . $mod . '&filter=' . $filter . '&action=' . $action . '">>></a>&nbsp;&nbsp;';
    }
    return $string;
}

Example #5

File: TableMng.php Project: Auwibana/babesk

 /**
  * 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";');
     }
 }