[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_216":217,"_218":219},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","01a080e1-be0d-720f-a0a0-95f2ff9c7dc2","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Submission {\n id: number;\n name: string;\n email: string;\n message: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS submissions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addSubmission(name: string, email: string, message: string) {\n await sqlite.execute({\n sql: \"INSERT INTO submissions (name, email, message) VALUES (?, ?, ?)\",\n args: [name, email, message],\n });\n}\n\nexport async function listSubmissions(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, name, email, message, created_at FROM submissions ORDER BY id DESC\",\n );\n return result.rows as unknown as Submission[];\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Inquiry {\n id: number;\n name: string;\n email: string;\n phone: string;\n destinations: string;\n month: string;\n party: string;\n message: string;\n lang: string;\n ip_hash: string;\n user_agent: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS inquiries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n phone TEXT NOT NULL DEFAULT '',\n destinations TEXT NOT NULL DEFAULT '',\n month TEXT NOT NULL DEFAULT '',\n party TEXT NOT NULL DEFAULT '',\n message TEXT NOT NULL DEFAULT '',\n lang TEXT NOT NULL DEFAULT 'zh',\n ip_hash TEXT NOT NULL DEFAULT '',\n user_agent TEXT NOT NULL DEFAULT '',\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addInquiry(i: Omit): Promise {\n const r = await sqlite.execute({\n sql: `INSERT INTO inquiries (name, email, phone, destinations, month, party, message, lang, ip_hash, user_agent)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [i.name, i.email, i.phone, i.destinations, i.month, i.party, i.message, i.lang, i.ip_hash, i.user_agent],\n });\n return Number(r.lastInsertRowid ?? 0);\n}\n\nexport async function countRecentByIp(ipHash: string, minutes: number): Promise {\n const r = await sqlite.execute({\n sql: `SELECT COUNT(*) AS n FROM inquiries WHERE ip_hash = ? AND created_at >= datetime('now', ?)`,\n args: [ipHash, `-${minutes} minutes`],\n });\n return Number((r.rows[0] as any)?.n ?? 0);\n}\n\nexport async function listInquiries(limit = 300): Promise {\n const r = await sqlite.execute({\n sql: `SELECT id, name, email, phone, destinations, month, party, message, lang, created_at\n FROM inquiries ORDER BY id DESC LIMIT ?`,\n args: [limit],\n });\n return r.rows as unknown as Inquiry[];\n}\n","createdAt",["D",1788868727973],"branchVersion","branchId","4bb477fd-f17c-45e1-8c45-9ac232bb7f1e","id","2e9fda9f-c072-4ae0-a75e-c7ccaadd31aa","chitien-inquiry",["D",1788868672868],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","齊天旅行社網站詢問表單後端: 存 SQLite + email 通知","imageUrl","04d840cc-4bfb-411e-9b63-ee625b96a32a","pinnedFileId","01a080e1-be0d-720f-a0a0-9bf8a8e4498f","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019edd59-7b3e-722d-a9c9-2bb34b53ed67","tursoName","2e9fda9fc0724ae0a75ec7ccaadd31aa","tursoHostname","2e9fda9fc0724ae0a75ec7ccaadd31aa-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789651264012],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",7,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","piyatat726","handle","displayName","哲齊許","avatar","https://lh3.googleusercontent.com/a/ACg8ocL--LqhYafFVZniKIfsTcCNAYb_-LmvuCWSdg_tAqidOaXRAHs=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":211,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":212,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":213,"_84":214,"_86":215,"_88":25},"tree",[170,174,175,176],"files",[170,171,172,173,174,175,176],"counts",{"_160":63,"_161":138,"_162":63,"_163":164,"_165":166},"contents",[131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":154,"_32":155,"_30":156,"_137":-5,"_41":42,"_40":138,"_139":59,"_38":157,"_13":63,"_33":158,"_35":-5,"_24":25,"_143":-5,"_27":159},{"_43":148,"_32":149,"_30":150,"_137":-5,"_41":42,"_40":138,"_139":25,"_38":151,"_13":63,"_33":20,"_35":152,"_24":25,"_143":-5,"_27":153},{"_43":145,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":59,"_38":146,"_13":138,"_33":34,"_35":37,"_24":25,"_143":-5,"_27":147},{"_43":135,"_32":136,"_30":57,"_137":-5,"_41":42,"_40":138,"_139":25,"_38":140,"_13":63,"_33":141,"_35":142,"_24":25,"_143":-5,"_27":144},"2a277cf8-ba2c-4bf8-ad7f-2ecf0f177110","main.tsx","parentId",1,"latest",["D",1788868672868],"http","/** @jsxImportSource npm:hono/jsx */\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport FormPage from \"./components/FormPage.tsx\";\nimport SubmissionsPage from \"./components/SubmissionsPage.tsx\";\nimport { addSubmission, listSubmissions } from \"./db.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c) => c.html());\n\napp.post(\"/submit\", async (c) => {\n const form = await c.req.formData();\n const name = String(form.get(\"name\") ?? \"\").trim();\n const email = String(form.get(\"email\") ?? \"\").trim();\n const message = String(form.get(\"message\") ?? \"\").trim();\n if (!name || !email || !message) {\n return c.text(\"Name, email, and message are all required.\", 400);\n }\n await addSubmission(name, email, message);\n return c.redirect(\"/submissions\");\n});\n\napp.get(\"/submissions\", async (c) => {\n const submissions = await listSubmissions();\n return c.html();\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[136],"fcf36612-ff8c-4e05-b935-4371de93a7d6",["D",1788868727973],[28],"12c21c16-42ab-4b65-ab28-b61db5d14484","README.md","01a080e1-be0d-720f-a0a0-9153a0ca3e53",["D",1788868672868],"# What's the easiest way to put a form online and save submissions?\n\nRemix this val. It serves a contact form (name, email, message) at `/`, saves every submission to the val's own SQLite database, and lists everything received at `/submissions`. No external services, no API keys, no env vars.\n\n## Setup\n\n1. Remix this val.\n2. Open the HTTP endpoint of `main.tsx` — that is your live form. Share the URL.\n3. Visit `/submissions` on the same URL to see what people sent.\n\nEach remix gets its own private SQLite database, so your submissions stay with your copy.\n\n## Files\n\n- `main.tsx` — Hono routes: GET `/` (form), POST `/submit` (save), GET `/submissions` (list)\n- `db.ts` — creates the `submissions` table and holds the two queries\n- `components/Layout.tsx` — shared page shell with Tailwind (via Twind)\n- `components/FormPage.tsx` — the form\n- `components/SubmissionsPage.tsx` — the list\n\n## Notes\n\n- `/submissions` is public by default. If your form collects anything sensitive, protect that route before sharing the form URL.\n- No client-side JavaScript: the form is a plain HTML POST.\n",[149],"83808d2d-83b4-48ca-8033-5ef2f339ec00","components","01a080e1-be0d-720f-a0a0-8c994b4d2526",["D",1788868672868],"directory",[155],"pulls","branches","forks","envVars",{"_167":138,"_169":63},"connections",{"_167":63,"_168":63},"count","unfilledCount","emptyCount",{"_43":154,"_32":155,"_30":156,"_137":-5,"_41":42,"_40":138,"_139":59,"_38":208,"_13":63,"_33":158,"_35":-5,"_24":25,"_143":-5,"_178":209,"_27":210},{"_43":201,"_32":202,"_30":203,"_137":156,"_41":42,"_40":138,"_139":25,"_38":204,"_13":63,"_33":34,"_35":205,"_24":25,"_143":-5,"_178":206,"_27":207},{"_43":194,"_32":195,"_30":196,"_137":156,"_41":42,"_40":138,"_139":25,"_38":197,"_13":63,"_33":34,"_35":198,"_24":25,"_143":-5,"_178":199,"_27":200},{"_43":187,"_32":188,"_30":189,"_137":156,"_41":42,"_40":138,"_139":25,"_38":190,"_13":63,"_33":34,"_35":191,"_24":25,"_143":-5,"_178":192,"_27":193},{"_43":148,"_32":149,"_30":150,"_137":-5,"_41":42,"_40":138,"_139":25,"_38":184,"_13":63,"_33":20,"_35":152,"_24":25,"_143":-5,"_178":185,"_27":186},{"_43":145,"_32":28,"_30":31,"_137":-5,"_41":42,"_40":14,"_139":59,"_38":181,"_13":138,"_33":34,"_35":37,"_24":25,"_143":-5,"_178":182,"_27":183},{"_43":135,"_32":136,"_30":57,"_137":-5,"_41":42,"_40":138,"_139":25,"_38":177,"_13":63,"_33":141,"_35":142,"_24":25,"_143":-5,"_178":179,"_27":180},["D",1788868672868],"children",[],[136],["D",1788868727973],[],[28],["D",1788868672868],[],[149],"95b43b00-41e0-44fd-943a-7551265d31e0","SubmissionsPage.tsx","01a080e1-be0d-720f-a0a0-884b6133eee9",["D",1788868672868],"/** @jsxImportSource npm:hono/jsx */\nimport type { Submission } from \"../db.ts\";\nimport Layout from \"./Layout.tsx\";\n\nexport default function SubmissionsPage({ submissions }: { submissions: Submission[] }) {\n return (\n \n

