Design a Python application to obtain a search criteria from user and then fetch records based on that from empl table.

Q. Design a Python application to obtain a search criteria from user and then fetch records based on that from empl table. (Given in Book)

Answer =

import mysql.connector as a
mydb = a.connect(host="localhost",user="root",password="portal express", database = "portal_express")

name = input("Enter the employee name :- ")
cur = mydb.cursor()
run = "select * from Empl where name = '{}'   ".format(name,)
cur . execute(run)
data  = cur.fetchall()
for i in data :
    print(i)

mydb.close()