PY
(real quick example)
id | INTEGER, PRIMARY KEY email | TEXT, NOT NULL txt | TEXT, NOT NULL
<form method="post"> <label>Email</label> <input type="email" name="em" required> <label>Text</label> <input type="text" name="tx" required> <input type="submit" value="Go!"> </form>
LOAD MODULES import sqlite3 from flask import Flask, request, render_template
@app.route("/", methods=["GET", "POST"]) def index(): SAVE ON FORM SUBMIT if request.method == "POST": conn = sqlite3.connect("my.db") cur = conn.cursor() e = request.values.get("em") t = request.values.get("tx") cur.execute("INSERT INTO dummy (`email`, `txt`) VALUES (?,?)", (e, t)) conn.commit() conn.close()
SERVE HTML PAGE return render_template("form.html")
START if __name__ == "__main__": app.run("localhost", 80)