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;
 }
Example #2
0
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>';
}