public function getNotify($id_to) { if (empty(self::$conn)) { self::$conn = $this->connectPdo(); } $sql = "SELECT distinct n.id,id_from,id_to,u.username,u2.username,content,time_on\r\n FROM notify AS n\r\n LEFT JOIN user AS u ON u.id=n.id_from\r\n LEFT JOIN user AS u2 ON u2.id=n.id_to\r\n WHERE id_to=? ORDER BY n.time_on DESC"; $stmt = self::$conn->prepare($sql); $stmt->bindParam(1, $id_to); $stmt->execute(); $stmt->setFetchMode(PDO::FETCH_ASSOC); $i = 0; $notify = array(array()); while ($row = $stmt->fetch()) { $notify[$i++] = $row; } $i--; return $notify; }
<?php session_start(); include_once '../model/comment_model.php'; include_once '../model/diary_model.php'; include_once '../model/user_model.php'; include_once '../model/notify_model.php'; include_once '../model/friend_model.php'; include_once '../model/like_model.php'; $l = new LikeModel(); $t = new DiaryModel(); $c = new CommentModel(); $u = new UserModel(); $n = new NotifyModel(); $m = new NotifyModel(); $f = new FriendModel(); $button = ''; $p = 0; $onclick1 = ''; $user_page = $u->getUser($_GET['user_id']); if ($f->checkUserId($_SESSION['id'], $user_page['id'])) { $a = $f->getFlagFriend($_SESSION['id'], $user_page['id']); $flag['flag'] = $a['flag']; } if ($f->checkUserId($user_page['id'], $_SESSION['id'])) { $b = $f->getFlagFriend($user_page['id'], $_SESSION['id']); if ($b['flag'] == 2) { $flag['flag'] = 3; } } if (!$f->checkUserId($_SESSION['id'], $user_page['id']) && !$f->checkUserId($user_page['id'], $_SESSION['id'])) {
<?php // bai dang lay tu thong bao session_start(); include '../model/diary_model.php'; include '../model/comment_model.php'; include '../model/notify_model.php'; include '../model/user_model.php'; include '../model/like_model.php'; include '../model/friend_model.php'; $f = new FriendModel(); $l = new LikeModel(); $t = new DIaryModel(); $c = new CommentModel(); $n = new NotifyModel(); $m = new NotifyModel(); $u = new userModel(); $diary_id = $_GET['diary_id']; $diary = $t->getDiary($diary_id); $id_notify = $_GET['id_nf']; $m->notifyReed($id_notify); include 'header.php'; $i = 0; ?> </div> </div> <div class="container"> <?php if ($diary == NULL) { echo '<div class="well">'; echo 'bai dang khong hop le </div>';
<?php include_once '../model/notify_model.php'; $m = new NotifyModel(); $notyfy_type = $_GET['notify_type']; $page_id = $_GET['page_id']; $id_nf = $_GET['id_nf']; $flag['flag'] = 3; $m->notifyReed($id_nf); if ($notyfy_type == 1) { $url = 'baidang.php?diary_id=' . $page_id . '&id_nf=' . $id_nf; } if ($notyfy_type == 2) { $user2 = $page_id; //include '../controler/check_friend'; $url = 'page_user.php?user_id=' . $page_id . '&friend=' . $flag['flag']; } header('Location:' . $url);
session_start(); include '../model/diary_model.php'; include '../model/comment_model.php'; include '../model/notify_model.php'; include '../model/user_model.php'; include '../model/like_model.php'; include '../model/friend_model.php'; $f = new FriendModel(); $l = new LikeModel(); $t = new DIaryModel(); $diary = array(array()); $diary = $t->getDiaryOfUserfriend($_SESSION['id']); $c = new CommentModel(); $n = new NotifyModel(); $m = new NotifyModel(); $u2 = new UserModel(); $u = new UserModel(); $typeseach = $_GET['type']; ?> <?php //include_once 'header.php'; ?> <!DOCTYPE html> <html lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <title>My Diary</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">