timeswhe.blogg.se

Creating a gui for mysql database
Creating a gui for mysql database











creating a gui for mysql database

If you have not seen that video yet, please watch the database videos once so that you can easily understand what we are going to see today. I want 5 attributes here which I used last time as well in our database video. I’ll create a function here which is CreateConn. I’ll select Autosave first so that we don’t need to save it over & over again. We have to work here in the database exactly like we did in PYMySQL. Now we have to establish database connectivity here.įirst of all, I have to make a database connectivity function. Now when I run it.our table is made, right? Then we want Fname that is our First Name. Tick mark in Primary Key & write down the length to be 10. Our database is open in which I have created a database already. If anybody has not seen that video yet, I urge you all to watch it first so that you will be able to find the connection with Tkinter much easier. So to do the database connectivity, we know we have to use PYMySQL here.įirst of all, we will import PYMySQL for our database, how we saw it in our database video. We will run it again & our button’s name is changed to insert. Let’s begin with changing the name of the button. We made Roll No, First Name, Last Name, Email & a button.

creating a gui for mysql database

(dot) PY.Īs soon as I run it, the screen we made last time will appear. Then your code will open up with the path here.Īdd a new file & name it Tkinter. Write the name of the folder where you have to put the file, I wrote CMD. This icon will be Grey instead of Blue as soon as you install the Python plug in. Whatever file you create in Python will automatically use all the syntaxes of Python. Go to Help, Welcome and download & install the support of Python. This software will be used in Django as well.Ī screen will appear where you will get all the needed things. VS code is 1 type of Editor in which we are going to write a code.īecause in Jupyter, it will work very slowly with your database so we switched to VS Code. We are using Windows right now so I’ll select Windows User Installation.Ĭlick on Download & it will be downloaded. (dot) deb for linux, and for Mac as well. You have to install a software which is called VS Code. Inshort, we have to see how to apply connectivity with Tkinter. We will create a table in our database & insert our data accordingly.

creating a gui for mysql database

This screen here, we made one such screen last time, right?

creating a gui for mysql database

We shall see how Tkinter establishes connectivity & how it inserts data. In the last topic we saw Tkinter GUI where we made a GUI based form, an application in which we saw how to make buttons, how to make text boxes, how to make Labels, etc.













Creating a gui for mysql database