<?php session_start(); include 'Post_likes.php'; include 'LikesPersist.php'; include 'Connection.php'; try { $pl = new Post_likes(NULL, $_GET['eid'], $_GET['etype'], $_SESSION['userid']); $pls = new LikesPersist(); if ($_GET['btype'] == 'l') { $pls->save($pl); } else { $pls->delete($pl); } //$query1 = $DBH->prepare("UPDATE posts SET likes = likes+1 where post_id = :post_id"); $count = $pls->getTotalLikesId($pl->eid, $pl->eType); print " {$count} people like it!"; /*$query3 = $DBH->prepare("UPDATE posts SET likes = :likes where post_id = :post_id"); $varq3 = array('likes' => $count, 'post_id' => $_GET['pid']); $query3->execute($varq3);*/ /*$query2 = $DBH->prepare("UPDATE posts SET likes = ( SELECT COUNT(rid) FROM post_likes WHERE posts.post_id = post_likes.post_id) WHERE post_id = :post_id" ); $varq2 = array('post_id' => $_GET['pid']); $query2->execute($varq2); */ /*$query4 = $DBH->prepare("SELECT likes FROM posts where post_id = :post_id"); $varq4 = array('post_id' => $_GET['pid']);
?> <div class="w3-container w3-padding-32 w3-teal"> <b><?php print $user; ?> says:</b> <br/> <?php print $row1['time']; ?> </div> <section class="w3-container w3-border"> <p> <?php printf("%s</p></section> ", $row1['texts']); $pls = new LikesPersist(); $likes = $pls->getTotalLikesId($row1['post_id'], "p"); ?> <div class="likes"> <p>Post:<?php print $row1['post_id']; ?> </p> <?php $id1 = $row1['post_id'] . "p" . "b"; $idb1 = $row1['post_id'] . "p"; $lp = new LikesPersist(); $count = $lp->isLikedByUser($row1['post_id'], "p", $_SESSION['userid']); if ($count != 0) { $value = "Unlike"; } else {