public function getFollowRequest(touitos $current, $demande) { $request = []; $q = $this->_db->prepare('SELECT * FROM touitos JOIN suivre ON suivre.idDemandeur=touitos.id WHERE idReceveur=:id AND demande=:demande'); $q->bindValue(':id', $current->getId(), PDO::PARAM_INT); $q->bindValue(':demande', $demande, PDO::PARAM_STR); $q->execute(); while ($donnees = $q->fetch(PDO::FETCH_ASSOC)) { $request[] = $donnees; } return $request; }
function gettouitosVignette($bd, touitos $touitos) { echo '<div class="touitosDiv"><a href="profile.php?user='******'">'; echo '<div class="result_photo">' . getPhoto($touitos, "search_result_profile_pic") . '</div>'; echo '<div class="result_details">'; echo '<div class="result_name">' . htmlentities($touitos->getNom()) . '</div>'; echo '<div class="result_pseudo">@' . htmlentities($touitos->getPseudo()) . '</div>'; echo '<div class="result_statut">' . htmlentities($touitos->getStatut()) . '</div>'; echo '</div>'; echo '</a>'; if (isset($_SESSION['user'])) { $th = new touitosHandler($bd); $connectedUSer = $th->getByAttr("pseudo", $_SESSION['user'], PDO::PARAM_STR); echo '<div class="subscribeDiv">' . getFollowButton($th, $connectedUSer, $touitos) . '</div>'; } echo '</div>'; }