Tkinter Autocomplete options using date sources from Google sheets or MySQL database or CSV file

Veröffentlicht am: 03 Januar 2022
auf dem Kanal: plus2net

1,185

01:09 Using google sheets data as options for Autocomplete
08:23 Using MySql student table names as options for autocomplete

We can collect data from different sources to create the list. This list is used to pickup the matching options for the Autocomplete based on the user input.
This list can be prepared by taking sources from google sheets.
How to connect and collect data from google sheet is here

The same list can be created by using data from MySQL table, here we are reading names of our student table and the names we are selecting based on the matching string. This part is common to previous part of the tutorial but only the data source is changed from static list to MySQL records.

Part I : Design , adding options and selection
   • Tkinter Autocomplete by using Entry and Li...
Part II : Navigation and selection by arrows
   • Tkinter Autocomplete using down up arrow t...
Part III : Different data sources, Pygsheets , MySQL database
   • Tkinter Autocomplete options using date so...
Part IV : Displaying all product attributes on selection
   • Tkinter autocomplete retrieving other matc...
Part V: Using colour names as source
   • Tkinter autocomplete to browse and select ...

Source code is here
https://www.plus2net.com/python/tkint...

Connecting to google sheets and using google api authorization key
   • Authorization through Google drive API to ...
https://www.plus2net.com/python/pygsh...

Connections and reading data from MySQL database using SQLAlchemy
   • MySQL SELECT Query in Python using fetchal...
Article on connection string to MySQL and collecting rows
https://www.plus2net.com/python/mysql...

MySQL dump of student table
https://www.plus2net.com/sql_tutorial...

#AutocompleteDataSource #PygsheetsDataSourceAutocomplete #OptionsMySQL #MySQLAutocomplete #DataSources #plus2net #Tkinter #Python

Auf dieser Seite können Sie das Online-Video Tkinter Autocomplete options using date sources from Google sheets or MySQL database or CSV file mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer plus2net 03 Januar 2022 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 1,185 Mal angesehen und es wurde von 22 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

19,948

158