CREATE DATABASE shopping_db;
 
USE shopping_db;
 
CREATE TABLE items (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    price INT
);
 
INSERT INTO items (name, price) VALUES 
('Rice', 160),
('Potato', 80),
('Tomato', 70),
('Wheat', 150),
('Pulses', 180),
('Onion', 100),
('Sugar', 80),
('Salt', 60),
('Spices', 100);
import mysql.connector
 
# Establish a connection to the database
db = mysql.connector.connect(
    host="localhost",  # Change to your MySQL host
    user="root",  # MySQL username
    password="yourpassword",  # MySQL password
    database="shopping_db"  # Database name
)
 
cursor = db.cursor()
 
# Function to display available items
def display_items():
    cursor.execute("SELECT id, name, price FROM items")
    items = cursor.fetchall()
    print("\nAvailable items:")
    for item in items:
        print(f"{item[0]}. {item[1]} - Rs. {item[2]}")
 
# Function to handle item selection
def select_items():
    selected_items = []
    while True:
        try:
            item_id = int(input("\nEnter the item ID to select (or 0 to finish): "))
            if item_id == 0:
                break
            cursor.execute("SELECT name, price FROM items WHERE id = %s", (item_id,))
            item = cursor.fetchone()
            if item:
                selected_items.append(item)
                print(f"Added {item[0]} to the cart.")
            else:
                print("Invalid item ID. Please try again.")
        except ValueError:
            print("Please enter a valid number.")
 
    return selected_items
 
# Function to calculate total price
def calculate_bill(selected_items):
    total_price = sum(item[1] for item in selected_items)
    return total_price
 
# Function to print the bill
def print_bill(selected_items, total_price):
    print("\nFinal Bill:")
    print("------------")
    for item in selected_items:
        print(f"{item[0]} - Rs. {item[1]}")
    print(f"Total: Rs. {total_price}")
 
def main():
    display_items()  # Show available items
    selected_items = select_items()  # Allow user to select items
    if selected_items:
        total_price = calculate_bill(selected_items)  # Calculate total price
        print_bill(selected_items, total_price)  # Show final bill
    else:
        print("No items selected.")
 
    # Close the database connection
    db.close()
 
# Run the program
if _name_ == "_main_":
    main()
 

