Python MySQL Connectivity Project for Class 12 - IP CS Class 12 Project

Hey there, in this article I will be giving you complete project for class 12th which is based on python MySQL connection, SQL database and all.

Here, is the source code for the main project file. Also, I would be giving you the instruction file which will help to setup and check the project on your computer.

This project will surely get you full marks in your CBSE Practical examination.

Source Code

---

import mysql.connector as my
from prettytable import PrettyTable    
import os
import platform
con=my.connect(user='root',password='',host='localhost', database="PROGRAMMING_COURSE")
cursor=con.cursor()

def RegisterCourse():
    i=input("Enter Enrollment ID of student")
    n=input("Enter Name of student")
    d=input("Enter Address of student")
    p=input("Enter Phone no. of student")
    a=input("Enter Age of student")
    l=input("Enter Programming Language Selected by Student")
    f=input("Enter Fee Status of Student- Paid or Not Paid:-")    
    sql="INSERT INTO STUDENT VALUES (%s,%s,%s,%s,%s,%s,%s)" 
    L=[i,n,d,p,a,l,f]
    cursor.execute(sql,L)
    con.commit()
    print("Student Id",i,"has been registered successfully")
#-------------------------------------------------------------------------
def OptionMenu():
    print("Enter 1 :- To Register Student in Course")
    print("Enter 2 :- To Edit Student Detail ")
    print("Enter 3 :- To Search Student information ")
    print("Enter 4 :- To Remove Student ID")
    print("Enter 5 :- To See All Records")
    e = int(input("Please Select An Option :- "))
    if(e == 1):
        RegisterCourse()
    elif (e==2):
        EditRecord()
    elif (e==3):
        Search()
    elif (e==4):
        Remove()
    elif (e==5):
        seeall()
    else:        
        if(platform.system() == "Windows"):
            print(os.system('cls'))
        else:
            print(os.system('clear'))
        print("Invalid choice....Enter correct choice!!! ")
        OptionMenu()
#------------------------------------------------------------------------  
def EditRecord():
    q=input("Enrollment ID of Student whose detail you want to Update/Edit")
    print("Enter 1 :- To Update/Correct Name of Student")
    print("Enter 2 :- To Update/Edit Address")
    print("Enter 3 :- To Update/Edit Phone Number")  
    print("Enter 4 :- To Update/Edit Age")
    print("Enter 5 :- To Update/Edit Language Selected")
    print("Enter 6 :- To Update/Edit Fee Status")
    y = int(input("Please Select An Option :- "))    
    
    if y==1:
        a=input("Enter Updated/Corrected Name")
        sql="UPDATE STUDENT SET SNAME='"+a+ "'WHERE ID='" +q+ "'"
        cursor.execute(sql)
        con.commit()
        print("Name of Student has been updated successfully")
    elif y==2:
        a=input("Enter New Address")
        sql="UPDATE STUDENT SET SADDRESS='"+a+ "'WHERE ID='" +q+ "'"
        cursor.execute(sql)
        con.commit()
        print("Address has been updated successfully")
    elif y==3:
        a=input("Enter New Phone Number")
        sql="UPDATE STUDENT SET SPHONE='"+a+ "'WHERE ID='" +q+ "'"
        cursor.execute(sql)
        con.commit()
        print("Phone number has been updated successfully")
    elif y==4:
        a=input("Enter Updated Age")
        sql="UPDATE STUDENT SET SAGE='"+a+ "'WHERE ID='" +q+ "'"
        cursor.execute(sql)
        con.commit()
        print("Age of student id",q,"has been updated successfully")
    elif y==5:
        a=input("Enter Programming Language Selected By Student")
        sql="UPDATE STUDENT SET PLANG='"+a+ "'WHERE ID='" +q+ "'"
        cursor.execute(sql)
        con.commit()
        print("Programming Language of student id",q,"has been updated successfully")
    elif y==6:
        a=input("Enter Updated Fee Status")
        sql="UPDATE STUDENT SET FEE_STATUS='"+a+ "'WHERE ID='" +q+ "'"
        cursor.execute(sql)
        con.commit()
        print("Fee Status of student id",q,"has been updated successfully")
    else:
        print("Invalid choice....Enter correct choice!!! ") 
        EditRecord()      
