Revize 574d6347

#6345: Realizace databaze

Pridany tridy zajistujici komunikaci s databazi.

cron/dao/dao.php

@@ +1 @@
+<?php
+
+require_once "db/db-web.php";
+
+class DAO {
+  
+    protected $dbh;
+    
+    public function setDB($dbh) {
+        $this->dbh = $dbh;
+    }
+    
+}
+
+?>

cron/db/db-exception.php

@@ +1 @@
+<?php
+
+class DB_Exception extends Exception {
+    
+    public function __construct($message = false, $code = false) {
+        if (!$message) {
+            $this->message = mysql_error();
+        } 
+        if (!$code) {
+            $this->code = mysql_errno();
+        }
+    }
+    
+}
+
+?>

cron/db/db-pdo.php

@@ +1 @@
+<?php
+
+require_once "db-exception.php";
+
+class DB_PDO {
+  
+    protected $user;
+    protected $pass;
+    protected $dbhost;
+    protected $dbname;
+    protected $dbh;
+  
+    public function __construct($user, $pass, $dbhost, $dbname) {
+        $this->user = $user;
+        $this->pass = $pass;
+        $this->dbhost = $dbhost;
+        $this->dbname = $dbname;
+    }
+  
+    protected function connect() {
+        $this->dbh = new PDO("mysql:host=".$this->dbhost.";dbname=".$this->dbname.";charset=utf8", $this->user, $this->pass);
+        if (!$this->dbh) {
+            throw new DB_Exception;
+        }
+    }
+  
+    public function executeQuery($query) {
+        if (!$this->dbh) {
+            $this->connect();
+        }
+        $ret = $this->dbh->query($query);
+        if (!$ret) {
+            throw new DB_Exception;
+        } else {
+            $stmt = new DB_PDOStatement($this->dbh, $query);
+            $stmt->result = $ret;
+            $stmt->number = $ret->rowCount();
+            return $stmt;
+        }
+    }
+      
+}
+
+class DB_PDOStatement {
+    
+    public $result;
+    public $query;
+    public $number;
+    protected $dbh;
+  
+    public function __construct($dbh, $query) {
+        $this->query = $query;
+        $this->dbh = $dbh;
+        if (!$dbh) {
+            throw new DB_Exception("Spojení s databází se nezdařilo!");
+        }
+    }
+  
+    public function fetchAssoc() {
+        if (!$this->result) {
+            throw new DB_Exception("Dotaz nebyl vykonán!");
+        }
+        return $this->result->fetch(PDO::FETCH_ASSOC);
+    }
+    
+}
+
+?>

cron/db/db-web.php

@@ +1 @@
+<?php
+
+require_once "db-pdo.php";
+
+class DB_WEB extends DB_PDO {
+  
+    protected $user = "root";
+    protected $pass = "";
+    protected $dbhost = "localhost";
+    protected $dbname = "prujezd_vozidel";
+  
+    public function __construct() {
+    }
+     
+}
+
+?>