<?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 {
