INVENTORY MANAGEMENT SYSTEM PYTHON CUSTOMTKINTER MODERN TKINTER PROJECT WITH SQLITE3 DATABASE
HTML-код
- Опубликовано: 20 июл 2024
- This video explains how to create a modern tkinter inventory management system with sqlite3 database in python using customtkinter.
-----------------------------------------
To support the channel: / @code_room
-----------------------------------------
Image Designed by flaticon.com:
1) www.flaticon.com/free-icons/c..." title="coffee icons" Coffee icons created by Freepik - Flaticon
-----------------------------------------
Python Programming Course:
• PYTHON PROGRAMMING COU...
Python Problem Solving:
• PYTHON PROBLEM SOLVING
Python Projects:
• PYTHON TKINTER GUI PRO...
Data Science Questions and Answers :
• DATA SCIENCE SOLVED QU...
Data Science Python Pandas Full Course :
• Playlist
Image and Video Processing Questions and Answers :
• DIGITAL IMAGE PROCESSI...
----------------------------------------
00:00 Project Demo
1:49 Project Setup
2:41 Database Connection & Functions
5:35 Window
6:38 Labels & Entry Boxes & Buttons
9:35 Tree View
11:30 Insert Function
13:41 New Product Function
14:58 Insert Data To Tree view
16:57 Display Tree View Data In Entry Boxes
18:47 Update & Delete Functions
21:40 Creating Stock Bar Charts
25:00 Image Credit
Thanks a lot for this video. Accurate and very helpful. Good work!!!
You are most welcome.
Thank, sir! I have got nice lesson as begginer.
You are most welcome.
Kindly, if you found the channel helpful, consider subscribing😊✅️🔔
Finally I 🎉 thank you was My first time
You are most welcome.
Thanks it's helpful
You are most welcome.
If you found the channel helpful, kindly consider SUBSCRIBING.😊🔔✅️
Hello please help! how can I change to enter decimals (00.00) values. Thank you
You want to enter decimals for what?
Good day,Sir.
I am very sorry. May you show me -how we can add treeview horizntal and vertical scrollbars.
Thank you very muxh in advance!
You can do something like this:
# Create horizontal scrollbar
xscrollbar = ttk.Scrollbar(root, orient="horizontal", command=tree.xview)
tree.configure(xscrollcommand=xscrollbar.set)
# Create vertical scrollbar
yscrollbar = ttk.Scrollbar(root, orient="vertical", command=tree.yview)
tree.configure(yscrollcommand=yscrollbar.set)
Thank you very much,sir !!! I have put treeview size as example: tree.place(x=300,y=45,width=300,height=80), and all are working(moving) now.Without treeview dimention(width=300,height=80) scrollbars were not functioned.
ValueError: ['border_color', 'border_width'] are not supported arguments. Look at the documentation for supported arguments.
Can u help me sir ?
Please, check the documentation of CustomTkinter for supported arguments of widgets, because it is always updated: customtkinter.tomschimansky.com/documentation/widgets
@@CODE_ROOM thanks sir, i handled out. You're so helpfull person. Pls share more video. You're my idol.
and as well line 33
Hello There is a error promble show in up I cant find it
frame = customtkinter.CTkFrame(app,bg_color="#0A0B0C",fb_color="#1B1B21",corner_radius=10,border_width=2,border_color="#fff",width=200,height=370)
frame.place(x=25, y=45)
What is the error saying?
@@CODE_ROOM
raceback (most recent call last):
File "c:\Users\Desktop\Desktop\lab.py", line 23, in
frame = customtkinter.CTkFrame(app,bg_color="#0A0B0C",fb_color="#1B1B21",corner_radius=10,border_width=2,border_color="#fff",width=200,height=370)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Desktop\AppData\Roaming\Python\Python311\site-packages\customtkinter\windows\widgets\ctk_frame.py", line 33, in __init__
super().__init__(master=master, bg_color=bg_color, width=width, height=height, **kwargs)
File "C:\Users\Desktop\AppData\Roaming\Python\Python311\site-packages\customtkinter\windows\widgets\core_widget_classes\ctk_base_class.py", line 46, in __init__
check_kwargs_empty(kwargs, raise_error=True)
File "C:\Users\Desktop\AppData\Roaming\Python\Python311\site-packages\customtkinter\windows\widgets\utility\utility_functions.py", line 18, in check_kwargs_empty
raise ValueError(f"{list(kwargs_dict.keys())} are not supported arguments. Look at the documentation for supported arguments.")
ValueError: ['fb_color'] are not supported arguments. Look at the documentation for supported arguments.
[Done] exited with code=1 in 14.337 seconds
The error happens because you are writing "fb_color" instead of "fg_color".
how can i move the bar plot to another position ?
Use the padx and pady.
image1 = PhotoImage(file="coffee.png")
image1_label = Label(frame,image=image1)
image1_label.place(x=65,y=5)
this is giving an error of tkinter.TclError: couldn't open "coffee.png": no such file or directory
Make sure that the image is in the same directory of your python file.
@@CODE_ROOM thanks for replying it is in the same directory but still doesn't work thanks for the helpful video because it is quite similar to my final year project and I need a lot of help for that
can i some how send you the file so you can see the error and maybe that way it is easy
Got an error
line 25,
unknown color name '#fff'
Try: '#ffffff'
@@CODE_ROOM another error Nomodulename customtkinter how to solve this please
@@CODE_ROOM another error Nomodulename customtkinter how to solve this please
Open your terminal,
write: pip install customtkinter
can i make this without sql database
You can use any database type.
@@CODE_ROOM how can I use this program without a database I want it store stuff in a text file or something. Something local... can you help me with that?
please help
can u give us source code of this?
✨️Access all source codes with only $2.99✨️
Join✅️:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
Sir source code
Get UNLIMITED access to this source code and other 22 GUI projects source codes with only ✨️$2.99✨️.
Join from here✅️:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
id_entry = customtkinter.CTKEntry(frame,font=font2,text_color="#000",fg_color="#fff",border_color="#B2016C", border_width=2,width=160)
id_entry.place(x=20,y=105)
Hi! Please help. I keep getting getting this problem:
File "\\wsl.localhost\Ubuntu\home\student\EEE111\SP 2\StudLab.py", line 20, in
title_label = customtkinter.CTk(app, font = font_one, text = 'Student Details', text_color = '#fff', bg_color = '#0A0B0C')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\lel0tss\AppData\Local\Programs\Python\Python311\Lib\site-packages\customtkinter\windows\ctk_tk.py", line 43, in __init__
check_kwargs_empty(kwargs, raise_error=True)
File "C:\Users\lel0tss\AppData\Local\Programs\Python\Python311\Lib\site-packages\customtkinter\windows\widgets\utility\utility_functions.py", line 18, in check_kwargs_empty
raise ValueError(f"{list(kwargs_dict.keys())} are not supported arguments. Look at the documentation for supported arguments.")
ValueError: ['font', 'text', 'text_color', 'bg_color'] are not supported arguments. Look at the documentation for supported arguments.
I've looked in the documentation you replied in another comment and checked. They are just the same, how will it work properly? Thanks in advance for the response.
You should create a label not a window, like this customtkinter.CTkLabel
@@CODE_ROOM Which part should I put it? I just modified your code for some things I am practicing to do, but it appears to have stopped in this part >>
import customtkinter
from customtkinter import *
from tkinter import *
from tkinter import ttk
import tkinter as tk
from tkinter import messagebox
#from matplotlib.figure import Figure
#from matplotlib.backends.backend_tkagg import FigureCanvasTkagg
import StudDb
app = customtkinter.CTk()
app.title('Student Management System')
app.geometry('800x680')
app.config(bg='#0A0B0C')
app.resizable(False, False)
font_one = customtkinter.CTkFont(family = "Josefin Sans", size = 25, weight = "bold")
font_two = customtkinter.CTkFont(family = "Josefin Sans", size = 20, weight = "bold")
title_label = customtkinter.CTk(app, font = font_one, text = 'Student Details', text_color = '#fff', bg_color = '#0A0B0C')
title_label.place(x = 25, y = 45)
frame = customtkinter.CTkFrame(app, bg_color = '#0A0B0C', fg_color = '#1B1121', corner_radius = 10, border_width = 2, border_color = '#fff', width = 200, height = 370 )
frame.place(x = 25, y = 45)
image1 = PhotoImage(file = '1.png')
image1_label = Label(frame, image = image1, bg = '#1B1B21')
image1_label.place(x = 65, y = 5)
class_number_label = customtkinter.CTkLabel(frame, font = font_two, text = 'Class Number', text_color = '#fff', bg_color = '#1B1B21')
class_number_label.place(x = 60, y = 75)
class_number_entry = customtkinter.CTkEntry(frame, font = font_two, text_color = '#000', fg_color = '#fff', border_color = '#B2016C', border_width = 2, width = 160)
class_number_entry.place(x = 20, y = 105)
name_label = customtkinter.CTkLabel(frame, font = font_two, text = 'Name', text_color = '#fff', bg_color = '#1B1B21')
name_label.place(x = 50, y = 140)
name_label_entry = customtkinter.CTkEntry(frame, font = font_two, text_color = '#000', fg_color = '#fff', border_color = '#B2016C', border_width = 2, width = 160)
name_label_entry.place(x = 20, y = 175)
gender_label = customtkinter.CTkLabel(frame, font = font_two, text = 'Gender', text_color = '#fff', bg_color = '#1B1B21')
gender_label.place(x = 60, y = 205)
gender_label_entry = customtkinter.CTkEntry(frame, font = font_two, text_color = '#000', fg_color = '#fff', border_color = '#B2016C', border_width = 2, width = 160)
gender_label_entry.place(x = 20, y =240)
add_button = customtkinter.CTkButton(frame, font = font_two, text_color = '#fff', text = 'Add Student', fg_color = '#047E43', hover_color = '#025B30', bg_color = '#1B1B21', cursor = 'hand2', corner_radius = 8, width = 80)
add_button.place(x = 15, y = 280)
clear_button = customtkinter.CTkButton(frame, font = font_two, text_color = '#fff', text = 'New Student', fg_color = '#E93E05', hover_color = '#A82A00', bg_color = '#1B1B21', cursor = 'hand2', corner_radius = 8, width = 80)
clear_button.place(x = 108, y = 280)
update_button = customtkinter.CTkButton(frame, font = font_two, text_color = '#fff', text = 'Update Student', fg_color = '#E93E05', hover_color = '#A82A00', bg_color = '#1B1B21', cursor = 'hand2', corner_radius = 8, width = 80)
update_button.place(x = 15, y = 320)
delete_button = customtkinter.CTkButton(frame, font = font_two, text_color = '#fff', text = 'Delete Student', fg_color = '#D20B02', hover_color = '#8F0600', bg_color = '#1B1B21', cursor = 'hand2', corner_radius = 8, width = 80)
delete_button.place(x = 108, y = 320)
app.mainloop()
please help. Thank you again in advance for the response!
In the title label.
@@CODE_ROOM Thank you!, I have edited that part, but the problem is that its size is not appearing similar to how you did it? Please help. Thank you again for the response in advance.
I apologize for asking a lot of questions. I would like to ask for help, why does it keep saying database locked? Thank you!