function login()
{
if (!empty($_POST)) {
$check = new Check();
$user = new User();
$pdo = new Db();
$db = $pdo->get();
$mapper = new Mapper($db);
//Проверяем входные данные
$user->login = $check->checkInput($_POST['login']);
$password = $check->checkInput($_POST['pass']);
$user->password = md5($password);
//Если пользователь не найден
$this->user = $mapper->select($user);
if (empty($this->user)) {
$this->error = "Пароль или логин не совпадают";
$this->out('login.php');
} else {
$this->out('profile.php');
//Если найден, выводим профиль
}
} else {
$this->out('login.php');
}
}
/**
*
* @param boolean $all_
* @return stdClass
* @throws InvalidArgumentException
*/
public function selectTag($all_ = false)
{
try {
$where = null;
if (is_null($this->table)) {
throw new InvalidArgumentException('Attribute "table" can\'t be NULL !');
}
if (isset($this->id) && !is_null($this->id)) {
$where = 'id = ' . $this->id;
}
return parent::select($this->table, $where, $object = new Tag(), $all_);
} catch (InvalidArgumentException $e) {
print $e->getMessage();
exit;
}
}
/**
*
* @param boolean $all_
* @return stdClass
* @throws InvalidArgumentException
*/
public function selectIncoming($all_ = false)
{
try {
$where = null;
if (is_null($this->table)) {
throw new InvalidArgumentException('Attribute "table" can\'t be NULL !');
}
if (isset($this->foreignTable) && !is_null($this->foreignTable)) {
$fkName = 'id_' . strtolower($this->foreignTable->getTable());
$where = $fkName . ' = ' . $this->foreignTable->getId();
} elseif (isset($this->id) && !is_null($this->id)) {
$where = 'id = ' . $this->id;
}
return parent::select($this->table, $where, $object = new Incoming(), $all_);
} catch (InvalidArgumentException $e) {
print $e->getMessage();
exit;
}
}
<?php
$app->get('/', function () use($app) {
$main = 'active';
$add = '';
$pdo = new Db();
$db = $pdo->get();
$mapper = new Mapper($db);
$data = $mapper->select();
$dir = '';
return $app['twig']->render('index.twig', array('main' => $main, 'add' => $add, 'data' => $data, 'dir' => $dir));
})->bind('homepage');
$app->post('/', function () use($app) {
if (isset($_POST['likeOption']) || isset($_POST['dateOption'])) {
$main = 'active';
$add = '';
$pdo = new Db();
$db = $pdo->get();
$comments = new Comments();
$check = new Check();
if (isset($_POST['likeOption'])) {
$order = $check->checkInput(htmlspecialchars($_POST['likeOption']));
$comments->orderby = 'likes';
}
if (isset($_POST['dateOption'])) {
$order = $check->checkInput(htmlspecialchars($_POST['dateOption']));
$comments->orderby = 'date';
}
$mapper = new Mapper($db);
if ($order == 'ASC') {
$data = $mapper->searchAsc($comments);
public function getTags()
{
$tag = new Tag();
$where = 'id_announcement = ' . $this->getFirstId();
return parent::select('TO_ASSOCIATE', $where, $tag);
}
$add = '';
$pdo = new Db();
$db = $pdo->get();
$mapper = new Mapper($db);
$comments = new Comments();
$comments->id = $id;
$data = $mapper->selectId($comments);
if (empty($data)) {
$app->abort(404, "Comment {$id} does not exist.");
}
if ($id == 1) {
$first = 0;
} else {
$first = 1;
}
$all = count($mapper->select());
if ($id == $all) {
$last = 0;
} else {
$last = 1;
}
$next = $id + 1;
$previous = $id - 1;
$dir = '../';
if (isset($_POST['id'])) {
$itemid = $_POST['id'];
$ip_address = $_SERVER['REMOTE_ADDR'];
if (empty($app['session']->get($itemid))) {
$app['session']->set($itemid, array('ip' => $ip_address, 'likes' => 0));
$app['session.storage.options'] = ['cookie_lifetime' => 3600 * 7];
}