Пример #1
0
     }
 }
 $sql = "SELECT idSender, idRecipient FROM `messages` WHERE idSender='" . $userId . "' GROUP BY idRecipient";
 $result = mysqli_query($link, $sql);
 while ($row = mysqli_fetch_assoc($result)) {
     $talkers[] = getUserDATA($row['idRecipient']);
 }
 $sql = "SELECT idSender, idRecipient FROM `messages` WHERE idRecipient='" . $userId . "' GROUP BY idSender";
 $result = mysqli_query($link, $sql);
 while ($row = mysqli_fetch_assoc($result)) {
     foreach ($talkers as $key => $value) {
         if ($value['idUser'] == $row['idSender']) {
             break;
         } else {
             if ($key == count($talkers)) {
                 $talkers[] = getUserDATA($row['idSender']);
             }
         }
     }
 }
 if (isset($_GET['id'])) {
     $sql = "SELECT * FROM `messages` WHERE (idSender='" . $userId . "' AND idRecipient='" . $idRecipient . "' ) OR (idSender='" . $idRecipient . "' AND idRecipient='" . $userId . "' ) order BY createDate";
     $result = mysqli_query($link, $sql);
     while ($row = mysqli_fetch_assoc($result)) {
         $messages[] = $row;
     }
     foreach ($messages as $key => &$message) {
         if ($message['idSender'] == $userId) {
             $message['avatar'] = $userData['avatar'];
         } else {
             $message['avatar'] = $recipient['avatar'];
Пример #2
0
<?php

include_once "config.php";
include_once "DB.php";
$user = getUserDATA($_GET['id']);
$user['gender'] = getUserGENDER($user['gender']);
$sql_info = "SELECT * FROM `friendsPair` WHERE `idSender` = '" . $user['idUser'] . "' \n\t\t\tOR `idRecipient` = '" . $user['idUser'] . "'";
$result = mysqli_query($link, $sql_info);
$user['numFriends'] = mysqli_num_rows($result);