Tutusfunny - Software Development Tutorials

Python Gui Last Insert ID Python Mysql

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 …

View records table using Python tkinter mysql

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 = …

Star Rating System in jQuery PHP MYSQL

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 …

Search using python tkinter mysql

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, …

Insert Records using Python tkinter mysql

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", …

Fish inventory system using python tkinter

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) …

Employee Salary Calculation System python tkinter

This tutorial will teach you to calculating the employee salary using python projects GUI.Input the employee name and the basic salary calculate and display the netsalary using following condition.

Student Marks Calculation Using python tkinter

This tutorial will teach you Student Marks Calculation System Using python tkinter is used to create a graphical user interface in python.In order to calculating the grade using following conditions.if you are interested to learn python tkinter tutorial this is the right place where you learn. Input student marks to calculating the total,grade. the grade is awared as “Pass” when …

How to make the Calculator in python

This tutorial will teach you how to make the simple calculator in python programming.This programming will be able add,subtract,multiply,divide two numbers. from tkinter import * def Add(): result = int(e1.get()) + int(e2.get()) resultText.set(result) def Min(): result = int(e1.get()) - int(e2.get()) resultText.set(result) def Sub(): result = int(e1.get()) * int(e2.get()) resultText.set(result) def Div(): result = int(e1.get()) / int(e2.get()) resultText.set(result) root = Tk() …

JSP Login Validation step by step

This tutorial will teach you how to make JSP Login Validation step by step.

Build a Simple Water System Calculator in Java...

Registration with image upload Java Jdbc(Down...

Touchable shop Pos system using Java...

Build Your First Responsive Login Form Using H...

Java Beans...

Click Here to Buy Our Courses