<?php
require_once "../db.php";

$q = trim($_GET['q'] ?? "");

$sql = "
SELECT DISTINCT p.id, p.title
FROM posts p
LEFT JOIN post_tags pt ON p.id = pt.post_id
LEFT JOIN tags t ON pt.tag_id = t.id
WHERE p.title LIKE ? OR t.name LIKE ?
ORDER BY p.id DESC
LIMIT 50
";

$stmt = $pdo->prepare($sql);
$stmt->execute(["%$q%", "%$q%"]);

echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC));