Exemple #1
0
          </form>
           <?php 
        $likers = getlikers_str2($posts[$i]['id']);
        if (!strstr($likers, $_SESSION['login'])) {
            echo "<a href='model/posts.php?like=" . $posts[$i]['id'] . "'><div class='button like'> Like ? </div></a>";
        } else {
            echo "<a href='model/posts.php?dlike=" . $posts[$i]['id'] . "'><div class='button like'> Vous aimez ça ! </div></a>";
        }
    } else {
        echo "<p style='text-align:center;color:rgba(0,0,0,0.2);font-style:italic;font-size:0.8em;'> Connectez-vous pour commenter ou liker. </p>";
    }
    echo "</div></div>";
}
$prec = $page - 1;
$suiv = $page + 1;
$maxpage = nb_post() / 3;
echo "<span style='text-align: center; margin-bottom: 30px; width: 100%; height: 50px; display: block;'> ";
if ($prec > 0) {
    echo "<a href='index.php?page=" . $prec . "'> Precedent </a>";
}
echo "<span style='color: white;'> Page " . $page . "</span>";
if ($suiv < $maxpage) {
    echo "<a href='index.php?page=" . $suiv . "'> Suivant </a>";
}
echo "</span>";
?>
  </br>

</div>

Exemple #2
0
function get_toppost($page)
{
    $ttpost = nb_post();
    $nbpage = $ttpost / 3;
    $deb = $ttpost - $page * 3;
    include database;
    $result = $connection->prepare('SELECT * FROM post LIMIT ' . $deb . ', 3 ;');
    $result->execute();
    $posts = $result->fetchAll(PDO::FETCH_ASSOC);
    return $posts;
}