Submissions ({submissions.length})

\n {submissions.length === 0\n ?

Nothing yet. Be the first to submit the form.

\n : (\n

\n
\n {s.name}\n {s.created_at}\n
\n
{s.email}
\n
{s.message}
\n

\n )}\n

\n back to form\n view source\n

\n \n );\n}\n",[],[155,188],"5a82b9c4-f1ea-4734-92e8-8e3f3f69b152","Layout.tsx","01a080e1-be0d-720f-a0a0-875daae02b75",["D",1788868672868],"/** @jsxImportSource npm:hono/jsx */\n\nexport default function Layout({ title, children }: { title: string; children?: unknown }) {\n return (\n \n \n \n \n {title}\n \n \n \n \n

{children}

\n \n \n );\n}\n",[],[155,195],"6a2f5d63-cbac-4683-bb4c-b896aaf455dc","FormPage.tsx","01a080e1-be0d-720f-a0a0-8359bc08b970",["D",1788868672868],"/** @jsxImportSource npm:hono/jsx */\nimport Layout from \"./Layout.tsx\";\n\nexport default function FormPage() {\n return (\n \n

Contact form

\n Submissions are saved to this val's SQLite database.\n

\n \n

\n view submissions\n view source\n

\n \n );\n}\n",[],[155,202],["D",1788868672868],[171,172,173],[155],["D",1788868672868],["D",1789651264012],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_128":249,"_250":251,"_252":253,"_254":25,"_255":25,"_256":25,"_257":59,"_258":-5,"_259":-7,"_260":-7,"_261":63,"_262":25,"_263":25,"_264":-5,"_265":25,"_266":25,"_267":25,"_268":-5},"ENV",{"_220":221,"_222":223,"_224":90,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v2