PRODUCT MANAGEMENT SYSTEM USING PYTHON
PRODUCT MANAGEMENT SYSTEM USING PYTHON File Name :"product_crud_opertion.py" import mysql.connector myconn = mysql.connector.connect( host = "localhost", user = "root", password = "5044", database = "prod_info" ) cur = myconn.cursor() def add_prod(): pid = input("\n\t\tEnter Prodcut ID : ") pnm = input("\t\tEnter Product Name : ") pprice = input("\t\tEnter Product Price :") pstk = input("\t\tEnter Product Stock : ") data = (pid, pnm, pprice, pstk) sql = "INSERT INTO prod_tbl values(%s, %s, %s, %s)" cur.execute(sql,data) myconn.commit() def display_prod(): cur.execute("select * from prod_tbl") rec = cur.fetchall() print("\n\t\tPID\tPNAME...