Search Database Treeview By Last Name - Python Tkinter GUI Tutorial 182

In this video we'll add a search database feature to our treebase app.

What do you do when you want to find a specific name in the customers database? In this video we'll add a Search menu to the top of the screen and open a new window that allows us to type in a last name and search the database.

We'll then clear the treeview and return the results.

We'll also add a reset feature that lets us reset the treeview with all the records.

#tkinter #codemy #JohnElder

Timecodes

0:00​​ - Introduction
1:22 - Add Search Menu
2:07 - Create Lookup_Records function
2:33 - Create Search Window
5:42 - Create Search_Records Function
6:31 - Close The Search Window
7:58 - Clear The Treeview
8:46 - Query The Database By Last Name
9:34 - Where Clause
10:18 - Use Like Instead of Equal In Query
11:39 - Reset Treeview Query
13:49 - Conclusion

[Codemycom]

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My YouTube Channel:
▶️ See More At: ✅ Join My Facebook Group:
▶️ Get The Code

[markal]

Brilliant, thanks John. Your courses have made such a difference to my bumbling programming skills. I actually managed to make a treeview search function work albeit different way to yours just from bits from your different courses. Thank you for passing on your skills

[scott]

Starting to look like an old Cobol program 😄 from back in the days.
How about a report button and a print command? Thanks for all the Tkinter help John !

[giuseppegadola]

I just love how you are genuinely excited about what you do 😊. Can we also have a sort column feature like in file explorers? Thanks

[Hydratic]

Thank you for your tutorials! I am creating an app with multiple search entry boxes. I would like the app to ignore the entry boxes that are left empty and only search the inputs the user keyed in. And similarly if all entry boxes are empty, the app should return all the records in my database. How do I do that? Any help is appreciated!

[sushilchettri]

John sir thanks for the series ...I have been able to complete my project by your videos . Thanks alot . I wanted a lil bit help, actually I wanted the data to be printed in a CSV file, can you please tell how can I do that ?

[askpatti]

Okay. So I'm working on my treeview with my book database. I was trying to add a combobox instead of entry boxes in a couple of places. I've got the combobox on the screen, I can select an item and print it to the screen, but I haven't been able to get the selected item to the database. And as I was doing this, using update record, I realized adding a new record would have different code. Can you do a video on this? Thanks!

[DifferentThinker]

Hats off sir 😍😍 how can we make this programme executable. i tried pyinstaller but it gives errors... can you make a video to make it possible to make executable database

[theexpert]

You should use ttk Widgets it looks modern like, ttk.Button() ttk.Entry() But it has a point that you cannot change fg nor bg of them as they have their own style..

[isolated.]

Is there a way to use a search bar without clicking a button? Then, once you type in stuff, it would automatically start removing the unwanted data.

[MMMEHTA]

Brilliant sir, Sir Can u make SQL data fatch only first name who space appier between two words combobox, I make it but it's show error of () after fatch

[waitwhat]

how do I change the search to wildcard si if they search for 'a' only all last names with a will appear. I am stucked

[chrispieczora]

Great Video John, thanks. However getting an error, is there somewhere the complete code for the "Search"?

[tanishgambhir]

Hey, can you start a series on robotics with Python, can't find good tutorials for the same, so asked you if you can?

[bybmsfr]

Hi Sir,
This treeview project help me a lot in py project but I have an issue.
When I add a data from the button and i want immediatly to make a research on this data that return me nothing, like this in my terminal : [ ]

I dont know from where this issue is coming from but if you can help on this that will save me :)
Thx for all of your videos and have a good day.

[yahyaa]

Hey Sir, Can you do tutorials on Visual Basic?
Thx

[doc]

Awesome but how do we do for live search

[codeKeshav]

For John, Python Programming Language is *pudding* 🍮

[anontough]

wth, why you didn't go OOP with tkinter ?