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 […]

Search using python tkinter mysql Read More »

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 =

Insert Records using Python tkinter mysql Read More »

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()) /

How to make the Calculator in python Read More »

Student Marks Calculation System Using python

This tutorial will teach you Student Marks Calculation System Using python console application.in order to calculate the grade using following condition Input student marks to calculating the total,grade. the grade is awared as “Pass” when the average is more than 50.otherwise grade is fail. marks1 = int(input(“Enter Your Marks 1 “)) marks2 = int(input(“Enter Your

Student Marks Calculation System Using python Read More »