getInt('id'); $caldb = new PDO('sqlite:' . Config::get(Config::CALIBRE_DB)); $sth = $caldb->prepare("SELECT path, name, format FROM data LEFT JOIN books ON (data.book = books.id) WHERE data.id = ?"); $sth->execute([$bookid]); while ($row = $sth->fetch()) { $filename = Config::get(Config::BOOKS_DIR) . "/" . $row["path"] . "/" . $row["name"] . "." . strtolower($row["format"]); if (file_exists($filename)) { return (new Response()) ->withHeader("Content-type", mime_content_type($filename)) ->withHeader("Content-Disposition", 'attachment; filename="' . basename($filename) . '"') ->withBody(file_get_contents($filename) ?: ''); } } return (new Response()) ->withStatus(404) ->withBody(json_encode(["error" => "Not found."])); } }