Insert And Retrieve Images From SQlite Database using Tkinter and Python

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 """)

result = cursor.fetchall()

for row in result:

     img = PhotoImage(data=row[1])

     l1 = Label(root, text='Image here')

     l1.grid(row=3, column=1)

     l1.config(image=img)

conn.commit()

conn.close()

root.mainloop()





 

Comments

Post a Comment

Popular posts from this blog

Django Class Based Views Blog App

 Models class Blog(models.Model):     title = models.CharField(max_length =200)     description = models.TextField()     def __str__(self):         return self.title Python manage.py makemigrations Python manage.py migrate views from .models import Blog from django.views.generic.edit import CreateView from django.views.generic.list import ListView from django.views.generic.edit import DeleteView from django.views.generic.edit import UpdateView class BlogCreate(CreateView):     model =  Blog     fields = '__all__'     success_url = '/blog' class BlogList(ListView):     model = Blog class BlogDelete(DeleteView):     model = Blog     success_url = '/list' class BlogUpdate(UpdateView):     model = Blog     fields = '__all__'     template_name = 'dapp/blog_form.html'     success_url = '/list' urls from .views import BlogCreate from .v...
Read more

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")   ...
Read more