importing data from MySQL using python and tkinter

$2-8 USD / hour

Closed

Posted

about 4 years ago

$2-8 USD / hour

I am trying to import file from MYSQL, python and tkinter with input field order ID import pymysql from tkinter import * from tkinter import messagebox import [login to view URL] as sql import pandas as pd def search(): try: db_connection = [login to view URL](host='localhost', database='northwind', user='xxxx', password='xxxx') db_cursor = [login to view URL]() [login to view URL]("SELECT * FROM orders WHERE OrderID=%s" % [login to view URL]()) table_rows = [login to view URL]() df = [login to view URL](table_rows) df [login to view URL](state='disable') [login to view URL]() except: [login to view URL]('No Data','No Such Data available') clear() def clear(): [login to view URL]('') [login to view URL](state='normal') w1 =Tk() [login to view URL]('My App') [login to view URL]('500x200') ptitle = Label(w1, text='''Order Details''') [login to view URL](row=0,column=0,columnspan=2) orderid = StringVar() 11=Label(w1, text = ' Order ID ') e1=Entry(w1, textvariable= orderid ) b1=Button(w1, text = 'Search', command=search) [login to view URL](row = 1, column = 0) [login to view URL](row = 1, column = 1) [login to view URL](row=1, column=2) [login to view URL](row=4, column=0) [login to view URL]() my code is not working, I want proper code.

Python

MySQL

Project ID: 25629545

About the project

14 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

14 freelancers are bidding on average $15 USD/hour for this job

@bindmission

Hello Hope you are doing well. I have 7 years of experience in MySQL DB management and Python. I can do the importing. Regards VishnuLal*

$10 USD in 10 days

4.9

(145 reviews)

6.1

@Donc310

Hi , My name is Chris , I read your requirements , I can help you perform your migrations from mysql ..

$10 USD in 40 days

4.4

(26 reviews)

5.3

@n4taklyukina

Hello, I am really interested in your project. Especially I have rich experience in C/C++, Python, Machine Learning Algorithm. If you need, I can show you my previous work. I can work full time in your time zone and I am sure that I can satisfy your requirements with my skill and experience. I want to discuss any details over chat. Best Regards. Skills: Python, C/C++, Java, C#, ML, Web Scraping

$5 USD in 40 days

5.0

(17 reviews)

4.2

@hammabouzazi

Hi there, I checked the code in the job description extremely carefully, I can fix it for you and make you a code who can import data from your database and work correctly. I have worked on many similar projects to what you are looking for. Send a message to further discuss this. Regards

$5 USD in 24 days

5.0

(10 reviews)

4.3

@anuragaadi

Hi! I have carefully read the requirements of the project, And all the requirements meet my skills and experience level. I am absolutely sure that I can do the project very well and I think all your requirement meets with my skill and expertise level with skills including MySQL and Python. Let me introduce myself, I am a freelancer and director of a web design company. We are a team of professionals with more than 10 years of experience and we can ensure complete customer satisfaction. Actual price and time will depend on work, Let's discuss more about your project in the chat box, Thank you, Anurag Saxena

$100 USD in 15 days

5.0

(6 reviews)

3.2

@PrashantR6

We work with a team of an experienced software engineer who has worked for a long time in the corporate field. We ensure full customer satisfaction by providing a reasonable amount of reviews to the projects we handle. We are experienced in the following fields: ✔ Web Development (ASP.NET, PHP, Django, React, Flask) ✔ Android with Java, Flutter, Kotlin, Xamarin, React Native ✔ IOS with swift, Flutter, Xamarin, React Native ✔ Unreal Engine, Unity Engine Game Development ✔ UI/UX Design (Adobe XD, Photoshop, Illustrator) ✔ Blockchain ✔ Machine Learning with Python ✔ Data Analysis ✔ Research Paper writing (We have an article written for Springer, ACM, and IEEE)

$10 USD in 40 days

4.8

(5 reviews)

3.5

@WebDigitalExpert

Hi I am a Certified Python & R Expert. I have good experience dealing with python & R. I'm sure I will complete your project. Let's discuss a few points. I'll not disappoint you

$30 USD in 40 days

4.8

(5 reviews)

2.7

@tejasonweb

Hello There, I have recently completed the similar project with tkinter. I am confident that I will be able to help you with this. Please let me know and we will proceed accordingly. Thank you! Regards, Tejas Rajput

$8 USD in 24 days

5.0

(1 review)

1.5

@kusumakarshukla

I can work on it. Not a bad code. I have understood the project. Please inbox some more information about the project.

$2 USD in 10 days

0.0

(0 reviews)

0.0

@Abhijeet1520

I already have working code with proper setup of PyMySQL So I can easily change the basic details in the code according to your need. Hence it would be great if we can discuss the rest of the details over chat.

$5 USD in 60 days

0.0

(0 reviews)

0.0

@raniyaneenu

i can correct it with out any doubt. I am a python tutor at an programming training institution. I have done a lot of tkinter projects. I knew it well. i can fix it in 1 hour.

$5 USD in 2 days

0.0

(0 reviews)

0.0

@kumarraviranjan1

I can complete this project Relevant Skills and Experience I have relevant skills of tkinter in python and mysql

$6 USD in 10 days

0.0

(0 reviews)

0.0

@niftash

I’m graduate in Bachelor of Engineering, CS. Currently working at a reputed US based financial firm with 5 year work experience. I’ve been working on developing python tools and data analysis. Would like to understand more on your requirement and help you out in completing this project.

$11 USD in 10 days