/**
  * Konstruktor obiektu klasy model - logowanie się do bazy
  * 
  */
 function __construct()
 {
     $this->user = "******";
     $this->pass = "******";
     $this->db = "u3ponichtera";
     $this->host = "localhost";
     self::$db = new PDO("pgsql:dbname={$this->db};user={$this->user};password={$this->pass}");
     self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 }
Example #2
0
 /**
  *  Hooking test, update model2 when model1 changes
  */
 function model1_after_update($document, $object)
 {
     $m2 = new model2();
     $m2->update_refs($object);
 }
Example #3
0
<?php

//wyświetla baze
try {
    include "model2.php";
    $baza = new model2();
    $data = $baza->listAll();
    $response = '<table border="1">';
    if ($data) {
        foreach ($data as $row) {
            $response .= '<tr><td>' . htmlentities($row['tyt'], ENT_HTML5) . '</td><td>' . htmlentities($row['autn'], ENT_HTML5) . '</td><td>' . htmlentities($row['auti'], ENT_HTML5) . '</td><td>' . htmlentities($row['wyd'], ENT_HTML5) . '</td><td>' . htmlentities($row['rok'], ENT_HTML5) . '</td></tr>';
        }
    }
    $response .= '</table>';
    echo $response;
} catch (Exception $e) {
    echo 'Blad w saver_o: [' . $e->getCode() . '] ' . $e->getMessage();
}
Example #4
0
<?php

//zapis dla paczki kliku rekordów.
try {
    include "model2.php";
    $baza = new model2();
    $data = '';
    if (isset($_POST["data"])) {
        $data = "{\"tab\":[" . $_POST["data"] . "]}";
    }
    $obj = (array) json_decode($data, true);
    $response = '';
    foreach ($obj['tab'] as $value) {
        if (isset($obj->tyt) and isset($obj->autn) and isset($obj->auti) and isset($obj->wyd) and isset($obj->rok)) {
            $response = $baza->saveRec($value);
        }
    }
    echo $response ? "Dodano dane" : "Pusto ";
} catch (Exception $e) {
    echo 'Nie ma nic dodanego offline: [' . $e->getCode() . '] ' . $e->getMessage();
}
Example #5
0
<?php

try {
    include "model2.php";
    $baza = new model2();
    $baza->clearDB();
    header("location:index.php?sub=baza");
} catch (Exception $e) {
    echo 'Blad: [' . $e->getCode() . '] ' . $e->getMessage();
}
Example #6
0
 function __construct()
 {
     self::$db = new PDO(self::$dsn);
     self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 }
Example #7
0
<?php

try {
    //Mechanizm do zapisu danych do bazy.
    include "model2.php";
    $baza = new model2();
    $data = '';
    if (isset($_POST["data"])) {
        $data = $_POST["data"];
    }
    $obj = json_decode($data);
    $response = '';
    if (isset($obj->tyt) and isset($obj->autn) and isset($obj->auti) and isset($obj->wyd) and isset($obj->rok)) {
        $response = $baza->saveRec($obj);
    }
    echo $response ? "Dodano dane" : "Blad ";
} catch (Exception $e) {
    echo 'Blad: [' . $e->getCode() . '] ' . $e->getMessage();
}