Question: In Python 3, create an interface using the tkinter module that looks like the one I posted below. The interface should ask the user for

In Python 3, create an interface using the tkinter module that looks like the one I posted below. The interface should ask the user for their username and password to connect to a remote MySQL database on a server I have (using pymysql). Then the interface should have a textbox that asks the user to enter in an SQL query and then another text box that shows the results of the query.

tk Password Enter SQL User name: ips5a Login SELECTfrom actor , 1 , , , PENELOPE , , , GUINESS , , , 2006-02-15 4: 34: 33 , 2" "NICK, WAHLBERG, 2006-02-1 04:34:33 3, "ED, "CHASE, 2006-02-15 04:34:33 4 JENNIFERDAVIS, 2096-92-15 04:34:33" . 5 . , . JOHNNY' , . LOL LOBRIGIDA , , , 2006-02-15 04: 34: 33 . '6', 'BETTE', 'NICHOLSON', '2996-92-15 4:34:33. 7GRACE "MOSTEL, 2006-02-15 04:34:33" 8, MATTHEW JOHANSSON, 2006-02-15 04:34:33 '9", "JOE', 'SWANK', "2006-02-1564:34 : 33' 10', 'CHRISTIAN GABLE2006-02-15 04:34:33 11', "ZERO, "CAGE, 2006-02-15 04:34:33 12, KARL, 'BERRY, 2006-02-15 64:34:33 13, UMA, 'WO0D, 2006-02-15 04:34:33' 14, 'VIVIEN' BERGEN, 2006-02-15 04:34:33 15', "CUBA, OLIVIER,2006-02-15 04:34:33 16', 'FRED, "COSTNER, '2006-02-15 04:34:33' 17', 'HELEN, 'VOIGHT, '2006-02-15 04:34:33' 18, DAN, TORN, "2006-02-15 84:34:33 19 BOBFAWCETT, '2006-02-15 04:34:33' 20, LUCILLETRACY,2006-02-15 04:34:33 21, 'KIRSTEN, PALTROW "2006-02-15 04:34:33' . 22' , ELVIS' , 'HARX' . . 2006-02-15 04: 34: 33' 23, "SANDRA,"KILMER, 2006-02-15 04:34:33 24, "CAMERON', STREEP, 2006-02-15 04:34:33" 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

In Python 3, use the tkinter module to create an interface similar to the one I posted below. Basically, the interface should ask for a username and password to connect to a MySQL database(using...

In Python 3, use the tkinter module to create an interface similar to the one I posted below. It should ask the user for their username and password to connect to a remote MySQL database(using...

In Python 3, use the tkinter module to create an interface similar to the one below. Keep it simple, it just needs to ask the user for their username and password to connect to a remote MySQL...

PART 1: (HAVE TO USE HTML ON NOTEPAD) Overview: Create a user login page (using HTML and CSS) for a receptionist at a local Pet Hotel called Happy Tails Hotel (HTH). Task Description: Scenario...

write this program in PYTHON LANGUAGE please Write a software (GUI) that can be used to encrypt and decrypt text messages. There should be no limit on the size of the message. Your program should...

PYTHON Write a software (GUI) that can be used to encrypt and decrypt text messages. There should be no limit on the size of the message. Your program should first ask the user if she/he wants to...

please use python and screenshot the codes. Please make sure to mention each part with the screenshot Write a software (GUI) that can be used to encrypt and decrypt text messages. There should be no...

I have create 3 modules but the code are not fully correct, can you help me fix it? these are the requirements Purpose of this Lab: The purpose of this lab is to get you used to networking by using...

Hello there. I really need help writing this python code for multiprocessing using the rsync command to fix a slow system. I've posted the question before but I guess I didn't attach enough details,...

Background Information This assignment tests your understanding of and ability to apply the programming concepts we have covered throughout the unit. The concepts covered in the second half of the...

Refer to Exercise 4.52. a. Are events A and B mutually exclusive? Explain. b. Are events A and B independent? Explain. Exercise 4.52 An experiment can result in one or both of events A and B with the...

(a) You have been provided with the statements of profit or loss and other comprehensive income of Back ple and Stop Limited for the year ended 31 December 2019. 3. Statements of Profit or Loss and...

Q Hacmilan Leare You bry $ 1 , 0 0 0 worth of Walmart stock. Would a macrueconomist call this an ievestment? Yes, because you ane purchasing semething that many yicld moee value later. No , because...

As the new accountant for Cohen & Company, you have been asked to provide a succinct analysis of financial performance for the year just ended. You obtain the following information that pertains to...

2. How could Uber effectively compete with Didi? Should it compete head-on in China, or should it side-step competition by focusing on niche markets through service innovation, and geographic...

1. What do you see as the key differences between pension fund auditing and management consulting? How good is the fit between the two?

4. What effect does the practice of corporate social responsibility have on brand equity?