▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My TH-cam Channel: bit.ly/2UFLKgj bit.ly/2IGzvOR ▶️ See More At: ✅ Join My Facebook Group: Codemy.com bit.ly/2GFmOBz ▶️ Learn to Code at Codemy.com Take $22 off with coupon code: youtube
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!
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?
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.
I know this is a year old. Keywords in SQL are case-insensitive for the most popular DBMSs. BUT, VARCHAR is case-sensitive in PostgreSQL. Typically a VARCHAR field is treated as case-sensitive in Postgres. Meaning that fieldname = 'FOO' and fieldname = 'foo' won't find any matches when the actual value is "FOO".
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
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()
@H_kailz hi! i assume you made exactly like the videos. So the sqlite code i wrote was this: conn = sqlite3.connect('information.db') c = conn.cursor() searched = search_box.get() name = (searched, ) result = c.execute(sql, name) result = c.fetchall Hope that helps you
@@Codemycom No you're not. I think that each function that accesses the database needs to establish a connection and then close it. For example : def list_customers(): list_customer_query = Tk() list_customer_query.title("List All Customers") list_customer_query.geometry("800x600") mydb = mysql.connector.connect( host="localhost", user="root", passwd="something", database="codemy" ) # Create a cursor and initialize it my_cursor = mydb.cursor() # Query The Database my_cursor.execute("SELECT * FROM customers") results = my_cursor.fetchall() for index, result in enumerate(results): num = 0 for item in result: lookup_label = Label(list_customer_query, text=item) lookup_label.grid(row=index, column=num) num += 1 csv_button = Button(list_customer_query, text="Save to Excel", command=lambda: write_to_csv(results)) csv_button.grid(row=index + 1, column=0) my_cursor.close() mydb.close() But ok. The tutorials are great. Thanks...
▶️ Watch Entire Tkinter Playlist ✅ Subscribe To My TH-cam Channel:
bit.ly/2UFLKgj bit.ly/2IGzvOR
▶️ See More At: ✅ Join My Facebook Group:
Codemy.com bit.ly/2GFmOBz
▶️ Learn to Code at Codemy.com
Take $22 off with coupon code: youtube
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!
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?
Thank you very much for your video.
You are welcome
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.
#15:00 can we highlight the searched text Elder in the searched results below.
When I tried to search it with uppercase it did not find. But I am using postgres, is it due to that?
I know this is a year old. Keywords in SQL are case-insensitive for the most popular DBMSs. BUT, VARCHAR is case-sensitive in PostgreSQL.
Typically a VARCHAR field is treated as case-sensitive in Postgres. Meaning that fieldname = 'FOO' and fieldname = 'foo' won't find any matches when the actual value is "FOO".
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
You have a error on line 42 you need to check your code.
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()
sorry don’t know what you’re asking
@@Codemycom dont worry! Just figure it out! Love the tutorials, keep it up!
@@ntfcorreia ha good!
@H_kailz hi! i assume you made exactly like the videos. So the sqlite code i wrote was this:
conn = sqlite3.connect('information.db')
c = conn.cursor()
searched = search_box.get()
name = (searched, )
result = c.execute(sql, name)
result = c.fetchall
Hope that helps you
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.
Aren't I doing that?
@@Codemycom
No you're not. I think that each function that accesses the database needs to establish a connection and then close it. For example :
def list_customers():
list_customer_query = Tk()
list_customer_query.title("List All Customers")
list_customer_query.geometry("800x600")
mydb = mysql.connector.connect(
host="localhost",
user="root",
passwd="something",
database="codemy"
)
# Create a cursor and initialize it
my_cursor = mydb.cursor()
# Query The Database
my_cursor.execute("SELECT * FROM customers")
results = my_cursor.fetchall()
for index, result in enumerate(results):
num = 0
for item in result:
lookup_label = Label(list_customer_query, text=item)
lookup_label.grid(row=index, column=num)
num += 1
csv_button = Button(list_customer_query, text="Save to Excel", command=lambda: write_to_csv(results))
csv_button.grid(row=index + 1, column=0)
my_cursor.close()
mydb.close()
But ok. The tutorials are great. Thanks...
How can we use Enter key to show search result???
And how to show research result without even typing exact same spelling??
import keyboard
if keyboard.is_pressed('Enter'):
code
this might work for the first part of your question. For the other part, no idea.
@@errorhostnotfound1165 excellent. Was also doing this in processing.js, but I just know in Python it is somewhat similar.
How would I do a wild card search
Search SQL wild card
Forget last question. I changed the search to 'like' instead of =
Cool