install psycopg2 https://pypi.org/project/psycopg2/
Psycopg is the most popular PostgreSQL database adapter for the Python programming language.
(venv) PS C:\flaskmyproject> pip install psycopg2
CREATE TABLE checkbox (
id serial PRIMARY KEY,
name VARCHAR ( 150 ) NOT NULL
);
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | #app.pyfrom flask import Flask, render_template, jsonify, requestimport psycopg2 #pip install psycopg2 import psycopg2.extras app = Flask(__name__) app.secret_key = "caircocoders-ednalan" DB_HOST = "localhost"DB_NAME = "sampledb"DB_USER = "postgres"DB_PASS = "admin" conn = psycopg2.connect(dbname=DB_NAME, user=DB_USER, password=DB_PASS, host=DB_HOST)@app.route('/')def main(): return render_template('index.html') @app.route("/insert",methods=["POST","GET"])def insert(): cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor) if request.method == 'POST': insert = request.form['checkboxvalue'] cur.execute("INSERT INTO checkbox (name) VALUES (%s)",[insert]) conn.commit() cur.close() msg = 'Data Inserted Successfully!' else: msg = 'Invalid' return jsonify(msg)if __name__ == "__main__": app.run(debug=True) |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | //templates/index.html<!doctype html><html><head> <meta charset="UTF-8"> <title>Insert Checkbox values using Python Flask Jquery Ajax and PostgreSQL Database</title></head><body> <h3>Insert Checkbox values using Python Flask Jquery Ajax and PostgreSQL Database</h3> <label><input type="checkbox" class="get_value" value="Python"> Python</label> <br/> <label> <input type="checkbox" class="get_value" value="JavaScript"> JavaScript</label> <br/> <label><input type="checkbox" class="get_value" value="Java"> Java</label> <br/> <label><input type="checkbox" class="get_value" value="PHP"> PHP</label> <br/> <label><input type="checkbox" class="get_value" value="Swift"> Swift</label> <br/> <br/> <button type="button" name="submit" id="submit">Save</button> <br/> <h4 id="result"></h4> <script> $(document).ready(function() { $('#submit').click(function() { var insert = []; $('.get_value').each(function() { if ($(this).is(":checked")) { insert.push($(this).val()); } }); insert = insert.toString(); var insert_string = 'checkboxvalue='+insert; $.ajax({ method: "POST", url: "/insert", data: insert_string, cache: false, success: function(data){ $("#result").html(data); } }); }); }); </script></body></html> |
