<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 }
<?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']}");