Show sourcecode
The following files exists in this folder. Click to view.
webbsrvprg/projekt/slutprojekt/
board_random.php
board_travel.php
board_vgy.php
create_comment.php
create_post.php
create_tables.php
darkmode.js
fetch_comments.php
fetch_posts.php
fetch_posts_random.php
forgot_password.php
index.php
login.php
nav.css
nav.php
post.php
register.php
reset_password.php
sql_inject.php
verify.php
fetch_posts_random.php
32 lines ASCII Windows (CRLF)
<?php
session_start();
include('../../incl/dbconnect.php');
header('Content-Type: application/json');
if (!isset($_GET['board_id'])) {
echo json_encode([]);
exit;
}
$board_id = intval($_GET['board_id']);
$stmt = $dbconn->prepare("
SELECT
p.post_id,
p.content,
p.image_url,
p.created_at,
u.username,
(
SELECT COUNT(*)
FROM Posts_slutprojekt
WHERE user_id = p.user_id
) AS post_count
FROM Posts_slutprojekt p
JOIN Users_slutprojekt u ON p.user_id = u.user_id
WHERE p.board_id = :bid
ORDER BY p.created_at DESC
");
$stmt->execute([':bid' => $board_id]);
echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC));