SHOW:
|
|
- or go back to the newest paste.
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 | - | <span><?= $row['likes']; ?></span> |
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; ?> |