import mysql.connector
 
def calculate_bmi(weight, height):
    bmi = (weight)/(height**2)
    return round(bmi,2)
 
 
def get_bmi_category(bmi):
    if bmi < 18.5:
        return "Underweight"
    elif bmi < 25:
        return "Normal"
    elif bmi < 30:
        return "Overweight"
    else:
        return "Obese"
 
 
def diet_plan(category):
    print("\n--- DIET PLAN ---\n")
 
    if category == "Underweight":
        print("-> Eat more protein: eggs, chicken, paneer")
        print("-> Include nuts and healthy fats")
        print("-> Eat 5-6 meals per day")
        print("-> Drink milk with meals")
 
    elif category == "Normal":
        print("-> Maintain balanced diet")
        print("-> Include fruits and vegetables")
        print("-> Drink 8 glasses of water daily")
        print("-> Avoid junk food")
 
    elif category == "Overweight":
        print("-> Reduce rice and sugar intake")
        print("-> Eat more vegetables and salads")
        print("-> Drink green tea")
        print("-> Avoid fried foods")
 
    else:
        print("-> Focus on high protein, low carb diet")
        print("-> Eat lots of vegetables")
        print("-> Avoid sugar and oil completely")
        print("-> Consult a nutritionist")
 
 
def workout_plan(category, age):
    print("\n--- WORKOUT PLAN ---\n")
 
    if category == "Underweight":
        print("-> Strength training: 3 days/week")
        print("-> Push-ups: 3 sets of 10")
        print("-> Squats: 3 sets of 12")
        print("-> Light cardio: 15 minutes")
 
    elif category == "Normal":
        print("-> Cardio: Running/cycling 30 min")
        print("-> Mix of strength and cardio")
        print("-> Exercise 4-5 days/week")
        print("-> Sports or swimming")
 
    elif category == "Overweight":
        print("-> Walking: 45 minutes daily")
        print("-> Light jogging: 20 minutes")
        print("-> Cycling or swimming")
        print("-> Exercise 5-6 days/week")
 
    else:
        print("-> Start with walking: 30-40 minutes")
        print("-> Gradually increase intensity")
        print("-> Avoid high impact exercises initially")
        print("-> Consult doctor before starting")
 
    if age > 50:
        print("\n*Note: Focus on low-impact exercises at your age")
 
 
print("=" * 40)
print("   BMI CALCULATOR & FITNESS PLANNER")
print("=" * 40)
 
 
name = input("\nEnter your name: ")
age = int(input("Enter your age: "))
weight = float(input("Enter your weight (in kg): "))
height = float(input("Enter your height (in cm): "))
height = height / 100  
 
 
bmi = calculate_bmi(weight, height)
category = get_bmi_category(bmi)
 
 
print("\n" + "=" * 40)
print(f"\n Hello {name}!")
print(f"\n Your BMI: {bmi} ")
print(f"\n Category: {category}\n")
print("=" * 40)
 
 
diet_plan(category)
workout_plan(category, age)
 
mydb = mysql.connector.connect(
    host="localhost",
    user="root",
    password="your_password",
    database="fitness_db"
)
 
mycursor = mydb.cursor()
 
sql = "INSERT INTO bmi_records (name, age, weight, height, bmi, category) VALUES (%s, %s, %s, %s, %s, %s)"
val = (name, age, weight, height, bmi, category)
 
mycursor.execute(sql, val)
mydb.commit()
 
print(f"\n Record saved (ID: {mycursor.lastrowid})")
 
mydb.close()
 
 
print("\n" + "=" * 40)
print("\n Stay healthy and fit!\n")
print("=" * 40)
 

