bloggr/user.php at master · dfhalimi/bloggr · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<?php
    include_once "includes/user.inc.php";
    include_once "header.php";
?>

    <h1 class="posts-overview"><?php echo $_REQUEST['user'];?>'s Posts</h1>
    <?php
    if (isset($_REQUEST['user'])) {
      if (mysqli_num_rows($query) > 0) {
          foreach ($query as $q) {
    ?>
      <div class="post">
        <h1><?php echo $q['title'];?></h1>
        <div class="post-info">
          <div class="profile-pic">
            <a href="user.php?user=<?php echo $q['author'];?>">
              <?php
                  $sqlUser = "SELECT * FROM users WHERE usersUid = '$q[author]';";
                  $queryUser = mysqli_query($conn, $sqlUser);
                  foreach ($queryUser as $qUser) {
                    $sqlImg = "SELECT * FROM profileimg WHERE usersId = '$qUser[usersId]';";
                    $resultImg = mysqli_query($conn, $sqlImg);
                    while ($rowImg = mysqli_fetch_assoc($resultImg)) {
                      if ($rowImg['status'] == 0) {
                        echo "<img src='images/profile".$qUser['usersId'].".jpg?'".mt_rand().">";
                      } else {
                        echo "<img src='images/profiledefault.jpg'>";
                      }
                    }
                  }
              ?>
            </a>
          </div>
          <div>
            <p class="author-name"><a href="user.php?user=<?php echo $q['author'];?>"><?php echo $q['author'];?></a></p>
            <p><?php echo $q['publishDate'];?></p>
          </div>
        </div>
        <div class="main-img">
          <img src="images/<?php echo $q['image'];?>" alt="main image">
        </div>
        <p class="content-js"><?php echo nl2br($q['content']);?></p>
        <div class="post-end">
          <a href="view.php?id=<?php echo $q['id'];?>" class="btn read-more">Read More</a>
          <div class="post-stats">
            <div>
              <span><i class="fas fa-arrow-up"></i></span>
              <span><?php echo $q['upvotes'];?></span>
            </div>
            <div>
              <span><i class="fas fa-comment"></i></span>
              <span><?php echo $q['comments'];?></span>
            </div>
          </div>
        </div>
      </div>
    <?php
        }
      } else {
    ?>
        <div class="post"><img class="main-img" src="images/nothing_to_see_gif.gif" alt="Nothing to see here"></div>
    <?php
      }
    }
    ?>

<?php
    include_once "footer.php";
?>