The Restaurant Point of sales System is developed using python. The project is built to manage items and transactions. To make a new transaction, fields such as: Item and ingredients , qty and payment needs to be selected. If you like to learn point of sales systems step by step, this is the right place to learn from the beginning. …
This tutorial will teach you how to make a Radio button in python tkinter step by step from tkinter import * from tkinter import ttk def selection(): selection = radio.get() selection1 = radio1.get() if(selection==1): item = "C" elif(selection == 2): item = "C++" elif (selection == 3): item = "Java" if (selection1 == 1): item1 = "C#" elif (selection1 == …
The inventory management is developed by python tkinter. The project is built to manage items and transactions. To make a new transaction, fields such as: Fried rice name, qty and payment needs to be selected. If you like to learn point of sales systems step by step, this is the right place to learn from the beginning.
This tutorial will teach you how to make a currency converter using python.
This tutorial will teach you how to get the Last Inserted id in python mysql. i will teach step by step.it will help you to make a inventory system. from tkinter import * from tkinter import messagebox import mysql.connector def Ok(): empname = e2.get() phone = e3.get() salary = e4.get() mysqldb=mysql.connector.connect(host="localhost",user="root",password="",database="payrollpy") mycursor=mysqldb.cursor() try: sql = "INSERT INTO records (id,empname,phone,salary) VALUES …
This tutorial will teach you how to View records using python mysql to the table. import tkinter as tk from tkinter import ttk import mysql.connector def show(): mysqldb = mysql.connector.connect(host="localhost", user="root", password="", database="smschool") mycursor = mysqldb.cursor() mycursor.execute("SELECT id,stname,course,fee FROM record") records = mycursor.fetchall() print(records) for i, (id,stname, course,fee) in enumerate(records, start=1): listBox.insert("", "end", values=(id, stname, course, fee)) mysqldb.close() root = …
This tutorial will teach you how to make Star Rating System in jQuery PHP MYSQL. The rating management system is made to rate an individual’s skillset accordingly. Database connection db_connection.php <?php $servername = "localhost";//Server Name $username = "root";//Server User Name $password = "";//Server Password $dbname = "billdb";//Database Name //Create DB Connection $conn = mysqli_connect($servername,$username,$password,$dbname); ?> add_rate.php <html> <head> <link …
This tutorial will teach you how to search using python Gui application connect with mysql. from tkinter import * import mysql.connector def Ok(): global myresult studname = e1.get() coursename = e2.get() fee = e3.get() mysqldb=mysql.connector.connect(host="localhost",user="root",password="",database="smschool") mycursor=mysqldb.cursor() try: mycursor.execute("SELECT * FROM record where id = '" + studname + "'") myresult = mycursor.fetchall() for x in myresult: print(x) e2.delete(0, END) e2.insert(END, …
This tutorial will teach you how Insert the Records using Python and mysql. Establish the database connection. from tkinter import * from tkinter import messagebox import mysql.connector def Ok(): studname = e1.get() coursename = e2.get() feee = e3.get() mysqldb=mysql.connector.connect(host="localhost",user="root",password="",database="smschool") mycursor=mysqldb.cursor() try: sql = "INSERT INTO record (id,stname,course,fee) VALUES (%s, %s, %s, %s)" val = ("",studname,coursename,feee) mycursor.execute(sql, val) mysqldb.commit() messagebox.showinfo("information", …
This tutorial will teach you to make a small Fish shop Inventory system using python. The following system will use to manage the Fish shop. import tkinter as tk OptionList = [ "kg", "gm", ] def Ok(): item = variable.get() result = float(e1.get()) if item == "kg": tot = result * 120 else : tot = result/1000 * 120 nsalText.set(tot) …
