Database input by user

[killerrex]

You forgot to call the create_table function:

import sqlite3
 
conn = sqlite3.connect('dfsl.db')
c = conn.cursor()
 
def create_table():
    c.execute("CREATE TABLE orders (Client TEXT, Model TEXT, Quantity INTEGER, Order_date TEXT, Delivery_date TEXT)")
 
def dynamic_data_entry():
    client = input("client: ")
    model = input("model: ")
    quantity = input("quantity: ")
    order_date = input("order date: ")
    delivery_date = input("Delivery date: ")
 
    c.execute("INSERT INTO orders (Client, Model, Quantity, Order_date, Delivery_date) VALUES (?, ?, ?, ?, ?)",
              (client, model, quantity, order_date, delivery_date))
 
    conn.commit()

# Create the table first
create_table()
# Input the data later
dynamic_data_entry()
 
conn.close()

Also remember that CREATE TABLE will fail if the table exists already in the DB (you can use "CREATE TABLE IF NOT EXISTS")