Exemple #1
0
 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;
     }
 }
Exemple #4
0
<?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);
 }
Exemple #6
0
 $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];
     }