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]; }