Q1JFQVRFIERBVEFCQVNFIHNob3BwaW5nX2RiOwoKVVNFIHNob3BwaW5nX2RiOwoKQ1JFQVRFIFRBQkxFIGl0ZW1zICgKICAgIGlkIElOVCBBVVRPX0lOQ1JFTUVOVCBQUklNQVJZIEtFWSwKICAgIG5hbWUgVkFSQ0hBUig1MCksCiAgICBwcmljZSBJTlQKKTsKCklOU0VSVCBJTlRPIGl0ZW1zIChuYW1lLCBwcmljZSkgVkFMVUVTIAooJ1JpY2UnLCAxNjApLAooJ1BvdGF0bycsIDgwKSwKKCdUb21hdG8nLCA3MCksCignV2hlYXQnLCAxNTApLAooJ1B1bHNlcycsIDE4MCksCignT25pb24nLCAxMDApLAooJ1N1Z2FyJywgODApLAooJ1NhbHQnLCA2MCksCignU3BpY2VzJywgMTAwKTsKaW1wb3J0IG15c3FsLmNvbm5lY3RvcgoKIyBFc3RhYmxpc2ggYSBjb25uZWN0aW9uIHRvIHRoZSBkYXRhYmFzZQpkYiA9IG15c3FsLmNvbm5lY3Rvci5jb25uZWN0KAogICAgaG9zdD0ibG9jYWxob3N0IiwgICMgQ2hhbmdlIHRvIHlvdXIgTXlTUUwgaG9zdAogICAgdXNlcj0icm9vdCIsICAjIE15U1FMIHVzZXJuYW1lCiAgICBwYXNzd29yZD0ieW91cnBhc3N3b3JkIiwgICMgTXlTUUwgcGFzc3dvcmQKICAgIGRhdGFiYXNlPSJzaG9wcGluZ19kYiIgICMgRGF0YWJhc2UgbmFtZQopCgpjdXJzb3IgPSBkYi5jdXJzb3IoKQoKIyBGdW5jdGlvbiB0byBkaXNwbGF5IGF2YWlsYWJsZSBpdGVtcwpkZWYgZGlzcGxheV9pdGVtcygpOgogICAgY3Vyc29yLmV4ZWN1dGUoIlNFTEVDVCBpZCwgbmFtZSwgcHJpY2UgRlJPTSBpdGVtcyIpCiAgICBpdGVtcyA9IGN1cnNvci5mZXRjaGFsbCgpCiAgICBwcmludCgiXG5BdmFpbGFibGUgaXRlbXM6IikKICAgIGZvciBpdGVtIGluIGl0ZW1zOgogICAgICAgIHByaW50KGYie2l0ZW1bMF19LiB7aXRlbVsxXX0gLSBScy4ge2l0ZW1bMl19IikKCiMgRnVuY3Rpb24gdG8gaGFuZGxlIGl0ZW0gc2VsZWN0aW9uCmRlZiBzZWxlY3RfaXRlbXMoKToKICAgIHNlbGVjdGVkX2l0ZW1zID0gW10KICAgIHdoaWxlIFRydWU6CiAgICAgICAgdHJ5OgogICAgICAgICAgICBpdGVtX2lkID0gaW50KGlucHV0KCJcbkVudGVyIHRoZSBpdGVtIElEIHRvIHNlbGVjdCAob3IgMCB0byBmaW5pc2gpOiAiKSkKICAgICAgICAgICAgaWYgaXRlbV9pZCA9PSAwOgogICAgICAgICAgICAgICAgYnJlYWsKICAgICAgICAgICAgY3Vyc29yLmV4ZWN1dGUoIlNFTEVDVCBuYW1lLCBwcmljZSBGUk9NIGl0ZW1zIFdIRVJFIGlkID0gJXMiLCAoaXRlbV9pZCwpKQogICAgICAgICAgICBpdGVtID0gY3Vyc29yLmZldGNob25lKCkKICAgICAgICAgICAgaWYgaXRlbToKICAgICAgICAgICAgICAgIHNlbGVjdGVkX2l0ZW1zLmFwcGVuZChpdGVtKQogICAgICAgICAgICAgICAgcHJpbnQoZiJBZGRlZCB7aXRlbVswXX0gdG8gdGhlIGNhcnQuIikKICAgICAgICAgICAgZWxzZToKICAgICAgICAgICAgICAgIHByaW50KCJJbnZhbGlkIGl0ZW0gSUQuIFBsZWFzZSB0cnkgYWdhaW4uIikKICAgICAgICBleGNlcHQgVmFsdWVFcnJvcjoKICAgICAgICAgICAgcHJpbnQoIlBsZWFzZSBlbnRlciBhIHZhbGlkIG51bWJlci4iKQoKICAgIHJldHVybiBzZWxlY3RlZF9pdGVtcwoKIyBGdW5jdGlvbiB0byBjYWxjdWxhdGUgdG90YWwgcHJpY2UKZGVmIGNhbGN1bGF0ZV9iaWxsKHNlbGVjdGVkX2l0ZW1zKToKICAgIHRvdGFsX3ByaWNlID0gc3VtKGl0ZW1bMV0gZm9yIGl0ZW0gaW4gc2VsZWN0ZWRfaXRlbXMpCiAgICByZXR1cm4gdG90YWxfcHJpY2UKCiMgRnVuY3Rpb24gdG8gcHJpbnQgdGhlIGJpbGwKZGVmIHByaW50X2JpbGwoc2VsZWN0ZWRfaXRlbXMsIHRvdGFsX3ByaWNlKToKICAgIHByaW50KCJcbkZpbmFsIEJpbGw6IikKICAgIHByaW50KCItLS0tLS0tLS0tLS0iKQogICAgZm9yIGl0ZW0gaW4gc2VsZWN0ZWRfaXRlbXM6CiAgICAgICAgcHJpbnQoZiJ7aXRlbVswXX0gLSBScy4ge2l0ZW1bMV19IikKICAgIHByaW50KGYiVG90YWw6IFJzLiB7dG90YWxfcHJpY2V9IikKCmRlZiBtYWluKCk6CiAgICBkaXNwbGF5X2l0ZW1zKCkgICMgU2hvdyBhdmFpbGFibGUgaXRlbXMKICAgIHNlbGVjdGVkX2l0ZW1zID0gc2VsZWN0X2l0ZW1zKCkgICMgQWxsb3cgdXNlciB0byBzZWxlY3QgaXRlbXMKICAgIGlmIHNlbGVjdGVkX2l0ZW1zOgogICAgICAgIHRvdGFsX3ByaWNlID0gY2FsY3VsYXRlX2JpbGwoc2VsZWN0ZWRfaXRlbXMpICAjIENhbGN1bGF0ZSB0b3RhbCBwcmljZQogICAgICAgIHByaW50X2JpbGwoc2VsZWN0ZWRfaXRlbXMsIHRvdGFsX3ByaWNlKSAgIyBTaG93IGZpbmFsIGJpbGwKICAgIGVsc2U6CiAgICAgICAgcHJpbnQoIk5vIGl0ZW1zIHNlbGVjdGVkLiIpCgogICAgIyBDbG9zZSB0aGUgZGF0YWJhc2UgY29ubmVjdGlvbgogICAgZGIuY2xvc2UoKQoKIyBSdW4gdGhlIHByb2dyYW0KaWYgX25hbWVfID09ICJfbWFpbl8iOgogICAgbWFpbigpCg==