aW1wb3J0IG15c3FsLmNvbm5lY3RvcgoKZGVmIGNhbGN1bGF0ZV9ibWkod2VpZ2h0LCBoZWlnaHQpOgogICAgYm1pID0gKHdlaWdodCkvKGhlaWdodCoqMikKICAgIHJldHVybiByb3VuZChibWksMikKCgpkZWYgZ2V0X2JtaV9jYXRlZ29yeShibWkpOgogICAgaWYgYm1pIDwgMTguNToKICAgICAgICByZXR1cm4gIlVuZGVyd2VpZ2h0IgogICAgZWxpZiBibWkgPCAyNToKICAgICAgICByZXR1cm4gIk5vcm1hbCIKICAgIGVsaWYgYm1pIDwgMzA6CiAgICAgICAgcmV0dXJuICJPdmVyd2VpZ2h0IgogICAgZWxzZToKICAgICAgICByZXR1cm4gIk9iZXNlIgoKCmRlZiBkaWV0X3BsYW4oY2F0ZWdvcnkpOgogICAgcHJpbnQoIlxuLS0tIERJRVQgUExBTiAtLS1cbiIpCiAgICAKICAgIGlmIGNhdGVnb3J5ID09ICJVbmRlcndlaWdodCI6CiAgICAgICAgcHJpbnQoIi0+IEVhdCBtb3JlIHByb3RlaW46IGVnZ3MsIGNoaWNrZW4sIHBhbmVlciIpCiAgICAgICAgcHJpbnQoIi0+IEluY2x1ZGUgbnV0cyBhbmQgaGVhbHRoeSBmYXRzIikKICAgICAgICBwcmludCgiLT4gRWF0IDUtNiBtZWFscyBwZXIgZGF5IikKICAgICAgICBwcmludCgiLT4gRHJpbmsgbWlsayB3aXRoIG1lYWxzIikKICAgIAogICAgZWxpZiBjYXRlZ29yeSA9PSAiTm9ybWFsIjoKICAgICAgICBwcmludCgiLT4gTWFpbnRhaW4gYmFsYW5jZWQgZGlldCIpCiAgICAgICAgcHJpbnQoIi0+IEluY2x1ZGUgZnJ1aXRzIGFuZCB2ZWdldGFibGVzIikKICAgICAgICBwcmludCgiLT4gRHJpbmsgOCBnbGFzc2VzIG9mIHdhdGVyIGRhaWx5IikKICAgICAgICBwcmludCgiLT4gQXZvaWQganVuayBmb29kIikKICAgIAogICAgZWxpZiBjYXRlZ29yeSA9PSAiT3ZlcndlaWdodCI6CiAgICAgICAgcHJpbnQoIi0+IFJlZHVjZSByaWNlIGFuZCBzdWdhciBpbnRha2UiKQogICAgICAgIHByaW50KCItPiBFYXQgbW9yZSB2ZWdldGFibGVzIGFuZCBzYWxhZHMiKQogICAgICAgIHByaW50KCItPiBEcmluayBncmVlbiB0ZWEiKQogICAgICAgIHByaW50KCItPiBBdm9pZCBmcmllZCBmb29kcyIpCiAgICAKICAgIGVsc2U6CiAgICAgICAgcHJpbnQoIi0+IEZvY3VzIG9uIGhpZ2ggcHJvdGVpbiwgbG93IGNhcmIgZGlldCIpCiAgICAgICAgcHJpbnQoIi0+IEVhdCBsb3RzIG9mIHZlZ2V0YWJsZXMiKQogICAgICAgIHByaW50KCItPiBBdm9pZCBzdWdhciBhbmQgb2lsIGNvbXBsZXRlbHkiKQogICAgICAgIHByaW50KCItPiBDb25zdWx0IGEgbnV0cml0aW9uaXN0IikKCgpkZWYgd29ya291dF9wbGFuKGNhdGVnb3J5LCBhZ2UpOgogICAgcHJpbnQoIlxuLS0tIFdPUktPVVQgUExBTiAtLS1cbiIpCiAgICAKICAgIGlmIGNhdGVnb3J5ID09ICJVbmRlcndlaWdodCI6CiAgICAgICAgcHJpbnQoIi0+IFN0cmVuZ3RoIHRyYWluaW5nOiAzIGRheXMvd2VlayIpCiAgICAgICAgcHJpbnQoIi0+IFB1c2gtdXBzOiAzIHNldHMgb2YgMTAiKQogICAgICAgIHByaW50KCItPiBTcXVhdHM6IDMgc2V0cyBvZiAxMiIpCiAgICAgICAgcHJpbnQoIi0+IExpZ2h0IGNhcmRpbzogMTUgbWludXRlcyIpCiAgICAKICAgIGVsaWYgY2F0ZWdvcnkgPT0gIk5vcm1hbCI6CiAgICAgICAgcHJpbnQoIi0+IENhcmRpbzogUnVubmluZy9jeWNsaW5nIDMwIG1pbiIpCiAgICAgICAgcHJpbnQoIi0+IE1peCBvZiBzdHJlbmd0aCBhbmQgY2FyZGlvIikKICAgICAgICBwcmludCgiLT4gRXhlcmNpc2UgNC01IGRheXMvd2VlayIpCiAgICAgICAgcHJpbnQoIi0+IFNwb3J0cyBvciBzd2ltbWluZyIpCiAgICAKICAgIGVsaWYgY2F0ZWdvcnkgPT0gIk92ZXJ3ZWlnaHQiOgogICAgICAgIHByaW50KCItPiBXYWxraW5nOiA0NSBtaW51dGVzIGRhaWx5IikKICAgICAgICBwcmludCgiLT4gTGlnaHQgam9nZ2luZzogMjAgbWludXRlcyIpCiAgICAgICAgcHJpbnQoIi0+IEN5Y2xpbmcgb3Igc3dpbW1pbmciKQogICAgICAgIHByaW50KCItPiBFeGVyY2lzZSA1LTYgZGF5cy93ZWVrIikKICAgIAogICAgZWxzZToKICAgICAgICBwcmludCgiLT4gU3RhcnQgd2l0aCB3YWxraW5nOiAzMC00MCBtaW51dGVzIikKICAgICAgICBwcmludCgiLT4gR3JhZHVhbGx5IGluY3JlYXNlIGludGVuc2l0eSIpCiAgICAgICAgcHJpbnQoIi0+IEF2b2lkIGhpZ2ggaW1wYWN0IGV4ZXJjaXNlcyBpbml0aWFsbHkiKQogICAgICAgIHByaW50KCItPiBDb25zdWx0IGRvY3RvciBiZWZvcmUgc3RhcnRpbmciKQogICAgCiAgICBpZiBhZ2UgPiA1MDoKICAgICAgICBwcmludCgiXG4qTm90ZTogRm9jdXMgb24gbG93LWltcGFjdCBleGVyY2lzZXMgYXQgeW91ciBhZ2UiKQoKCnByaW50KCI9IiAqIDQwKQpwcmludCgiICAgQk1JIENBTENVTEFUT1IgJiBGSVRORVNTIFBMQU5ORVIiKQpwcmludCgiPSIgKiA0MCkKCgpuYW1lID0gaW5wdXQoIlxuRW50ZXIgeW91ciBuYW1lOiAiKQphZ2UgPSBpbnQoaW5wdXQoIkVudGVyIHlvdXIgYWdlOiAiKSkKd2VpZ2h0ID0gZmxvYXQoaW5wdXQoIkVudGVyIHlvdXIgd2VpZ2h0IChpbiBrZyk6ICIpKQpoZWlnaHQgPSBmbG9hdChpbnB1dCgiRW50ZXIgeW91ciBoZWlnaHQgKGluIGNtKTogIikpCmhlaWdodCA9IGhlaWdodCAvIDEwMCAgCgoKYm1pID0gY2FsY3VsYXRlX2JtaSh3ZWlnaHQsIGhlaWdodCkKY2F0ZWdvcnkgPSBnZXRfYm1pX2NhdGVnb3J5KGJtaSkKCgpwcmludCgiXG4iICsgIj0iICogNDApCnByaW50KGYiXG4gSGVsbG8ge25hbWV9ISIpCnByaW50KGYiXG4gWW91ciBCTUk6IHtibWl9ICIpCnByaW50KGYiXG4gQ2F0ZWdvcnk6IHtjYXRlZ29yeX1cbiIpCnByaW50KCI9IiAqIDQwKQoKCmRpZXRfcGxhbihjYXRlZ29yeSkKd29ya291dF9wbGFuKGNhdGVnb3J5LCBhZ2UpCgpteWRiID0gbXlzcWwuY29ubmVjdG9yLmNvbm5lY3QoCiAgICBob3N0PSJsb2NhbGhvc3QiLAogICAgdXNlcj0icm9vdCIsCiAgICBwYXNzd29yZD0ieW91cl9wYXNzd29yZCIsCiAgICBkYXRhYmFzZT0iZml0bmVzc19kYiIKKQoKbXljdXJzb3IgPSBteWRiLmN1cnNvcigpCgpzcWwgPSAiSU5TRVJUIElOVE8gYm1pX3JlY29yZHMgKG5hbWUsIGFnZSwgd2VpZ2h0LCBoZWlnaHQsIGJtaSwgY2F0ZWdvcnkpIFZBTFVFUyAoJXMsICVzLCAlcywgJXMsICVzLCAlcykiCnZhbCA9IChuYW1lLCBhZ2UsIHdlaWdodCwgaGVpZ2h0LCBibWksIGNhdGVnb3J5KQoKbXljdXJzb3IuZXhlY3V0ZShzcWwsIHZhbCkKbXlkYi5jb21taXQoKQoKcHJpbnQoZiJcbiBSZWNvcmQgc2F2ZWQgKElEOiB7bXljdXJzb3IubGFzdHJvd2lkfSkiKQoKbXlkYi5jbG9zZSgpCgoKcHJpbnQoIlxuIiArICI9IiAqIDQwKQpwcmludCgiXG4gU3RheSBoZWFsdGh5IGFuZCBmaXQhXG4iKQpwcmludCgiPSIgKiA0MCkK