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

Pubblicato il: 03 gennaio 2022
sul canale di: 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

In questa pagina del sito puoi guardare il video online Tkinter Autocomplete options using date sources from Google sheets or MySQL database or CSV file della durata di ore minuti seconda in buona qualità , che l'utente ha caricato plus2net 03 gennaio 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,185 volte e gli è piaciuto 22 spettatori. Buona visione!

19,948

158