🔒 Data wont be inserted into database - sqlite3

[pulsar hare]

# IMPORTS TKINTER - GENERAL USER INTERFACE
import tkinter as tk
# IMPORTS TKINTER - UPDATED TKINTER
from tkinter import ttk
# IMPORTS TIME MODULE
from time import sleep
# IMPORTS SQLITE MODULE - DATABASES
import sqlite3
# IMPORTS SQLITE ERROR MODULE
from sqlite3 import Error
# IMPORTS HASHING MODULE
import hashlib
# IMPORTS ENCRYPTION MODULE
import secrets

###############################################################################################################

# RANDOM VARIABLE STORE
accessgranted = ""

# CREATES UNIQUE CONNECTION TO DATABASE
connection = sqlite3.connect('business_management_system.db')

bms = 'business_management_system.db'
       
# ALLOWS DATABASE TO BE MANIPULATED
cursor = connection.cursor()

# CREATES DATABASSE
createtable = """CREATE TABLE IF NOT EXISTS
bms(usernameid TEXT, passwordid TEXT)"""

# CREATES DATABASE TABLE
cursor.execute(createtable)

def loginaccount():
    username = username_field.get()
    password = password_field.get()
    stored_password = cursor.execute("SELECT passwordid FROM bms WHERE usernameid =?", (username,))
    print(username, password)
    if password == stored_password:
        print("Login Successful!")
    else:
        print("Invalid username or password")

#STATEMENT TO CREATE ACCOUNT
def createaccount():
    inputpassword = password_field.get()
    inputusername = username_field.get()
    print(username, password)
    cursor.execute("INSERT INTO bms (usernameid, passwordid) VALUES (?,?)", (inputusername, inputpassword))
    connection.commit
    print("Account Created")
   
NOTE - username and password are gotten from tkinter where i use .get to retrieve the data from the submission box discord didnt let me put the whole code

[versed imp]

@pulsar hare

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[acoustic cedar]

!code

[versed imp]

Formatting code on Discord

Here's how to format Python code on Discord:

```py
print('Hello world!')
```

These are backticks, not quotes. Check this out if you can't find the backtick key.

For long code samples, you can use our pastebin.

[versed imp]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.