Open

importing data from MySQL using python and tkinter

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.

Skills: Python, MySQL

See more: importing data mysql sample, example using data mysql using javascript php, data mysql using ajax, grab data mysql using cnet, extracting data webpages using python, display data mysql using ajax, add data mysql using ajax cakephp, save xml data mysql using php, retrieve data mysql using gwt, posting xml data mysql using php, importing data mysql csv file, importing data mysql zencart, edit delete insert data mysql using php, import excel data mysql using php, saving form data mysql using perl, input data mysql using excel, how to store json data in mysql using python, import data from csv to mysql using python, import data from excel into mysql using python, import data from excel into mysql using python.

About the Employer:
( 0 reviews ) Sharjah, United Arab Emirates

Project ID: #25629545

13 freelancers are bidding on average $16/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 / hour
(141 Reviews)
6.1
Donc310

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

$10 USD / hour
(24 Reviews)
5.3
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 wh More

$5 USD / hour
(10 Reviews)
4.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 More

$5 USD / hour
(9 Reviews)
3.7
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 w More

$100 USD / hour
(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. More

$10 USD / hour
(4 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 / hour
(4 Reviews)
2.5
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 Raj More

$8 USD / hour
(1 Review)
1.2
$6 USD / hour
(0 Reviews)
0.0
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 / hour
(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 / hour
(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 / hour
(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 / hour
(0 Reviews)
0.0