<?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']);
$result2 = $cs3->getCommentByPostId($row1['post_id']);
foreach ($result2 as $row2) {
?>
<section class="w3-container w3-border">
<b><?php
print $row2['user'];
?>
: </b>
<?php
printf("%s <br/></section>", $row2['texts']);
?>
<div class="likes">
<?php
$id1 = $row2['comm_id'] . "c" . "b";
$idb1 = $row2['comm_id'] . "c";
$lp = new LikesPersist();
$count = $lp->isLikedByUser($row2['comm_id'], "c", $_SESSION['userid']);
$likesc = $pls->getTotalLikesId($row2['comm_id'], "c");
if ($count != 0) {
$val = "Unlike";
} else {
$val = "Like";
}
?>
<input type="button" id = "<?php
print $id1;
?>
" value= <?php
echo $val;
?>
onclick= "
