Posts

Showing posts with the label Flask

Flask and Sqlite Basic Crud Python Tutorial

Image
Flask app.py from flask import Flask, render_template, request, redirect import sqlite3 app = Flask(__name__) @app.route('/') def view():     con = sqlite3.connect("product.db")     con.row_factory =sqlite3.Row     cur = con.cursor()     cur.execute("SELECT * FROM PRODUCTS")     rows = cur.fetchall()     return render_template("viewdata.html",rows=rows) @app.route('/add<int:id>') def add(id):     con= sqlite3.connect("product.db")     con.row_factory =sqlite3.Row     cur = con.cursor()     cur.execute("INSERT INTO KART2 (id,name,price) SELECT id,name,price FROM PRODUCTS WHERE id = ?",[id])     con.commit()     cur = con.cursor()     cur.execute("SELECT * FROM kart2")     rows = cur.fetchall()     return render_template("kart.html",rows=rows) @app.route('/kart') def kart():     con = sqlite3.connect("product.db")   ...
Post a Comment
Read more

Flask Sqlite3 python Web App Tutorial

Image
 1) Creating Database import  sqlite3 conn = sqlite3.connect('bookapp.db') conn.execute("create table Books (id INTEGER PRIMARY KEY AUTOINCREMENT,                name TEXT NOT NULL,                quantity INT  NOT NULL,                edition INT NOT NULL,               year INT NOT NULL,                price INT NOT NULL)") conn.close() 2) need to create template folder and add html files to it 2.1)Html Form  (Template folder) <html> <head>     <title>form</title> </head> <body>  <form action="/input" method="post"> <p>Bookname</p>  <input name="name" type="text" /><br /><br /> <p>Bookquantity</p>  <input name="quantity" type="text" /><br /><br /> ...
Post a Comment
Read more