Catching errors
I got an form sending to authorization.php
<form method="POST" action="components/authorization.php">
<div class="auth"></div>
<fieldset>
<label>Ïîëíûé èãðîâîé íèê</label>
<input type="text" id="eu_name"
name="eu_name" placeholder="Èãðîâîé íèê…">
<label>Íàçâàíèå Ñîöèóìà (Society)</label>
<input type="text" id="eu_society"
name="eu_society" placeholder="Ñîöèóì…">
<label>Äîïîëíèòåëüíàÿ èíôîðìàöèÿ</label>
<textarea class="textarea" id="eu_notes"
name="eu_notes"></textarea>
<label class="checkbox">
<input id="eu_want_team"
name="eu_want_team" type="checkbox"> Èùó
ëþäåé äëÿ êîìàíäíîé îõîòû
</label>
<input type="hidden" name="vk_id"
id="vk_id" value="<?php echo $viewer_id;
?>" />
<button type="submit" id="submit"
class="btn green">Îòïðàâèòü</button>
</fieldset>
</form>
Authorization.php contains an class which is taking post values and
inserting them into database.
require_once 'database.php';
class Authorization extends Database {
public $vk_id;
public $eu_name;
public $eu_society;
public $eu_notes;
public $eu_want_team;
public function __construct() {
parent::__construct('144.76.6.45','5432','eu','eu','eu123');
$this->vk_id = $_POST['vk_id'];
$this->eu_name = $_POST['eu_name'];
$this->eu_society = $_POST['eu_society'];
$this->eu_notes = $_POST['eu_notes'];
$this->eu_want_team = $_POST['eu_want_team'];
}
function querySelect($query) {
$this->query = $query;
$this->STH = $this->DBH->prepare($this->query);
$this->STH->execute();
$this->STH->setFetchMode(PDO::FETCH_ASSOC);
}
function queryInsert($query) {
$this->query = $query;
$this->STH = $this->DBH->prepare($this->query);
$this->STH->bindParam(':vk_id', $this->vk_id);
$this->STH->bindParam(':eu_name', $this->eu_name);
$this->STH->bindParam(':eu_society', $this->eu_society);
$this->STH->bindParam(':eu_notes', $this->eu_notes);
$this->STH->bindParam(':eu_want_team', $this->eu_want_team);
$this->STH->execute();
}
}
try {
$auth = new Authorization();
$auth->queryInsert('INSERT INTO users (vk_id, eu_name, eu_society,
eu_notes, eu_want_team) VALUES (:vk_id, :eu_name, :eu_society, :eu_notes,
:eu_want_team)');
$auth->DBH->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo 'Error: ' . $e->getMessage();
}
It doesnt works, i tried to catch the error by setting
$auth->DBH->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION) and
displaying $e->getMessage() but it doesnt display. I'll send variables via
ajax ofc, after solving this.
1) How to display errors? 2) Whats the problem in the code?
No comments:
Post a Comment