#------------------------------------------------------------------------        
def Search():
    print("Select the search criteria:- ")
    print("1. Enrollment Id")
    print("2. Name")
    print("3. Address")
    print("4. Phone No.")
    print("5. Age")
    print("6. Programming Language")
    print("7. Fee Status")
    h=int(input("Enter your choice:- "))
    if h==1:
        m=input("Enter Enrollment Id:- ")
        l=(m,)
        sql="SELECT * FROM STUDENT WHERE ID=%s"
        cursor.execute(sql,l)
    elif h==2:
        m=input("Enter Student Name:- ")
        l=(m,)
        sql="SELECT * FROM STUDENT WHERE SNAME=%s"
        cursor.execute(sql,l)
    elif h==3:
        m=input("Enter Address:- ")
        l=(m,)
        sql="SELECT * FROM STUDENT WHERE SADDRESS=%s"
        cursor.execute(sql,l)
    elif h==4:
        m=input("Enter phone:- ")
        l=(m,)
        sql="SELECT * FROM STUDENT WHERE SPHONE=%s"
        cursor.execute(sql,l)
    elif h==5:
        m=input("Enter Age:- ")
        l=(m,)
        sql="SELECT * FROM STUDENT WHERE SAGE=%s"
        cursor.execute(sql,l)
    elif h==6:
        m=input("Enter Programming Language:- ")
        l=(m,)
        sql="SELECT * FROM STUDENT WHERE PLANG=%s"
        cursor.execute(sql,l)
    elif h==7:
        m=input("Enter Fee Status:- ")
        l=(m,)
        sql="SELECT * FROM STUDENT WHERE FEE_STATUS=%s"
        cursor.execute(sql,l)
    else:
        print("Invalid choice....Enter correct choice!!! ")
        Search()
    result= cursor.fetchall()   
    display(result)    
#--------------------------------------------------------------------------
def Remove():
    r=input("Enter Enrollment Id of the Student to be deleted:- ")
    l=(r,)
    sql="DELETE FROM STUDENT WHERE ID=%s"
    cursor.execute(sql,l)
    con.commit()
    print("Record of Id=",r,"has been deleted successfully")
#--------------------------------------------------------------------------
def display(result):
    x = PrettyTable()
    x.field_names = ["Enrollment ID", "Name", "Address", "Phone No.","Age","Programming Language","Fee Status"]
    for i in result:
        x.add_row(i)
    print(x)
#-------------------------------------------------------------------------    
def Start():
    restart = input("Want to Start Program: Yes(Y) or No(N):- ")
    while(restart.lower() == 'y'):
        OptionMenu()        
        print("Enter 'C' to Continue") 
        print("Enter 'E' to Exit")  
        j=input("Your Choice:-")  
        if j.lower()=='e':
            break   
        elif j.lower()=='c':
            if(platform.system() == "Windows"):
                print(os.system('cls'))
            else:
                print(os.system('clear'))
#-------------------------------------------------------------------------                 
def seeall():
    sql="SELECT * FROM STUDENT "
    cursor.execute(sql)
    r = cursor.fetchall()
    display(r)    
    
Start()

---

Instructions

---

1.Step to configure and run the project:

--------------------------------------

i-Open VS Code and install the following modules (type commands in terminal of VS code)

          pip install mysql-connector

          pip install prettytable

--------------------------------------         

ii- Start WAMPSERVER

iii- Start HeidiSQL and run the following sql commands one by one

create programming_course;
USE programming_course;
CREATE TABLE student(
ID VARCHAR(5),
SNAME VARCHAR(20),
SADDRESS VARCHAR(20),
SPHONE VARCHAR(10),
SAGE VARCHAR(3),
PLANG VARCHAR(15),
FEE_STATUS VARCHAR(10)
)

NOTE: Make sure that Python 3.x and MySQL is installed. 

---

So, this is the complete project. If you like the content, share it to your friends. 

python mysql connectivity projects for class 12,computer science project for class 12 python pdf, python project for class 12 with source code, python sql connectivity project class 12, computer project for class 12 cbse using python pdf, ip project for class 12 python 2020-21, python investigatory project class 12, ip project for class 12 python using csv file, python mysql project class 12,python mysql project,python and mysql projects for class 12,python mysql,class 12 python project with mysql,python mysql connectivity project for class 12,python mysql connector,python project using mysql,project in python class xii,class 12 python project,python class 12 project,class 12 python,python mysql tutorial,project development in python,python project with mysql connectivity,project development in python using mysql, ip project for class 12 python and mysql pdf, computer science project for class 12 python pdf, class 12 python project with file handling, ip project for class 12 python 2020-21