EMPLOYEE MANAGEMENT SYSTEM PYTHON CUSTOMTKINTER MODERN TKINTER PROJECT WITH SQLITE3 DATABASE
HTML-код
- Опубликовано: 8 июл 2024
- This video explains how to create a modern tkinter employee management system project with sqlite3 database in python using customtkinter.
‐--------------------------------------------------------
To support the channel:
/ @code_room
-------------------------------------------------------
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:47 Project Setup
2:12 Database Connection & Functions
6:05 Window
7:08 Labels & Entry Boxes & Combo Box
10:15 Buttons
11:30 Tree View
14:12 Insert Data To Tree View
15:18 Insert Function
18:15 New Employee Function
19:56 Display Data In Entry Boxes
22:05 Delete & Update Functions
You can now join the channel from here 👇:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
to access ALL source codes of Python GUI projects in this playlist 👇 :
ruclips.net/p/PLnZQydCjRQJzVS27vVBGTbgbiFP_tyXaD
For anyone who wants to try to copy this project. Do it, it worked for me. Finally, something that really works on tutorials. I really liked it! I followed him completely and my code worked!
Thank you, my friend. This video is very useful
You are most welcome.
As of April 16,2024 @ 26:16 the command tree.focus(' ') no longer works in the clear function. Instead I used in the update function for its first line selected_item = tree.selection() instead of tree.focus() This seems to work as expected for me.
BTW, great tutorial. It hits all the pieces and part perfectly and now I can create my own database back ended GUI app.
Thank you a lot. It was a useful APP.
You are most welcome.
If you found the channel helpful, kindly consider SUBSCRIBING.😊🔔✅️
Awesome
Thanks.
Good man
Thanks a lot
Welcome :)
❤❤❤❤
dude thanks to you I been getting better at customtkinter thank you so much, just wanted to say that. do you have any knowledge on PYQT5 ?
Glad it helps!
Yes, I have some knowledge about PyQt.
do you have some tutorials @@CODE_ROOM
Currently no, but will do in the future.✅️
error in line bro from tk(module) database?
Great work,i'm new in programming,i hope you send the code if possible,Thanks anyway.....
You can now join the channel from here 👇:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
to access ALL source codes of Python GUI projects in this playlist 👇 :
ruclips.net/p/PLnZQydCjRQJzVS27vVBGTbgbiFP_tyXaD
Bro I have an annoying issue, the tree view section is bugging.. I run the code on the laptop screen and the tree view isn’t perfectly sized, when I move it to the other screen it sizes better than the laptop screen, but still isn’t showing the status on the other screen, please help 🙏🏼
Check this:
import tkinter as tk
from tkinter import ttk
def update_treeview_size(event):
# Get the available width and height of the window
width = root.winfo_width()
height = root.winfo_height()
# Calculate the new size for the TreeView
new_width = int(width * 0.8) # Adjust the percentage as needed
new_height = int(height * 0.8)
# Set the new size for the TreeView
treeview.config(width=new_width, height=new_height)
root = tk.Tk()
# Create a TreeView widget
treeview = ttk.Treeview(root)
treeview.pack(fill='both', expand=True)
# Bind the event to update the TreeView size when the window is resized
root.bind('', update_treeview_size)
root.mainloop()
Thanks a lot, but what about if I need another field for image and pdf files, how to insert into tkinter and database, and make retrieve them by searching and save the data of searching in pdf or word or excel file. Thanks again
Will try to make a tutorial about this in the future :)
@CODE_ROOM Thanks a lot 🙏🏼 🙏🏼
Really nice project, how can i find the whole project??
✨️Subscribe for more quizzes✨️
Man, you just can create functions for label and entry, is a better choice
definitely, especially if you have a more complex project.
yes but how do i access the source code no link just a link to the playlist ?
Get UNLIMITED access to source codes now with only $2.99✅️
Join Now:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
@@CODE_ROOM 🫡🫡🫡
@@CODE_ROOM
muy bueno tu programapuedes compatir el codigo fuente..??
You can now join the channel from here 👇:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
to access ALL source codes of Python GUI projects in this playlist 👇 :
ruclips.net/p/PLnZQydCjRQJzVS27vVBGTbgbiFP_tyXaD
@@CODE_ROOM
what shoule i do to use sqlite3,such as download sth?
It is already installed starting from Python 2.5, just import it in your file.
thank you
Anytime.
in display_data I need to write“clear('true')”,otherwise datas at entry cannot be deleted @@CODE_ROOM
Search and filter?
This can help you implementing the search:
ruclips.net/video/pW22ux8z6ic/видео.html
Module not found database, what can I do?
Make sure that you have created this file database with this name correctly.
The update function is not working for me, even though it show 'has been updated'😭
Can you reply with your function?
def update():
selected_item = tree.focus()
if not selected_item:
messagebox.showerror('Error', 'Choose an employee to update.')
else:
ID=ID_entry.get()
Name=Name_entry.get()
Role=Role_entry.get()
Gender=variable1.get()
Status=Status_entry.get()
database.update_employee(Name, Role, Gender, Status, ID)
add_to_treeview()
clear()
messagebox.showinfo('Success','Data has been updated.')
Your function seems to be correct. Check add_to_treeview function and the update_employee function in the database.
#add to treeview
def add_to_treeview():
employees=database.fetch_employees()
tree.delete(*tree.get_children())
for employee in employees:
tree.insert('', END, values=employee)
#update employee
def update_employee(new_Name, new_Role, new_Gender, new_Status, ID):
conn=connection()
cur=conn.cursor()
cur.execute("UPDATE employees SET Name=?,Role=?,Gender=?,Status=? where ID=?",
(new_Name, new_Role, new_Gender, new_Status, ID))
conn.commit()
conn.close()
I can't find what's wrong here
Nice tutorial. It would make it much easier to follow the code and code along if you put the widget properties on separate lines.
e.g.
delete_button = ctk.CTkButton(app,
font=font1,
text_color = '#fff',
text = 'New Employee',
fg_color = "#e40404",
hover_color = '#ae0000',
bg_color = '#161c25',
border_color = '#e40404',
border_width = 2,
cursor='hand2',
corner_radius = 15,
width = 260 )
delete_button.place(x=580,y=360)
Nice suggestion! Will consider in next tutorials.
could wrap the code to see all of it please ??? and thank's
Will consider that in next videos.
How do i access the code, no link?
Get UNLIMITED access to source codes now with only $2.99✅️
Join Now:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
id_entry=customtkinter.CTkLabel(app,font=font1, text_color='#000', fg_color='#fff',border_color='#0C9296', border_width=2, width=180) my this line is showing error what should i do
It should be CTkEntry not CTkLabel.
Where is the file to download?
You can now join the channel from here 👇:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
to access ALL source codes of Python GUI projects in this playlist 👇 :
ruclips.net/p/PLnZQydCjRQJzVS27vVBGTbgbiFP_tyXaD
Im gonna cry a lot if my code still do not work. Im making a program just like this. But Im doing some slight differences because originality is part of the criteria. HEEELLLPPP 😭😭😭
What is the problem with your code?
@@CODE_ROOMThe update and delete function does not work for me. I'm still looking for the bug
@@CODE_ROOM
Update: everything works now. OMGGG THANKK YOUUU SO MUCH. IVE ALSO SUBSCRIBED TO YOUR CHANNEL SO I CAN LEARN MORE. THANKKK YOUUUU SO MUCCHHHH 😭😭😭😭
Can i get the code in file?
Get UNLIMITED access to source codes now with only $2.99✅️
Join Now:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
Update button not work 😭
Please, show me the issue in your code.
source code broo
You can now join the channel from here 👇:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
to access ALL source codes of Python GUI projects in this playlist 👇 :
ruclips.net/p/PLnZQydCjRQJzVS27vVBGTbgbiFP_tyXaD
Bro Please give me source code of the Program
You can now join the channel from here 👇:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
to access ALL source codes of Python GUI projects in this playlist 👇 :
ruclips.net/p/PLnZQydCjRQJzVS27vVBGTbgbiFP_tyXaD
Where the source code
Get UNLIMITED access to source codes now with only $2.99✅️
Join Now:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
great work but , No source code ???????????????????????????????????????
You can now join the channel from here 👇:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin
to access ALL source codes of Python GUI projects in this playlist 👇 :
ruclips.net/p/PLnZQydCjRQJzVS27vVBGTbgbiFP_tyXaD
is there a code somewhere? because I can't see.
writing it off from a movie is lame.
✨️Access all source codes with only $2.99✨️
Join✅️:
ruclips.net/channel/UCv-xyS0YxYCrEoMFH_cgcoQjoin