public function findAllComments() { $stmt = $this->dtb->prepare('SELECT * FROM comments'); $stmt->execute(); $data = array(); $UM = new PdoUserManager(); $PM = new PdoPostManager(); while ($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 findAllCommentsForPostId($pid) { $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(); while ($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; }
<?php require_once __DIR__ . '/classes/manager/PdoPostManager.class.php'; require_once __DIR__ . '/classes/entities/User.class.php'; session_start(); if (!isset($_SESSION['user'])) { header('Location: ./login.php'); } else { $PM = new PdoPostManager(); $post = $PM->findPostById($_GET['id']); ?> <!doctype html> <head> <title>Posts list</title> <meta charset="utf-8" /> </head> <body> <?php include './inc/menu.php'; ?> <h1><?php echo $post->getTitle(); ?> </h1> <em>by <?php echo $post->getUser()->firstname . ' ' . $post->getUser()->lastname; ?> on <?php echo date('d/m/Y H:i:s', $post->getPublicationDate()); ?>