import mysql.

connector

try:
connection = mysql.connector.connect(
host="localhost",
user="root",
password="1234",
database="ansh"
)

if connection.is_connected():
print("Connected to MySQL Server successfully")
connection.close()

except mysql.connector.Error as err:

print(f"Error: {err}")

import tkinter as tk
from tkinter import ttk, messagebox, filedialog
import json
from datetime import datetime
from collections import defaultdict

class FinanceManager:
def __init__(self, root):
self.root = root
self.root.title("Personal Finance Manager")
 self.root.geometry("800x600")

# Data structures
self.data = {
'income': [],
'expenses': [],
'investments': [],
'loans': [],
'properties': [],
'taxes': [],
'categories': {
'income': ['Salary', 'Investments', 'Others'],
'expenses': ['Food', 'Entertainment', 'Bills', 'Others'],
'investments': ['Stocks', 'Bonds', 'Real Estate', 'Others'],
'loans': ['Mortgage', 'Car Loan', 'Personal Loan', 'Others'],
'properties': ['Residential', 'Commercial', 'Land', 'Others']
},
'budgets': defaultdict(float)
}

# Setup GUI components

self.setup_gui()

def setup_gui(self):
# Notebook for different sections
self.notebook = ttk.Notebook(self.root)
self.notebook.pack(expand=True, fill='both')

# Frames for each section

self.income_frame = ttk.Frame(self.notebook)
self.expenses_frame = ttk.Frame(self.notebook)
self.investments_frame = ttk.Frame(self.notebook)
self.loans_frame = ttk.Frame(self.notebook)
self.properties_frame = ttk.Frame(self.notebook)
self.taxes_frame = ttk.Frame(self.notebook)
self.report_frame = ttk.Frame(self.notebook)
self.budget_frame = ttk.Frame(self.notebook)

self.notebook.add(self.income_frame, text="Income")
self.notebook.add(self.expenses_frame, text="Expenses")
self.notebook.add(self.investments_frame, text="Investments")
self.notebook.add(self.loans_frame, text="Loans")
self.notebook.add(self.properties_frame, text="Properties")
self.notebook.add(self.taxes_frame, text="Taxes")
self.notebook.add(self.report_frame, text="Reports")
self.notebook.add(self.budget_frame, text="Budgets")

# Income section
self.setup_income_section()
# Expenses section
self.setup_expenses_section()
# Investments section
self.setup_investments_section()
# Loans section
self.setup_loans_section()
# Properties section
self.setup_properties_section()
# Taxes section
self.setup_taxes_section()
# Report section
 self.setup_report_section()
# Budget section
self.setup_budget_section()

# Menu
self.setup_menu()

def setup_income_section(self):
ttk.Label(self.income_frame, text="Income Entry", font=("Arial", 16)).pack(pady=10)
form_frame = ttk.Frame(self.income_frame)
form_frame.pack(pady=20)

ttk.Label(form_frame, text="Description").grid(row=0, column=0, padx=5, pady=5)

