EMPLOYEE MANAGEMENT SYSTEM PYTHON CUSTOMTKINTER GUI PROJECT WITH SQLITE DATABASE

Рет қаралды 50,344

Күн бұрын

Пікірлер: 91

@CODE_ROOM Жыл бұрын

You can now join the channel from here 👇: kzbin.info/door/v-xyS0YxYCrEoMFH_cgcoQjoin to access ALL source codes of Python GUI projects in this playlist 👇 : kzbin.info/aero/PLnZQydCjRQJzVS27vVBGTbgbiFP_tyXaD

@BolatDosbolatov 6 ай бұрын

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!

@ZulqernainNasir 4 ай бұрын

Plz provide me its code

@soumahorosoualiho5825 Ай бұрын

Hi. Good project But it is not possible to update multiple data at the same time. Only one can be updated. Can you fix that?

@soumahorosoualiho5825 Ай бұрын

For example, you can not update name and role at the same time

@soumahorosoualiho5825 Ай бұрын

Everything is OK now. I got the solution

@BolatDosbolatov Ай бұрын

@@soumahorosoualiho5825 Idk man

@saniyapandhare 24 күн бұрын

Thank you so much , it is very useful and helpful and worked successfully...!!😊

@CODE_ROOM 3 күн бұрын

I am happy for hearing this😊😊 Good luck👍👍

@Drbadvibe 8 ай бұрын

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.

@bleedy7589 Жыл бұрын

Thank you, my friend. This video is very useful

@CODE_ROOM Жыл бұрын

You are most welcome.

@royugsornwijitumpai 28 күн бұрын

please, show how to select Gender from other table in relationship database, Thank you

@mohamedalhashmi1386 Жыл бұрын

Thank you a lot. It was a useful APP.

@CODE_ROOM Жыл бұрын

You are most welcome. If you found the channel helpful, kindly consider SUBSCRIBING.😊🔔✅️

@advaitshinde6609 8 ай бұрын

yes but how do i access the source code no link just a link to the playlist ?

@CODE_ROOM 8 ай бұрын

Get UNLIMITED access to source codes now with only $2.99✅️ Join Now: kzbin.info/door/v-xyS0YxYCrEoMFH_cgcoQjoin

@advaitshinde6609 8 ай бұрын

@@CODE_ROOM 🫡🫡🫡

@soumahorosoualiho5825 2 ай бұрын

Hi. Thanks too much. But it is not possible to update multiple data at the same time. Only one can be updated. Can you fix that?

@svnbeats6700 11 ай бұрын

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 ?

@CODE_ROOM 11 ай бұрын

Glad it helps! Yes, I have some knowledge about PyQt.

@svnbeats6700 11 ай бұрын

do you have some tutorials @@CODE_ROOM

@CODE_ROOM 11 ай бұрын

Currently no, but will do in the future.✅️

@shafiqsobhani Жыл бұрын

Awesome

@CODE_ROOM Жыл бұрын

Thanks.

@rachidaajbayr2867 6 ай бұрын

Thanks a lot

@CODE_ROOM 6 ай бұрын

Welcome :)

@ea1766 Жыл бұрын

Good man

@ahmedsaliem7041 7 ай бұрын

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

@CODE_ROOM 7 ай бұрын

Will try to make a tutorial about this in the future :)

@ahmedsaliem7041 7 ай бұрын

@CODE_ROOM Thanks a lot 🙏🏼 🙏🏼

@ВладиславУндерко 7 ай бұрын

Really nice project, how can i find the whole project??

@CODE_ROOM 7 ай бұрын

✨️Subscribe for more quizzes✨️

@rhenchiri Жыл бұрын

Great work,i'm new in programming,i hope you send the code if possible,Thanks anyway.....

@CODE_ROOM Жыл бұрын

@JhonorlyOlaco 8 ай бұрын

error in line bro from tk(module) database?

@josemarquez-py9wp Жыл бұрын

muy bueno tu programapuedes compatir el codigo fuente..??

@CODE_ROOM Жыл бұрын

@zhironggu-j1m Жыл бұрын

what shoule i do to use sqlite3,such as download sth?

@CODE_ROOM Жыл бұрын

It is already installed starting from Python 2.5, just import it in your file.

