{title}

Start Demo

\n Search:{\" \"}\n \n \n \n \n \n \n \n \n \n \n \n \n {rows.map((row) => (\n \n \n \n \n \n \n ))}\n \n

ID	Name	Email	Message
{row[0]}	{row[1]}	{row[2]}	{row[3]}

\n \n \n );\n};\napp.get(\"/\", async (c) => {\n // get all sql lite messages as rows but filter if name is \"undefined\"\n const select = `SELECT * FROM messages WHERE name != 'undefined' LIMIT 10`;\n const result = await sqlite.execute(select);\n // console.log(result);\n const rows = result.rows;\n console.log(rows);\n // pass all\n // rows to the view\n return c.html();\n});\n\nconst Clicked = () => {\n return

Finish Demo

;\n};\napp.post(\"/clicked\", (c) => {\n return c.html();\n});\n\n// create POST to handle search form input\n// filter messages table using LIKE on message table\napp.post(\"/search\", async (c) => {\n // get post parameters: {\"search\": }\n const body = await c.req.parseBody();\n console.log(body);\n const search = body[\"search\"];\n console.log(search);\n // check if search is empty\n let selectQuery = `SELECT * FROM messages WHERE message LIKE '%${search}%' AND name != 'undefined' LIMIT 10`;\n\n console.log(selectQuery);\n const result = await sqlite.execute(selectQuery);\n console.log(result);\n const rows = result.rows;\n return c.html(\n \n {rows.map((row) => (\n \n {row[0]}\n {row[1]}\n {row[2]}\n {row[3]}\n \n ))}\n ,\n );\n});\n\nexport default app.fetch;","deleted","label",[98],"permalink","https://www.val.town/x/tfayyaz/searchmessages/code/main.tsx","extension","actionData","errors"]