示例#1
0
 /**
  * Статическая функция, которая возвращает
  * экземпляр класса или создает новый при
  * необходимости
  *
  * @return DBH
  */
 public static function connDB()
 {
     // проверяем актуальность экземпляра
     if (null === self::$_DBH) {
         // создаем новый экземпляр
         self::$_DBH = new self();
     }
     // возвращаем созданный или существующий экземпляр
     return self::$_DBH;
 }
示例#2
0
 /**
  * @return PDO
  */
 public static function conn()
 {
     if (self::$conn === null) {
         try {
             self::$conn = new PDO("sqlsrv:Server=CODING-PRIMA\\SQLEXPRESS ; Database = tests ", "sa", "1195100038", array(PDO::SQLSRV_ATTR_DIRECT_QUERY => true));
         } catch (PDOException $e) {
             die('Database connection could not be established.');
         }
     }
     return self::$conn;
 }
示例#3
0
 public static function opretForbindelse()
 {
     if (DBH::$s_forb === NULL) {
         $forb = @new mysqli(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE);
         if (mysqli_connect_errno() !== 0) {
             $fejl = mysqli_connect_error();
             throw new DatabaseFejlException($fejl);
         }
         $forb->query('SET NAMES \'utf8\'');
         DBH::$s_forb = $forb;
     }
     return DBH::$s_forb;
 }
示例#4
0
<?php

$beerid = $_REQUEST['beerid'];
$usermgr = new UserManager();
$userid = $usermgr->sessionLoggedIn(session_id());
$conn = DBH::opretForbindelse();
$query = "SELECT * FROM beer WHERE userid = {$userid} AND tablebeerid = {$beerid}";
$result = $conn->query($query);
$aroma_1 = 61;
$udseende_1 = 62;
$smag_1 = 63;
$mundfylde_1 = 64;
$helhedsindtryk_1 = 65;
$aroma_2 = 71;
$udseende_2 = 72;
$smag_2 = 73;
$mundfylde_2 = 74;
$helhedsindtryk_2 = 75;
$aroma_3 = 81;
$udseende_3 = 82;
$smag_3 = 83;
$mundfylde_3 = 84;
$helhedsindtryk_3 = 85;
$definition = $result->fetch_assoc();
echo <<<htmltekst

<script type="text/javascript">
\$(function () {

    \$('#container').highcharts({
示例#5
0
    private function updateSessionActivity($in_sessid)
    {
        //
        // make sure we have a database connection.
        //
        $conn = DBH::opretForbindelse();
        try {
            $sessid = $this->escape_string($in_sessid);
            $querystr = <<<EOQUERY
UPDATE loggedinusers SET lastupdate = NOW()
  WHERE sessionid = '{$in_sessid}'
EOQUERY;
            $results = @$conn->query($querystr);
            if ($results === FALSE) {
                throw new DatabaseErrorException($conn->error);
            }
        } catch (Exception $e) {
            throw $e;
        }
    }
示例#6
0
    $config = dirname(__FILE__) . "/logmon.conf.php";
    $requiredConfigs = array($config);
    CheckConfig::configs($requiredConfigs);
    require_once $config;
    $requiredExtensions = array("mbstring", "pcre", "PDO");
    CheckConfig::extensions($requiredExtensions);
    mb_internal_encoding("UTF-8");
    Options::setDebug(DEBUG || array_search("--debug", $argv));
    Options::setPretend(array_search("--pretend", $argv));
    Options::setVerbose(Options::debug() || Options::pretend() || array_search("--verbose", $argv));
    Log::open(__FILE__, true, Options::verbose(), Options::debug());
    Log::notice(sprintf("Running '%s'...", implode(" ", $argv)));
    $monitor = Monitor::create(dirname(__FILE__) . "/monitor");
    if ($monitor !== false) {
        $sources = $monitor->getEnabledSources();
        $dbh = new DBH(DBDSN, DBUSER, DBPASS);
        $processor = new Processor($dbh);
        foreach ($sources as $source) {
            $processor->process($monitor, $source);
        }
        $processor->discard(EVENT_DISCARD_THRESHOLD);
        $status = 0;
    } else {
        $status = 1;
    }
} catch (Exception $e) {
    Log::err(sprintf("Log file processing failed with exception: %s\nDetails: %s", $e->getMessage(), $e));
    $status = 1;
}
if (isset($dbh)) {
    $dbh->close();
示例#7
0
 public function brewDelete($in_brewid)
 {
     $conn = DBH::opretForbindelse();
     try {
         $qstr = "DELETE FROM brew WHERE brew_id = {$in_brewid}";
         $result = @$conn->query($qstr);
         if ($result === FALSE) {
             throw new DatabaseErrorException($conn->error);
         }
     } catch (Exception $e) {
         if (isset($conn)) {
             $conn->close();
         }
         throw $e;
     }
     //
     // clean up and go home!
     //
     $conn->close();
 }
示例#8
0
 public function PostModel()
 {
     parent::DBH('post');
 }
示例#9
0
                 Log::warning("Ignoring invalid parameter '{$arg}'");
                 $argValue = false;
             }
         } else {
             Log::warning("Ingnoring unexpected parameter '{$arg}'");
         }
     }
     $argIndex++;
 }
 if ($argValue === false) {
     $argValue = 3600;
 }
 $grantedCount = 0;
 $deniedCount = 0;
 $errorCount = 0;
 $dbh = new DBH(DBDSN, DBUSER, DBPASS);
 $select = $dbh->prepare("SELECT typeid, count(typeid) FROM event WHERE last >= ? GROUP BY typeid");
 $select->bindValue(1, time() - $argValue, PDO::PARAM_INT);
 $select->execute();
 $select->bindColumn(1, $typeid, PDO::PARAM_STR);
 $select->bindColumn(2, $count, PDO::PARAM_INT);
 while ($select->fetch(PDO::FETCH_BOUND) !== false) {
     switch ($typeid) {
         case MonitorEvent::TYPEID_GRANTED:
             $grantedCount = $count;
             break;
         case MonitorEvent::TYPEID_DENIED:
             $deniedCount = $count;
             break;
         case MonitorEvent::TYPEID_ERROR:
             $errorCount = $count;
示例#10
0
 public function UserModel()
 {
     parent::DBH('user');
 }