import mysql.connector import time mydb = mysql.connector.connect( host="localhost", user="root", password="1234", database = "contact" ) def intro(): print("="*80) print ("{: ^80s}".format("CONTACT")) print ("{: ^80s}".format("BOOK")) print ("{: ^80s}".format("PROJECT")) print ("{: ^80s}".format("MADE BY: PyForSchool.com")) print("="*80) print() time.sleep(2) def create_record(): name = input("Enter name: ") address = input("Enter address: ") mobile = input("Enter mobile: ") email = input("Enter email: ") mycursor = mydb.cursor() sql = "INSERT INTO book(name,address,mobile,email) VALUES (%s,%s,%s,%s)" record = (name,address,mobile,email) mycursor.execute(sql,record) mydb.commit() mycursor.close() print("Record Entered Succuessfully\n") def search(name): mycursor = mydb.cursor() sql = "select * from book where name = %s" value = (name,) mycursor.execute(sql,value) record = mycursor.fetchone() mycursor.close() if record == None : print("No such record exists") else: print('Name:',record[0]) print('Address:',record[1]) print('Mobile:',record[2]) print('E-mail:',record[3]) def display_all(): mycursor = mydb.cursor() mycursor.execute("select * from book") print('{0:20}{1:30}{2:15}{3:30}'.format('NAME','ADDRESS','MOBILE NO','E-MAIL')) for record in mycursor: print('{0:20}{1:30}{2:15}{3:30}'.format(record[0],record[1], record[2],record[3])) mycursor.close() def delete_record(name): mycursor = mydb.cursor() sql = "DELETE from book WHERE name = %s" value = (name,) mycursor.execute(sql,value) mydb.commit() if mycursor.rowcount == 0: print("Record not found") else: print("Record deleted successfully") mycursor.close() def modify_record(name): mycursor = mydb.cursor() sql = "select * from book where name = %s" value = (name,) mycursor.execute(sql,value) record = mycursor.fetchone() if record == None : print("No such record exists") else: while True: print("\nPress the option you want to edit: ") print("1. Name") print("2. Address") print("3. Mobile") print("4. BACK") print() ch = int(input("Select Your Option (1-4): ")) if ch==1: new_name = input("Enter new name: ") sql = "UPDATE book SET name = %s WHERE name = %s" values = (new_name,name) mycursor.execute(sql,values) mydb.commit() print(mycursor.rowcount, "record updated successfully") elif ch==2: new_address = input("Enter new address: ") sql = "UPDATE book SET address = %s WHERE name = %s" values = (new_address,name) mycursor.execute(sql,values) mydb.commit() print(mycursor.rowcount, "record updated successfully") elif ch==3: new_mobile = input("Enter new mobile : ") sql = "UPDATE book SET mobile = %s WHERE name = %s" values = (new_mobile,name) mycursor.execute(sql,values) mydb.commit() print(mycursor.rowcount, "record updated successfully") elif ch==4: break else: print("invalid choice !!!\n") mycursor.close() def main(): intro() while True: print("\nMAIN MENU ") print("1. ADD NEW RECORD") print("2. SEARCH RECORD") print("3. DISPLAY ALL RECORDS") print("4. DELETE RECORD") print("5. MODIFY RECORD") print("6. EXIT") print() ch = int(input("Select Your Option (1-6): ")) print() if ch==1: print("ADD NEW RECORD") create_record() elif ch==2: print("SEARCH RECORD BY NAME") name = input("Enter name: ") search(name) elif ch==3: print("DISPLAY ALL RECORDS") display_all() elif ch==4: print("DELETE RECORD") name = input("Enter name: ") delete_record(name) elif ch==5: print("MODIFY RECORD") name = input("Enter name: ") modify_record(name) elif ch==6: print("Thanks for using Contact Book") mydb.close() break else: print("Invalid choice") main() # Fix the above code

def add(a, b):
  return a + b

def divide(a, b):
  return a / b

print(add(1, 2))
print(divide(2, 1))