Posts

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

Tkinter SQlite Data Entry Python

Image
step 1: Creating Database import sqlite3 conn = sqlite3.connect('product.db') conn.execute('''CREATE TABLE PRODUCTS          (ID INT PRIMARY KEY     NOT NULL,          NAME           TEXT    NOT NULL,          PRICE            INT     NOT NULL );''') conn.close() Step 2: Inserting Values import sqlite3 conn = sqlite3.connect('product.db') conn.execute("INSERT INTO PRODUCTS (ID,NAME,PRICE) \       VALUES (1, 'SAMSUNG', 20000.00 )"); conn.commit() conn.close() Step 3: TKinter Code from tkinter import * from tkinter import ttk import sqlite3 conn = sqlite3.connect('product.db') root = Tk() root.geometry('600x500') tree = ttk.Treeview(root,column=("c1","c2","c3"),show='headings',height=8) tree.column("#1",anchor=CENTER) tree.heading("#1",text ="ID") tree.column("#2",anchor=CENTER) tree.heading("#2",text ...
Post a Comment
Read more

Insert And Retrieve Images From SQlite Database using Tkinter and Python

Image
Insert And Retrieve Images From SQlite Database using Tkinter and Python Firstly need to create database  import sqlite3 conn = sqlite3.connect('test8.db')  conn.execute('''CREATE TABLE PHOTO          (ID INT PRIMARY KEY     NOT NULL,          IMAGE           BLOB   NOT NULL,                     );''')    conn.close() Secondly Inserting Method import sqlite3 conn = sqlite3.connect('test8.db') image = open("Home.png","rb")  ////IMAGE FILE TO UPLOAD conn.execute('INSERT INTO PHOTO (ID,IMAGE) VALUES(1,?)',[sqlite3.Binary(image.read())]) conn.commit() conn.close() Retrieve Images From Database Using Tkinter import sqlite3 from tkinter import * root = Tk() root.geometry('300x400') conn = sqlite3.connect('test8.db') cursor = conn.cursor() cursor = conn.execute("""SELECT * FROM PHOTO WHERE ID = 3 """...
Post a Comment
Read more

Python Tutorial Gui Tkinter Display Data As Text

Image
Displaying data on Tkinter Window from Database  Using the widget  label.config() Example Code: from tkinter import * import sqlite3 root = Tk() root.geometry("200x200") conn = sqlite3.connect('test1.db') def showdata():    cursor = conn.execute("SELECT id, name, address, salary from COMPANY")    for row in cursor:       l1 = Label(root, text="result")       l1.pack()       l1.config(text=row) b1 = Button(root,text="submit",command=showdata) b1.pack() root.mainloop()
Post a Comment
Read more

Currency Converter Code Python Tkinter Gui

Image
  Window Creation from tkinter import * root = Tk() root.geometry("320x300") root.title("currency converter") i= PhotoImage(file='') root.iconphoto(False,i) root['bg'] ='#f09942' Widgets Using Entry Button & Label lab = Label(root,text="Currency Converter",relief="raised",borderwidth=2,font= ('Garamond',25),bg='#f09942',padx=20,pady=10) lab.pack(padx=10,pady=10) lab_1 =Label(root,text="USD",font= ('Garamond',25),bg='#f09942') lab_1.pack(padx=2,pady=2) en = Entry(root,highlightthickness=1, width=30) en.pack(padx=2,pady=2) bt = Button(root,text="TO",command=convert,width=10) bt.pack(padx=2,pady=2) lab_2=Label(root,text="INR",font= ('Garamond',25),bg='#f09942') lab_2.pack(padx=2,pady=2) en_1=Entry(root,highlightthickness=1, width=30) en_1.pack(padx=2,pady=2) Button Code (Conversion Method)  [Button,command= convert] def convert():     en_1.delet...
Post a Comment
Read more

Registration Form Python Tkinter GUI Project

Importing Files import tkinter from tkinter import * Initializing Window top=Tk() Declaring Variables name_var = StringVar() email_var = StringVar() pass_var  = StringVar() Function to view Output def submit ():     name = name_var.get()     e= email_var.get()     p = pass_var.get()     print ( "the name is " + name)     print ( "email address is :" + e)     print ( "password is: " + p) Label Function nme = Label(top , text = "name" ).place( x = 30 , y = 50 ) email = Label(top , text = "email" ).place( x = 30 , y = 90 ) password = Label(top , text = "password" ).place( x = 30 , y = 130 ) Button Function sbmitbtn = Button(top , text = "submit" , activebackground = "pink" , activeforeground = "blue" , command =submit).place( x = 30 , y = 170 )  Entry Function   e1 = Entry(top , textvariable =name_var).place( x = 80 , y = 50 ) e2 = Entry(top , textvariable =email_var).pla...
Post a Comment
Read more