/** * 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); }
/** * Hooking test, update model2 when model1 changes */ function model1_after_update($document, $object) { $m2 = new model2(); $m2->update_refs($object); }
<?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(); }
<?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(); }
<?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(); }
function __construct() { self::$db = new PDO(self::$dsn); self::$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); }
<?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(); }