Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.08 KB | None | 0 0
  1. <?php
  2. include("../Site/db.php");
  3.  
  4. $url = $_SERVER['REQUEST_URI'];
  5. $urlArray = explode('=',$url);
  6. $Username = $urlArray[sizeof($urlArray)-1];
  7.  
  8. $Myself = $_SESSION['username'];
  9.  
  10. $sql = "SELECT * FROM messages";
  11. $result = $conn->query($sql);
  12.  
  13. // Header of message box
  14. echo '<div id="messages" class="messagePersonBox shadow">
  15.         <span class="usersname" name="receiver"><a href="Account?='.$Username.'">'.$Username.'</a></span>
  16. <hr style="margin-top:24px">
  17. <div id="allMessages"class="allMessages">
  18. ';
  19.  
  20.  
  21.  
  22. $sql2 = "SELECT * FROM messages WHERE Receiver = '$Myself'";
  23. $result2 = $conn->query($sql2);
  24.  
  25. echo $sql2;
  26.  
  27. $sql3 = "SELECT * FROM messages WHERE Receiver = '$Myself'";
  28. $result3 = $conn->query($sql3);
  29.  
  30.     // output data of each row
  31.     while($row = $result->fetch_assoc()) {
  32.  
  33.   if($result2->num_rows > 0) {
  34.  
  35.             if($row = $result2->fetch_assoc()) {
  36.         $Sender = $row['Sender'];
  37.         $Message = $row['Message'];
  38.         $Receiver = $row['Receiver'];
  39.         $TimeSent = $row['MessageTime'];
  40.    
  41. }
  42. }
  43.  
  44.  
  45.  
  46.   if($result3->num_rows > 0) {
  47.  
  48.             if($row = $result3->fetch_assoc()) {
  49.         $Sender2 = $row['Sender'];
  50.         $Message2 = $row['Message'];
  51.         $Receiver2 = $row['Receiver'];
  52.         $TimeSent2 = $row['MessageTime'];
  53.    
  54. }
  55. }
  56.     // to get total messages
  57. $totalmessages = mysqli_num_rows($result);
  58. // For sender
  59.   if(isset($Message) && isset($TimeSent)){
  60.  
  61.     echo '<div id="messages2" class="messageDisplay">'.$Message.'<span style="float: right;margin-top:2px"><font size=1>'.time_elapsed_string($TimeSent).'</span></font></div>';
  62.  
  63.  
  64.  
  65.     }
  66. // For receiving
  67.       if(isset($Message2) && isset($TimeSent2)){
  68.  
  69.     echo '<div id="messages2" class="messageDisplay">'.$Message2.'<span style="float: right;margin-top:2px"><font size=1>'.time_elapsed_string($TimeSent2).'</span></font></div>';
  70.  
  71.  
  72.  
  73.     }
  74. }
  75.  
  76.  
  77.  
  78.  
  79.  
  80. // Typing part of message
  81. echo '</div>
  82. <input type="text" id="messagetosend" name="message" class="messagetype" placeholder="Type a message..."><span id="send" class="messageSend">↩</span>
  83.  
  84. </div>
  85.  
  86. ';
  87.  
  88.  
  89.  
  90. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement