Breaking News: Grepper is joining You.com. Read the official announcement!

if the admin remove users it should ask for account number to be deleted

Stupid Snake answered on November 11, 2023 Popularity 1/10 Helpfulness 1/10

answer if the admin remove users it should ask for account number to be deleted

if the admin remove users it should ask for account number to be deleted

Comment

import sqlite3
from tkinter import Tk, Label, Listbox, Scrollbar, StringVar, Button, Entry, END

# Database connection
conn = sqlite3.connect("your_database.db")
cursor = conn.cursor()

# Tkinter setup
root = Tk()
root.title("Admin Page")

# Function to fetch and display user actions
def display_user_actions():
    # Clear existing data in the Listbox
    user_actions_listbox.delete(0, END)

    # Fetch user actions from the database
    cursor.execute("SELECT * FROM user_actions")
    user_actions = cursor.fetchall()

    # Display user actions in the Listbox
    for action in user_actions:
        user_actions_listbox.insert(END, f"{action[0]} - {action[1]}")  # Assuming action[0] and action[1] are relevant columns

# Function to handle logout
def logout():
    root.destroy()  # Close the Tkinter window
    # You might want to add additional logout logic here

# Function to remove a user
def remove_user():
    account_number_to_remove = entry_account_number.get()

    # Add your logic to remove the user from the database based on the account number
    # Example: cursor.execute("DELETE FROM users WHERE account_number=?", (account_number_to_remove,))
    # Remember to commit the changes to the database: conn.commit()

    # Display a message in the Listbox
    update_output(f"Removed user with account number: {account_number_to_remove}")

    # Refresh the displayed user actions
    display_user_actions()

# Function to update the Text widget
def update_output(message):
    output_text.insert(END, message + "\n")
    output_text.see(END)  # Scroll to the end to show the latest message

# Labels
Label(root, text="User Actions").pack()

# Listbox to display user actions
user_actions_listbox = Listbox(root, height=10, width=50)
user_actions_listbox.pack()

# Scrollbar for the Listbox
scrollbar = Scrollbar(root)
scrollbar.pack(side="right", fill="y")

# Configure Listbox to work with the Scrollbar
user_actions_listbox.config(yscrollcommand=scrollbar.set)
scrollbar.config(command=user_actions_listbox.yview)

# Button to refresh and display user actions
refresh_button = Button(root, text="Refresh", command=display_user_actions)
refresh_button.pack()

# Entry widget to input account number for removal
entry_account_number = Entry(root)
entry_account_number.pack()

# Button to remove user based on account number
remove_user_button = Button(root, text="Remove User", command=remove_user)
remove_user_button.pack()

# Logout button
logout_button = Button(root, text="Logout", command=logout)
logout_button.pack()

# Output Text Widget
output_text = Text(root, height=5, width=50)
output_text.pack()

# Initial display of user actions
display_user_actions()

# Run Tkinter event loop
root.mainloop()

# Close the database connection when done
conn.close()

Popularity 1/10 Helpfulness 1/10 Language python

Source: chat.openai.com

Tags: account admin python

Link to this answer
Share Copy Link

Contributed on Nov 11 2023

Stupid Snake

0 Answers Avg Quality 2/10

if the admin remove users it should ask for account number to be deleted

Contents

More Related Answers

if the admin remove users it should ask for account number to be deleted

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.