how to connect MySQL database to input function

Question

I'm building a program, where the user input an enterprise's name to get the code running.

I would like the user to pick the enterprise name in a drop down list, but currently i dont have a GUI to make it work.

so for now, I would like to connect the input function to the SQL database enterprises name column.

I already connected SQL to my python code... but how do I connect MySQL to an input function? I want the user to be able to get the information from the database

MY SQL CONNECTION :

import mysql.connector

mydb = mysql.connector.connect(host="localhost", user="nn", passwd="passpass")

mycursor = mydb.cursor()

mycursor.execute("SELECT * FROM listedatabase.entreprises_inspecteurs")

for row in mycursor.fetchall():
    print (row[1])

mydb.close()

python:

enterprise_name = input()

Thank you for helping

I tried this but no luck:

 mydb = mysql.connector.connect(host="localhost", user="nn", passwd="passpass")

    mycursor = mydb.cursor()

    enterprise_name = input()
    mycursor.execute("SELECT n_fabricant FROM listedatabase.entreprises_inspecteurs", (enterprise_name,))
    data = mycursor.fetchall()
    if data:
        code goes there
    else: 
        print('data not found in database')

@SwetankPoddar it linked to google calendar api. Enterprise_name is represented by the SUMMARY description of an event. — user13234289
– user13234289, Commented Apr 27, 2020 at 22:03
You need to add a WHERE clause, you can't just attach data. — tadman
– tadman, Commented Apr 28, 2020 at 20:23

user13234289 · Accepted Answer · 2020-04-29 04:08:36Z

1

 mydb = mysql.connector.connect(host="localhost", user="nn", passwd="passpass")

    mycursor = mydb.cursor()

    enterprise_name = input()
    mycursor.execute("""SELECT n_fabricant FROM listedatabase.entreprises_inspecteurs WHERE n_fabricant = %s"""(event_inspecteur,))
    data = mycursor.fetchall()
    if data:
        code goes there
    else: 
        print('data not found in database')

answered Apr 29, 2020 at 4:08

user13234289

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to connect MySQL database to input function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related