예제 #1
0
파일: like.php 프로젝트: amriterry/ptn
 public static function likeToggle($postId, $userId)
 {
     $query = "SELECT * FROM `like` WHERE like.postId = '{$postId}' AND like.userId = '{$userId}'";
     $result = @mysql_query($query);
     if ($result != false) {
         $numLikeSel = mysql_num_rows($result);
         if ($numLikeSel != 1) {
             $insertQuery = "INSERT INTO `like` VALUES ('','{$postId}','{$userId}','1')";
             $insertResult = @mysql_query($insertQuery);
             if ($insertResult) {
                 return 'liked';
             } else {
                 return false;
             }
         } else {
             $liked = mysql_fetch_array($result);
             $checkLike = like::heckLike($postId, $userId);
             if ($checkLike == "liked") {
                 $updateStatus = 2;
                 $updateLike = 'unliked';
             } else {
                 $updateStatus = 1;
                 $updateLike = 'liked';
             }
             $likeId = $liked['likeId'];
             $updateQuery = "UPDATE `like` SET like.statusId = '{$updateStatus}' WHERE like.likeId = '{$likeId}'";
             $updateResult = @mysql_query($updateQuery);
             if ($updateResult) {
                 return $updateLike;
             } else {
                 return false;
             }
         }
     } else {
         return false;
     }
 }
예제 #2
0
파일: like.php 프로젝트: amriterry/ptn
<?php

require "../../includes/conf.inc.php";
require "../../includes/functions.inc.php";
if (isset($_POST['postId'], $_SESSION['userLogin'])) {
    $postId = intval($_POST['postId']);
    $userId = $_SESSION['userId'];
    $like = like::likeToggle($postId, $userId);
    if ($like != false) {
        echo $like;
    } else {
        echo false;
    }
}