@zhironggu-j1m Жыл бұрын

thank you

@CODE_ROOM Жыл бұрын

Anytime.

@zhironggu-j1m Жыл бұрын

in display_data I need to write“clear('true')”,otherwise datas at entry cannot be deleted @@CODE_ROOM

@crazyboy5350 10 ай бұрын

Module not found database, what can I do?

@CODE_ROOM 10 ай бұрын

Make sure that you have created this file database with this name correctly.

@vanyaspams 11 ай бұрын

The update function is not working for me, even though it show 'has been updated'😭

@CODE_ROOM 11 ай бұрын

Can you reply with your function?

@vanyaspams 11 ай бұрын

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.')

@CODE_ROOM 11 ай бұрын

Your function seems to be correct. Check add_to_treeview function and the update_employee function in the database.

@vanyaspams 11 ай бұрын

#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()

@vanyaspams 11 ай бұрын

I can't find what's wrong here

@nasifswalah7030 3 ай бұрын

Can i share this system with others as an executable file ?

@CODE_ROOM 3 ай бұрын

Yes.

@nasifswalah7030 3 ай бұрын

@@CODE_ROOM Which is the best way to convert it to an executable file

@Venus_network Жыл бұрын

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 🙏🏼

@CODE_ROOM Жыл бұрын

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

@user_wstech 6 ай бұрын

Update button not work 😭

@CODE_ROOM 6 ай бұрын

Please, show me the issue in your code.

@jamlickariuki 8 ай бұрын

How do i access the code, no link?

@CODE_ROOM 8 ай бұрын

Get UNLIMITED access to source codes now with only $2.99✅️ Join Now: kzbin.info/door/v-xyS0YxYCrEoMFH_cgcoQjoin

@PANDURANG99 Жыл бұрын

Search and filter?

@CODE_ROOM Жыл бұрын

This can help you implementing the search: kzbin.info/www/bejne/poiVY6iubd9pn8U

@NOTHING-uk4cw 9 ай бұрын

❤❤❤❤

@VictorAugusto-u5m 11 ай бұрын

Man, you just can create functions for label and entry, is a better choice

@CODE_ROOM 11 ай бұрын

definitely, especially if you have a more complex project.

@theshadow4390 9 ай бұрын

could wrap the code to see all of it please ??? and thank's

@CODE_ROOM 9 ай бұрын

Will consider that in next videos.

@GamerDhairya 8 ай бұрын

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

@CODE_ROOM 8 ай бұрын

It should be CTkEntry not CTkLabel.

@Mattykkk25 Жыл бұрын

Where is the file to download?

@CODE_ROOM Жыл бұрын

@WanawahdieDuhabil 7 ай бұрын

Can i get the code in file?

@CODE_ROOM 7 ай бұрын

Get UNLIMITED access to source codes now with only $2.99✅️ Join Now: kzbin.info/door/v-xyS0YxYCrEoMFH_cgcoQjoin

@ZulqernainNasir 4 ай бұрын

I want source code of this project. Plz provide me

@CODE_ROOM 4 ай бұрын

Access this project and all other source codes with only ✨️$2.99✨️. Join from here✅️: kzbin.info/door/v-xyS0YxYCrEoMFH_cgcoQjoin

@Azad_SAYz 8 ай бұрын

Where the source code

@CODE_ROOM 8 ай бұрын

Get UNLIMITED access to source codes now with only $2.99✅️ Join Now: kzbin.info/door/v-xyS0YxYCrEoMFH_cgcoQjoin

@adent07 Жыл бұрын

source code broo

@CODE_ROOM Жыл бұрын

@iamsherk2605 Жыл бұрын

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 😭😭😭

@CODE_ROOM Жыл бұрын

What is the problem with your code?

@iamsherk2605 Жыл бұрын

@@CODE_ROOMThe update and delete function does not work for me. I'm still looking for the bug

@iamsherk2605 Жыл бұрын

@@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 😭😭😭😭

@unknown2you2004 Жыл бұрын

Bro Please give me source code of the Program

@CODE_ROOM Жыл бұрын

@gerryhoekema2561 Жыл бұрын

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)

@CODE_ROOM Жыл бұрын

Nice suggestion! Will consider in next tutorials.