Advertisement
michaelyuen

Untitled

May 17th, 2018
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <!DOCTYPE html>
  2. <html>
  3.     <head>
  4.     </head>
  5.     <body>
  6.         <div id="post-wrapper">
  7.             <?php include "post.php"; ?>
  8.         </div>
  9.     </body>
  10. </html>
  11.  
  12. <script>
  13.     $(document).ready(function (){
  14.         setInterval(function(){
  15.             $('#post-wrapper).load("post.php");
  16.         },2000);
  17.     });
  18. </script>
  19.  
  20. #############
  21. post.php
  22. <?php
  23.  
  24. function getLikes($id_post) {
  25.     $query = "SELECT * FROM users WHERE id_user IN (SELECT id_user FROM likes WHERE id_post='{$id_post}' LIMIT 4");
  26.     if ($result = $conn->query($query)) {
  27.         if ($result->num_rows) {
  28.             WHILE ($row = $result->fetch_assoc()) {
  29.                 $rows[] = $row;
  30.             }
  31.             return $rows;
  32.         }
  33.     }
  34.     return null;
  35. }
  36.  
  37. // your query
  38. WHILE ($row = $result->fetch_assoc()) {
  39.     $rows[] = $row;
  40. }
  41. ?>
  42. <?php foreach ($rows as $row): ?>
  43.             <div class="post" id="<?= $row['postid']; ?>">
  44.                 <div class="content">
  45.                     <div class="content-image"><?= $row['postimage']; ?></div>
  46.                     <div class="content-text"><?= $row['content']; ?></div>
  47.                 </div>
  48.                 <div class="likes">
  49. <?php if($likes = getLikes($row['id_post'])) {
  50.                     echo '<ul>';
  51.     for ($i = 1; $i <= 3; $i++) {
  52.         // your logic
  53.     }
  54.                     echo '</ul>';
  55. }
  56. ?>
  57.                 </div>
  58.             </div>
  59. <?php endforeach; ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement