public function save() { $pdo_connection = DB::connection(); $success = true; //the begin of transaction $pdo_connection->beginTransaction(); try { $query = $pdo_connection->prepare("INSERT INTO saalistieto (pvm, kellonaika," . " kalalaji, lkm, pituus, paino, vesisto, paikka, tuulenvoimakkuus," . " tuulensuunta, ilmanlampo, vedenlampo, pilvisyys, huomiot," . " saaliskuva, pyydys) VALUES(:pvm, NULLIF(:aika,'')::time, :laji, :lkm," . " NULLIF(:pituus,'')::numeric, NULLIF(:paino,'')::numeric, :vesisto," . " :paikka, :tuulenVoima, :tuulenSuunta," . " NULLIF(:ilmanLampo,'')::integer, NULLIF(:vedenLampo,'')::integer, :pilvisyys," . " :huomiot, :kuva, NULLIF(:pyydys,'default')::integer) RETURNING saalisid"); $query->execute(array('pvm' => $this->date, 'aika' => $this->time, 'laji' => $this->species, 'lkm' => $this->count, 'pituus' => $this->length, 'paino' => $this->weight, 'vesisto' => $this->water_sys, 'paikka' => $this->location, 'tuulenVoima' => $this->wind_speed, 'tuulenSuunta' => $this->wind_dir, 'ilmanLampo' => $this->air_temp, 'vedenLampo' => $this->water_temp, 'pilvisyys' => $this->cloudiness, 'huomiot' => $this->notes, 'kuva' => $this->picture_url, 'pyydys' => $this->trap_id)); $resultRow = $query->fetch(); $this->catch_id = $resultRow['saalisid']; $catchers; $username = array($_SESSION['user']); if (isset($this->friends)) { $catchers = array_merge($username, $this->friends); } else { $catchers = $username; } $query_2 = $pdo_connection->prepare("INSERT INTO pyydystaja VALUES(" . ":kalastaja, :saalisid)"); foreach ($catchers as $catcher) { $query_2->execute(array('kalastaja' => $catcher, 'saalisid' => $this->catch_id)); } } catch (PDOException $e) { $success = false; Kint::dump($e); Kint::trace(); } //end of transaction if (!$success) { $pdo_connection->rollBack(); } else { $pdo_connection->commit(); } }
public function save() { $query = DB::connection()->prepare('INSERT INTO Hero (name, primaryattribute, attacktype, primaryrole, damagetype, description) VALUES(:name, :primaryattribute, :attacktype, :primaryrole, :damagetype, :description) RETURNING id'); $query->execute(array('name' => $this->name, 'primaryattribute' => $this->primaryattribute, 'attacktype' => $this->attacktype, 'primaryrole' => $this->primaryrole, 'damagetype' => $this->damagetype, 'description' => $this->description)); $row = $query->fetch(); Kint::trace(); Kint::dump($row); }
public function save() { $query = DB::connection()->prepare('INSERT INTO Aanestys (nimi, aanestysalkaa, aanestysloppuu, kuvaus, onkoid, luojaid) VALUES (:nimi, :aanestysalkaa, :aanestysloppuu, :kuvaus, :onkoid, :luojaid) RETURNING id'); $query->execute(array('nimi' => $this->nimi, 'aanestysalkaa' => $this->aanestysalkaa, 'aanestysloppuu' => $this->aanestysloppuu, 'kuvaus' => $this->kuvaus, 'onkoid' => $this->onkoid, 'luojaid' => $this->luojaid)); $row = $query->fetch(); $this->id = $row['id']; Kint::trace(); Kint::dump($row); }
/** Prints stack trace if in developer mode or force flag set * * @param bool $force Force dumping? * * @return mixed Returns true if trace printed successfully, false otherwise. */ public function trace($force = false) { if ($force or $this->developerMode) { Kint::trace(); return true; } else { return false; } }
public function update() { $query = DB::connection()->prepare('UPDATE Requests (name, description, hashtags) VALUES (:name, :start_date, :end_date, :description, :hashtags) RETURNING id'); $query->execute(array('name' => $this->name, 'description' => $this->description, 'hashtags' => $this->hashtags)); $row = $query->fetch(); Kint::trace(); Kint::dump($row); $this->id = $row['id']; }
public function update() { // JUPDATE:ssa joku vika?? $query = DB::connection()->prepare('INSERT INTO Waybill (customer_id, receiver_id, arrived) VALUES ( :customer_id, :receiver_id, :arrived) RETURNING id'); $query->execute(array('customer_id' => $this->customer_id, 'receiver_id' => $this->receiver_id, 'arrived' => $this->arrived, 'id' => $this->id)); $row = $query->fetch(); Kint::trace(); Kint::dump($row); $this->id = $row['id']; }
public function save() { $query = DB::connection()->prepare('INSERT INTO Task (description, status, created, person, priority, projectids) VALUES (:description, :status, :created, :person, :priority, :projectids) RETURNING id'); // Get the id of the row via RETURNING id $query->execute(array('description' => $this->description, 'status' => $this->status, 'created' => date("Y-m-d"), 'person' => $_SESSION['user'], 'priority' => $this->priority, 'projectids' => implode(",", $this->projectids))); $row = $query->fetch(); // fetch the row so we get the id Kint::trace(); Kint::dump($row); // row is false if nothing comes back from db, perhaps from wrong input type $this->id = $row['id']; // commented out for debugging }
public function save() { // Lisätään RETURNING id tietokantakyselymme loppuun, niin saamme lisätyn rivin id-sarakkeen arvon $query = DB::connection()->prepare('INSERT INTO Resepti (reseptin_nimi, annokset, valmisteluaika, kypsymisaika, uunin_asteet, valmistusohje, laatija) VALUES (:reseptin_nimi, :annokset, :valmisteluaika, :kypsymisaika, :uunin_asteet, :valmistusohje, :laatija) RETURNING id'); // Muistathan, että olion attribuuttiin pääse syntaksilla $this->attribuutin_nimi $query->execute(array('reseptin_nimi' => $this->reseptin_nimi, 'annokset' => $this->annokset, 'valmisteluaika' => $this->valmisteluaika, 'kypsymisaika' => $this->kypsymisaika, 'uunin_asteet' => $this->uunin_asteet, 'valmistusohje' => $this->valmistusohje, 'laatija' => $this->laatija)); // Haetaan kyselyn tuottama rivi, joka sisältää lisätyn rivin id-sarakkeen arvon $row = $query->fetch(); Kint::trace(); Kint::dump($row); // Asetetaan lisätyn rivin id-sarakkeen arvo oliomme id-attribuutin arvoksi // Kint::trace(); // Kint::dump($row); $this->id = $row['id']; }
/** * Dummy method that triggers trace */ public function ensure() { Kint::trace(); }
public static function kintException($oException) { \Kint::dump($oException); \Kint::trace($oException->getTrace()); }
/** * Errors handler. * * @author Krzysztof Trzos * @param integer $errno * @param string $errstr * @param string $errfile * @param integer $errline * @param array $errcontext * @throws Exception\Fatal * @since 1.0.0-alpha * @version 1.0.0-alpha */ function error_handler($errno, $errstr, $errfile = '', $errline = 0, $errcontext = []) { $iLevel = ob_get_level(); for ($i = 1; $i < $iLevel; $i++) { ob_get_clean(); } if (Core::getAppMode() == Core::MODE_DEVELOPMENT) { \Kint::trace(); ddd($errno, $errstr, $errfile, $errline, $errcontext); } else { try { throw new Exception\Fatal(); } catch (Exception $e) { $e->handler(); } } }
public static function logout() { Kint::trace(); $_SESSION['user'] = null; Redirect::to('/login', array('message' => 'Olet kirjautunut ulos!')); }