self.income_description = ttk.Entry(form_frame, width=40)
self.income_description.grid(row=0, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Amount").grid(row=1, column=0, padx=5, pady=5)

self.income_amount = ttk.Entry(form_frame, width=40)
self.income_amount.grid(row=1, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Category").grid(row=2, column=0, padx=5, pady=5)

self.income_category = ttk.Combobox(form_frame, values=self.data['categories']['income'])
self.income_category.grid(row=2, column=1, padx=5, pady=5)
self.income_category.current(0) # Set default value

ttk.Button(form_frame, text="Add Income", command=self.add_income).grid(row=3, column=0, columnspan=2, pady=10)

 self.income_list = ttk.Treeview(self.income_frame, columns=("Description", "Amount", "Category", "Date"),
show='headings')
self.income_list.heading("Description", text="Description")
self.income_list.heading("Amount", text="Amount")
self.income_list.heading("Category", text="Category")
self.income_list.heading("Date", text="Date")
self.income_list.pack(pady=20, padx=20, fill='both', expand=True)

def setup_expenses_section(self):
ttk.Label(self.expenses_frame, text="Expenses Entry", font=("Arial", 16)).pack(pady=10)
form_frame = ttk.Frame(self.expenses_frame)
form_frame.pack(pady=20)

ttk.Label(form_frame, text="Description").grid(row=0, column=0, padx=5, pady=5)

self.expenses_description = ttk.Entry(form_frame, width=40)
self.expenses_description.grid(row=0, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Amount").grid(row=1, column=0, padx=5, pady=5)

self.expenses_amount = ttk.Entry(form_frame, width=40)
self.expenses_amount.grid(row=1, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Category").grid(row=2, column=0, padx=5, pady=5)

self.expenses_category = ttk.Combobox(form_frame, values=self.data['categories']['expenses'])
self.expenses_category.grid(row=2, column=1, padx=5, pady=5)
self.expenses_category.current(0) # Set default value

ttk.Button(form_frame, text="Add Expense", command=self.add_expense).grid(row=3, column=0, columnspan=2,

 pady=10)

self.expenses_list = ttk.Treeview(self.expenses_frame, columns=("Description", "Amount", "Category", "Date"),

show='headings')
self.expenses_list.heading("Description", text="Description")
self.expenses_list.heading("Amount", text="Amount")
self.expenses_list.heading("Category", text="Category")
self.expenses_list.heading("Date", text="Date")
self.expenses_list.pack(pady=20, padx=20, fill='both', expand=True)

def setup_investments_section(self):
ttk.Label(self.investments_frame, text="Investment Entry", font=("Arial", 16)).pack(pady=10)
form_frame = ttk.Frame(self.investments_frame)
form_frame.pack(pady=20)

ttk.Label(form_frame, text="Description").grid(row=0, column=0, padx=5, pady=5)

self.investment_description = ttk.Entry(form_frame, width=40)
self.investment_description.grid(row=0, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Amount").grid(row=1, column=0, padx=5, pady=5)

self.investment_amount = ttk.Entry(form_frame, width=40)
self.investment_amount.grid(row=1, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Category").grid(row=2, column=0, padx=5, pady=5)

self.investment_category = ttk.Combobox(form_frame, values=self.data['categories']['investments'])
self.investment_category.grid(row=2, column=1, padx=5, pady=5)
self.investment_category.current(0) # Set default value
 ttk.Button(form_frame, text="Add Investment", command=self.add_investment).grid(row=3, column=0, columnspan=2,
pady=10)

self.investment_list = ttk.Treeview(self.investments_frame,
columns=("Description", "Amount", "Category", "Date"), show='headings')
self.investment_list.heading("Description", text="Description")
self.investment_list.heading("Amount", text="Amount")
self.investment_list.heading("Category", text="Category")
self.investment_list.heading("Date", text="Date")
self.investment_list.pack(pady=20, padx=20, fill='both', expand=True)

def setup_loans_section(self):
ttk.Label(self.loans_frame, text="Loan Entry", font=("Arial", 16)).pack(pady=10)
form_frame = ttk.Frame(self.loans_frame)
form_frame.pack(pady=20)

ttk.Label(form_frame, text="Description").grid(row=0, column=0, padx=5, pady=5)

self.loan_description = ttk.Entry(form_frame, width=40)
self.loan_description.grid(row=0, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Amount").grid(row=1, column=0, padx=5, pady=5)

self.loan_amount = ttk.Entry(form_frame, width=40)
self.loan_amount.grid(row=1, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Category").grid(row=2, column=0, padx=5, pady=5)

self.loan_category = ttk.Combobox(form_frame, values=self.data['categories']['loans'])
self.loan_category.grid(row=2, column=1, padx=5, pady=5)
 self.loan_category.current(0) # Set default value

ttk.Button(form_frame, text="Add Loan", command=self.add_loan).grid(row=3, column=0, columnspan=2, pady=10)

self.loan_list = ttk.Treeview(self.loans_frame, columns=("Description", "Amount", "Category", "Date"),

show='headings')
self.loan_list.heading("Description", text="Description")
self.loan_list.heading("Amount", text="Amount")
self.loan_list.heading("Category", text="Category")
self.loan_list.heading("Date", text="Date")
self.loan_list.pack(pady=20, padx=20, fill='both', expand=True)

def setup_properties_section(self):
ttk.Label(self.properties_frame, text="Property Entry", font=("Arial", 16)).pack(pady=10)
form_frame = ttk.Frame(self.properties_frame)
form_frame.pack(pady=20)

ttk.Label(form_frame, text="Description").grid(row=0, column=0, padx=5, pady=5)

self.property_description = ttk.Entry(form_frame, width=40)
self.property_description.grid(row=0, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Value").grid(row=1, column=0, padx=5, pady=5)

self.property_value = ttk.Entry(form_frame, width=40)
self.property_value.grid(row=1, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Category").grid(row=2, column=0, padx=5, pady=5)

self.property_category = ttk.Combobox(form_frame, values=self.data['categories']['properties'])
 self.property_category.grid(row=2, column=1, padx=5, pady=5)
self.property_category.current(0) # Set default value

ttk.Button(form_frame, text="Add Property", command=self.add_property).grid(row=3, column=0, columnspan=2,

pady=10)

self.property_list = ttk.Treeview(self.properties_frame, columns=("Description", "Value", "Category", "Date"),

show='headings')
self.property_list.heading("Description", text="Description")
self.property_list.heading("Value", text="Value")
self.property_list.heading("Category", text="Category")
self.property_list.heading("Date", text="Date")
self.property_list.pack(pady=20, padx=20, fill='both', expand=True)

def setup_taxes_section(self):
ttk.Label(self.taxes_frame, text="Tax Entry", font=("Arial", 16)).pack(pady=10)
form_frame = ttk.Frame(self.taxes_frame)
form_frame.pack(pady=20)

ttk.Label(form_frame, text="Description").grid(row=0, column=0, padx=5, pady=5)

self.tax_description = ttk.Entry(form_frame, width=40)
self.tax_description.grid(row=0, column=1, padx=5, pady=5)

ttk.Label(form_frame, text="Amount").grid(row=1, column=0, padx=5, pady=5)

self.tax_amount = ttk.Entry(form_frame, width=40)
self.tax_amount.grid(row=1, column=1, padx=5, pady=5)
 ttk.Label(form_frame, text="Category").grid(row=2, column=0, padx=5, pady=5)
self.tax_category = ttk.Combobox(form_frame, values=self.data['categories']['expenses'])
self.tax_category.grid(row=2, column=1, padx=5, pady=5)
self.tax_category.current(0) # Set default value

ttk.Button(form_frame, text="Add Tax", command=self.add_tax).grid(row=3, column=0, columnspan=2, pady=10)

self.tax_list = ttk.Treeview(self.taxes_frame, columns=("Description", "Amount", "Category", "Date"),

show='headings')
self.tax_list.heading("Description", text="Description")
self.tax_list.heading("Amount", text="Amount")
self.tax_list.heading("Category", text="Category")
self.tax_list.heading("Date", text="Date")
self.tax_list.pack(pady=20, padx=20, fill='both', expand=True)

def setup_report_section(self):
ttk.Label(self.report_frame, text="Reports", font=("Arial", 16)).pack(pady=10)
self.report_text = tk.Text(self.report_frame, wrap='word', height=20, width=80)
self.report_text.pack(pady=20)

ttk.Button(self.report_frame, text="Generate Report", command=self.generate_report).pack()

def setup_budget_section(self):
ttk.Label(self.budget_frame, text="Budget Management", font=("Arial", 16)).pack(pady=10)
form_frame = ttk.Frame(self.budget_frame)
form_frame.pack(pady=20)
 ttk.Label(form_frame, text="Category").grid(row=0, column=0, padx=5, pady=5)
self.budget_category = ttk.Combobox(form_frame, values=self.data['categories']['expenses'])
self.budget_category.grid(row=0, column=1, padx=5, pady=5)
self.budget_category.current(0) # Set default value

ttk.Label(form_frame, text="Budget Amount").grid(row=1, column=0, padx=5, pady=5)

self.budget_amount = ttk.Entry(form_frame, width=40)
self.budget_amount.grid(row=1, column=1, padx=5, pady=5)

ttk.Button(form_frame, text="Set Budget", command=self.set_budget).grid(row=2, column=0, columnspan=2, pady=10)

ttk.Button(form_frame, text="View Budgets", command=self.view_budgets).grid(row=3, column=0, columnspan=2,
pady=10)

def setup_menu(self):
menubar = tk.Menu(self.root)
self.root.config(menu=menubar)

file_menu = tk.Menu(menubar, tearoff=0)

menubar.add_cascade(label="File", menu=file_menu)
file_menu.add_command(label="Load Data", command=self.load_data)
file_menu.add_command(label="Save Data", command=self.save_data)
file_menu.add_separator()
file_menu.add_command(label="Exit", command=self.root.quit)

def add_income(self):
description = self.income_description.get()
amount = self.income_amount.get()
category = self.income_category.get()
 if not description or not amount or not category:
messagebox.showerror("Error", "All fields must be filled.")
return

try:
amount = float(amount)
except ValueError:
messagebox.showerror("Error", "Amount must be a number.")
return

entry = {'description': description, 'amount': amount, 'category': category,

'date': datetime.now().strftime("%Y-%m-%d %H:%M:%S")}
self.data['income'].append(entry)
self.income_list.insert('', 'end', values=(description, f"{amount:.2f}", category, entry['date']))
self.income_description.delete(0, tk.END)
self.income_amount.delete(0, tk.END)

def add_expense(self):
description = self.expenses_description.get()
amount = self.expenses_amount.get()
category = self.expenses_category.get()

if not description or not amount or not category:

messagebox.showerror("Error", "All fields must be filled.")
return

try:
 amount = float(amount)
except ValueError:
messagebox.showerror("Error", "Amount must be a number.")
return

entry = {'description': description, 'amount': amount, 'category': category,

'date': datetime.now().strftime("%Y-%m-%d %H:%M:%S")}
self.data['expenses'].append(entry)
self.expenses_list.insert('', 'end', values=(description, f"{amount:.2f}", category, entry['date']))
self.expenses_description.delete(0, tk.END)
self.expenses_amount.delete(0, tk.END)

def add_investment(self):
description = self.investment_description.get()
amount = self.investment_amount.get()
category = self.investment_category.get()

if not description or not amount or not category:

messagebox.showerror("Error", "All fields must be filled.")
return

try:
amount = float(amount)
except ValueError:
messagebox.showerror("Error", "Amount must be a number.")
return

entry = {'description': description, 'amount': amount, 'category': category,

 'date': datetime.now().strftime("%Y-%m-%d %H:%M:%S")}
self.data['investments'].append(entry)
self.investment_list.insert('', 'end', values=(description, f"{amount:.2f}", category, entry['date']))
self.investment_description.delete(0, tk.END)
self.investment_amount.delete(0, tk.END)

def add_loan(self):
description = self.loan_description.get()
amount = self.loan_amount.get()
category = self.loan_category.get()

if not description or not amount or not category:

messagebox.showerror("Error", "All fields must be filled.")
return

try:
amount = float(amount)
except ValueError:
messagebox.showerror("Error", "Amount must be a number.")
return

entry = {'description': description, 'amount': amount, 'category': category,

'date': datetime.now().strftime("%Y-%m-%d %H:%M:%S")}
self.data['loans'].append(entry)
self.loan_list.insert('', 'end', values=(description, f"{amount:.2f}", category, entry['date']))
self.loan_description.delete(0, tk.END)
self.loan_amount.delete(0, tk.END)
def add_property(self):
description = self.property_description.get()
value = self.property_value.get()
category = self.property_category.get()

if not description or not value or not category:

messagebox.showerror("Error", "All fields must be filled.")
return

try:
value = float(value)
except ValueError:
messagebox.showerror("Error", "Value must be a number.")
return

entry = {'description': description, 'value': value, 'category': category,

'date': datetime.now().strftime("%Y-%m-%d %H:%M:%S")}
self.data['properties'].append(entry)
self.property_list.insert('', 'end', values=(description, f"{value:.2f}", category, entry['date']))
self.property_description.delete(0, tk.END)
self.property_value.delete(0, tk.END)

def add_tax(self):
description = self.tax_description.get()
amount = self.tax_amount.get()
category = self.tax_category.get()

if not description or not amount or not category:

 messagebox.showerror("Error", "All fields must be filled.")
return

try:
amount = float(amount)
except ValueError:
messagebox.showerror("Error", "Amount must be a number.")
return

entry = {'description': description, 'amount': amount, 'category': category,

'date': datetime.now().strftime("%Y-%m-%d %H:%M:%S")}
self.data['taxes'].append(entry)
self.tax_list.insert('', 'end', values=(description, f"{amount:.2f}", category, entry['date']))
self.tax_description.delete(0, tk.END)
self.tax_amount.delete(0, tk.END)

def generate_report(self):
total_income = sum(item['amount'] for item in self.data['income'])
total_expenses = sum(item['amount'] for item in self.data['expenses'])
total_investments = sum(item['amount'] for item in self.data['investments'])
total_loans = sum(item['amount'] for item in self.data['loans'])
total_properties = sum(item['value'] for item in self.data['properties'])
total_taxes = sum(item['amount'] for item in self.data['taxes'])
balance = total_income - total_expenses - total_taxes

report = f"Total Income: ${total_income:.2f}\n"

report += f"Total Expenses: ${total_expenses:.2f}\n"
report += f"Total Taxes: ${total_taxes:.2f}\n"
report += f"Balance: ${balance:.2f}\n\n"
 report += "Investment Details:\n"
report += "Description\tAmount\tCategory\tDate\n"
for item in self.data['investments']:
report += f"{item['description']}\t{item['amount']:.2f}\t{item['category']}\t{item['date']}\n"

report += "\nLoan Details:\n"

report += "Description\tAmount\tCategory\tDate\n"
for item in self.data['loans']:
report += f"{item['description']}\t{item['amount']:.2f}\t{item['category']}\t{item['date']}\n"

report += "\nProperty Details:\n"

report += "Description\tValue\tCategory\tDate\n"
for item in self.data['properties']:
report += f"{item['description']}\t{item['value']:.2f}\t{item['category']}\t{item['date']}\n"

report += "\nTax Details:\n"

report += "Description\tAmount\tCategory\tDate\n"
for item in self.data['taxes']:
report += f"{item['description']}\t{item['amount']:.2f}\t{item['category']}\t{item['date']}\n"

self.report_text.delete(1.0, tk.END)
self.report_text.insert(tk.END, report)

def save_data(self):
file_path = filedialog.asksaveasfilename(defaultextension=".json",
filetypes=[("JSON files", "*.json"), ("All files", "*.*")])
if file_path:
with open(file_path, 'w') as file:
 json.dump(self.data, file, indent=4)
messagebox.showinfo("Success", "Data saved successfully.")

def load_data(self):
file_path = filedialog.askopenfilename(filetypes=[("JSON files", "*.json"), ("All files", "*.*")])
if file_path:
with open(file_path, 'r') as file:
self.data = json.load(file)
self.populate_lists()
messagebox.showinfo("Success", "Data loaded successfully.")

def populate_lists(self):
self.income_list.delete(*self.income_list.get_children())
for item in self.data['income']:
self.income_list.insert('', 'end', values=(
item['description'], f"{item['amount']:.2f}", item['category'], item['date']))

self.expenses_list.delete(*self.expenses_list.get_children())
for item in self.data['expenses']:
self.expenses_list.insert('', 'end', values=(
item['description'], f"{item['amount']:.2f}", item['category'], item['date']))

self.investment_list.delete(*self.investment_list.get_children())
for item in self.data['investments']:
self.investment_list.insert('', 'end', values=(
item['description'], f"{item['amount']:.2f}", item['category'], item['date']))

self.loan_list.delete(*self.loan_list.get_children())
 for item in self.data['loans']:
self.loan_list.insert('', 'end',
values=(item['description'], f"{item['amount']:.2f}", item['category'], item['date']))

self.property_list.delete(*self.property_list.get_children())
for item in self.data['properties']:
self.property_list.insert('', 'end', values=(
item['description'], f"{item['value']:.2f}", item['category'], item['date']))

self.tax_list.delete(*self.tax_list.get_children())
for item in self.data['taxes']:
self.tax_list.insert('', 'end',
values=(item['description'], f"{item['amount']:.2f}", item['category'], item['date']))

def set_budget(self):
category = self.budget_category.get()
amount = self.budget_amount.get()

if not category or not amount:

messagebox.showerror("Error", "Category and Budget Amount cannot be empty.")
return

try:
amount = float(amount)
except ValueError:
messagebox.showerror("Error", "Budget Amount must be a number.")
return
 self.data['budgets'][category] = amount
messagebox.showinfo("Success", f"Budget for {category} set to ${amount:.2f}")

def view_budgets(self):
budget_report = "Current Budgets:\n"
for category, amount in self.data['budgets'].items():
budget_report += f"{category}: ${amount:.2f}\n"
messagebox.showinfo("Budgets", budget_report)

if __name__ == "__main__":
root = tk.Tk()
app = FinanceManager(root)
root.mainloop()
import tkinter as tk
from tkinter import ttk
from tkinter import messagebox
import mysql.connector
from datetime import date

# Connect to MySQL
try:
connection = mysql.connector.connect(
host="localhost",
user="root", # Replace with your MySQL username
password="", # Replace with your MySQL password
database="finance_manager"
)
cursor = connection.cursor()
 print("Connected to MySQL database!")
except mysql.connector.Error as err:
print(f"Error: {err}")
exit(1)

# Insert data into MySQL

def insert_data(table, data):
try:
placeholders = ', '.join(['%s'] * len(data))
columns = ', '.join(data.keys())
sql = f"INSERT INTO {table} ({columns}) VALUES ({placeholders})"
cursor.execute(sql, list(data.values()))
connection.commit()
messagebox.showinfo("Success", f"Data added to {table} table successfully!")
except mysql.connector.Error as err:
messagebox.showerror("Error", f"Failed to insert data: {err}")

# Fetch data from MySQL

def fetch_data(table):
try:
cursor.execute(f"SELECT * FROM {table}")
return cursor.fetchall()
except mysql.connector.Error as err:
messagebox.showerror("Error", f"Failed to fetch data: {err}")
return []

# Function to handle Income data submission

def add_income():
data = {
"description": income_desc_entry.get(),
 "amount": income_amount_entry.get(),
"category": income_category_entry.get(),
"date": date.today()
}
insert_data("income", data)
refresh_treeview(income_tree, "income")

# Function to handle Expenses data submission

def add_expense():
data = {
"description": expense_desc_entry.get(),
"amount": expense_amount_entry.get(),
"category": expense_category_entry.get(),
"date": date.today()
}
insert_data("expenses", data)
refresh_treeview(expense_tree, "expenses")

# Function to refresh the Treeview with MySQL data

def refresh_treeview(treeview, table):
for row in treeview.get_children():
treeview.delete(row)
for row in fetch_data(table):
treeview.insert("", "end", values=row)

# Main Tkinter window

root = tk.Tk()
root.title("Personal Finance Manager")
root.geometry("800x600")
notebook = ttk.Notebook(root)
notebook.pack(fill="both", expand=True)

# Income Tab
income_frame = ttk.Frame(notebook)
notebook.add(income_frame, text="Income")

tk.Label(income_frame, text="Description").grid(row=0, column=0)

income_desc_entry = tk.Entry(income_frame)
income_desc_entry.grid(row=0, column=1)

tk.Label(income_frame, text="Amount").grid(row=1, column=0)

income_amount_entry = tk.Entry(income_frame)
income_amount_entry.grid(row=1, column=1)

tk.Label(income_frame, text="Category").grid(row=2, column=0)

income_category_entry = tk.Entry(income_frame)
income_category_entry.grid(row=2, column=1)

tk.Button(income_frame, text="Add Income", command=add_income).grid(row=3, column=1)

income_tree = ttk.Treeview(income_frame, columns=("ID", "Description", "Amount", "Category", "Date"), show="headings")

income_tree.grid(row=4, column=0, columnspan=2)
for col in income_tree["columns"]:
income_tree.heading(col, text=col)
refresh_treeview(income_tree, "income")

# Expenses Tab
expense_frame = ttk.Frame(notebook)
notebook.add(expense_frame, text="Expenses")

tk.Label(expense_frame, text="Description").grid(row=0, column=0)

expense_desc_entry = tk.Entry(expense_frame)
expense_desc_entry.grid(row=0, column=1)

tk.Label(expense_frame, text="Amount").grid(row=1, column=0)

expense_amount_entry = tk.Entry(expense_frame)
expense_amount_entry.grid(row=1, column=1)

tk.Label(expense_frame, text="Category").grid(row=2, column=0)

expense_category_entry = tk.Entry(expense_frame)
expense_category_entry.grid(row=2, column=1)

tk.Button(expense_frame, text="Add Expense", command=add_expense).grid(row=3, column=1)

expense_tree = ttk.Treeview(expense_frame, columns=("ID", "Description", "Amount", "Category", "Date"), show="headings")

expense_tree.grid(row=4, column=0, columnspan=2)
for col in expense_tree["columns"]:
expense_tree.heading(col, text=col)
refresh_treeview(expense_tree, "expenses")

# Run the Tkinter main loop

root.mainloop()

# Close MySQL connection when done

connection.close()