Lookup Customer By Last Name in CRM - Python Tkinter GUI Tutorial #33

In this video well learn how to look up customers in our CRM program by their last name.

We'll create a new window that has a search function that lets us type in any name and search our database. It'll then return the results to the screen or give us an error message if no records were found.

[Codemycom]

▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My YouTube Channel:
▶️ See More At: ✅ Join My Facebook Group:
Take $22 off with coupon code: youtube

[paulushimawan]

I was wondering why it is working perfectly although you misspelled "search" in "def search_now()". Turns out the button command was also misspelled into "seach_now" 😀

Anyway, thank you, I learn a lot from you!

[kangsan]

Your video is excellent. When you search names and it comes up at the bottom, instead of it showing up as one line, can you wrap it at certain locations so that it is easier to read?

[nishkalgupta]

Hey, I wanted to know if there are multiple search fields(entry boxes) together and if the user fills in only few search fields, then how does mysql ignore the non filled fields and return the query. for example if there are 4 fields first_name, last_name, email and mobile entry boxes and the user only fills the first two then what query should we use in mysql to ignore email and mobile. It would be really useful if you can answer this as it is useful in my current project.

[slobodantajisic]

Each time we want to access the base, we should establish a connection and then close it later. I think that would be the best practice.

[ConceptCubes]

#15:00 can we highlight the searched text Elder in the searched results below.

[storageaccountiii]

When I tried to search it with uppercase it did not find. But I am using postgres, is it due to that?

[bennysalim]

why i got this error message?
Traceback (most recent call last):
File "C:\Python\Python38-32\lib\tkinter\__init__.py", line 1883, in __call__
return self.func(*args)
File "C:\Workdata\Benny\setup", line 42, in search_now
result = my_cursor.execute(sql, name)
pyodbc.ProgrammingError: ('The SQL contains 0 parameter markers, but 1 parameters were supplied', 'HY000')
Exception in Tkinter callback

[ntfcorreia]

Hi! im new in code. So im using sqlite3 from previous videos. The def searched must different right? Can be this:
searched = search_box.get()
c.execute("SELECT * FROM information WHERE b_name = %s" + searched)
result = c.fetchall()

[drronyvincent]

How can we use Enter key to show search result???

And how to show research result without even typing exact same spelling??

[billstrain]

Forget last question. I changed the search to 'like' instead of =