// This HTTP val creates a comment box where users can submit comments. // The comments are stored in a SQLite database and displayed on the page. import { Hono } from "npm:hono"; import { sqlite } from "https://esm.town/v/std/sqlite?v=4"; import { html } from "https://esm.town/v/stevekrouse/html?v=5"; // Initialize SQLite database and comments table if it doesn't exist const initDB = async () => { await sqlite.execute(` CREATE TABLE IF NOT EXISTS comments ( id INTEGER PRIMARY KEY AUTOINCREMENT, text TEXT NOT NULL, timestamp DATETIME DEFAULT CURRENT_TIMESTAMP ) `); }; await initDB(); const app = new Hono(); // Serves the comment page app.get("/", async (c) => { const result = await sqlite.execute("SELECT * FROM comments ORDER BY timestamp DESC"); const comments = result.rows; return html(` Comment Box

Comment Box

${comments.map(comment => `

${comment[1]}

${new Date(comment[2]).toLocaleString()}

`).join('')}

`); }); // Handles the comment submission app.post("/comment", async c => { const formData = await c.req.parseBody(); const text = formData.get('text'); // using get method to fetch the value // Insert the comment into the database await sqlite.execute("INSERT INTO comments (text) VALUES (?)", [text]); // Correctly passing argument as array element // Redirect back to the main page return c.redirect("/"); }); export default app.fetch;

valle_tmp_6792193506514019542960400413897