public function findPostById($id) { $um = new PdoUserManager(); $stmt = self::$dtb->query('SELECT * FROM posts WHERE id = ' . intval($id)); $data = $stmt->fetch(PDO::FETCH_OBJ); $data = new Post($data->id, $data->title, $data->body, $data->publicationDate, $um->findUserById($data->userID)); $stmt->closeCursor(); return $data; }
public function findPostById($id) { $stmt = $this->dtb->prepare('SELECT * FROM posts WHERE id = :id'); $stmt->bindValue(':id', $id, PDO::PARAM_INT); $stmt->execute(); $UM = new PdoUserManager(); $CM = new PdoCommentManager(); $d = $stmt->fetch(PDO::FETCH_OBJ); $data = new Post($d->id, $d->title, $d->body, $d->publicationDate, $UM->findUserById($d->userID), $CM->findAllCommentsForPostId($d->id)); $stmt->closeCursor(); return $data; }
public function findCommentById($id) { $stmt = $this->dtb->prepare('SELECT * FROM comments WHERE postID = :pid'); $stmt->bindValue(':pid', $pid, PDO::PARAM_INT); $stmt->execute(); $data = array(); $um = new PdoUserManager(); $pm = new PdoPostManager(); $d = $stmt->fetch(PDO::FETCH_OBJ); $c = new Comment(); $c->setId($d->id); $c->setBody($d->body); //$c->setPost($pm->findPostById($d->postID)); $c->setUser($um->findUserById($d->userID)); $c->setPublicationDate($d->publicationDate); $data[] = $c; $stmt->closeCursor(); return $data; }
public function __construct() { if (is_null(self::$dtb)) { self::$dtb = new PDO(DB_DSN, DB_USER, DB_PASSWD); } }
<?php require __DIR__ . '/classes/manager/PdoUserManager.class.php'; session_start(); if (isset($_POST['login']) && isset($_POST['password'])) { $UM = new PdoUserManager(); $user = $UM->authenticate($_POST['login'], $_POST['password']); if ($user !== false) { $_SESSION['user'] = $user; header('Location: ./postList.php'); } } ?> <!doctype html> <head> <title>Login</title> </head> <body> <h1>Login Page</h1> <form action="#" method="post"> <label for="login">Login:</label> <input type="text" id="login" name="login" value="" /> <br /> <label for="password">Password:</label> <input type="password" id="password" name="password" value="" /> <br /> <br /> <input type="submit" value="Se connecter" /> </form> </body>