コード例 #1
0
ファイル: like_question.php プロジェクト: Gameonn/competition
 } catch (Exception $e) {
 }
 $likes = $sth->fetchAll();
 if (count($likes)) {
     $sql = "delete from likes where user_id=:uid and question_id=:question_id";
     $sth = $conn->prepare($sql);
     $sth->bindValue('uid', $uid);
     $sth->bindValue('question_id', $question_id);
     try {
         $sth->execute();
         $success = "1";
         $msg = "Question Unliked";
     } catch (Exception $e) {
     }
 } else {
     $user = GeneralFunctions::get_user_ids($question_id);
     $apnid = $user[0]['apn_id'];
     $question_title = $user[0]['title'];
     $oid = $user[0]['id'];
     $message = array();
     $message['msg'] = $uname . ' liked your question';
     $message['type'] = 1;
     //like
     $type = 'like';
     $sql = "Insert into likes(id,user_id,question_id,created_on) values(DEFAULT,:uid,:question_id,NOW())";
     $sth = $conn->prepare($sql);
     $sth->bindValue('uid', $uid);
     $sth->bindValue('question_id', $question_id);
     try {
         $sth->execute();
         $like_id = $conn->lastInsertId();