Ejemplo n.º 1
0
      <img class="pic-galerie" src="../img/galerie/<?php 
        echo $img['name'];
        ?>
"/>
    </div>

    <div class="nb_like"> <!-- DIV POUR LE NOMBRE DE LIKE -->
      <?php 
        echo $img['likes'];
        ?>
    </div>

    <div class="uplike"> <!-- DIV POUR LIKER OU PAS ET SUPPRIMER -->
      <?php 
        // Si le user logué n'a pas encore liké la photo
        if (TcheckAlreadyLike($img["id"], $bdd)) {
            ?>
        <a href="../upvote.php?var=<?php 
            echo $img['id'];
            ?>
">J'aime</a>

      <?php 
        } else {
            ?>
        <a href="../downvote.php?var=<?php 
            echo $img['id'];
            ?>
">J'aime plus</a>
      <?php 
        }
Ejemplo n.º 2
0
<?php

session_start();
require_once 'config/database.php';
require_once 'function__.php';
$img_id = $_GET['var'];
$req_upvote = $bdd->prepare('SELECT likes FROM imgs WHERE id=:id');
$req_upvote->bindValue(':id', $img_id);
$req_upvote->execute();
$req_upvote->setFetchMode(PDO::FETCH_ASSOC);
$like = $req_upvote->fetchAll();
$uplike = $like[0]['likes'] += 1;
$req_upvote = $bdd->prepare('UPDATE imgs SET likes = likes + 1 WHERE id like :id');
$req_upvote->bindValue(':id', $img_id);
$req_upvote->execute();
if (TcheckAlreadyLike($img_id, $bdd)) {
    $req_add_like = $bdd->prepare('INSERT INTO likes_imgs (id_img, id_user) VALUES (:img_id, :user_id)');
    $req_add_like->execute(array('img_id' => $img_id, 'user_id' => $_SESSION['id']));
}
header("Location: {$_SERVER['HTTP_REFERER']}");