prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$user_id]);
$user = $stmt->fetch();
// Fetch user's posts
$postStmt = $pdo->prepare("
SELECT id, title, file_path, type, nsfw, created_at
FROM posts
WHERE user_id = ?
ORDER BY id DESC
");
$postStmt->execute([$user_id]);
$posts = $postStmt->fetchAll();
?>
Your Profile