Today, we will develop a Contact Book project in Python. A contact book is software that helps anyone to efficiently manage and track contacts. It can be used by individuals to manage and store contact details on their PC.
Project overview: Contact Book project in Python
| Project Name: | Contact Book project in Python |
| Abstract: | This is a simple app that can be used to handle contacts related to addresses or phones. |
| Language/Technologies Used: | Python, Tkinter, Sqlite3 |
| IDE | VSCode(Recommended) |
| Database | SQLite3 |
| Python version (Recommended): | 3.x |
| Type/Category: | All Python learners |
Features
- Adding contacts
- Updating contacts
- Persisting the contacts with the sqllite3 database
- Delete a contact
Complete code for Contact Book project in Python
We will just need a single main.py file and the code for the same is written down here, the code is well commented so as to assist you with better learning. The default username and password are “root” and “root”, you can always change that later in the code.
import sqlite3
from tkinter import *
from tkinter import ttk, messagebox
class ContactManager:
def __init__(self, root):
# Initialize the class with the root window passed as an argument
self.root = root
# Set the title and size of the root window
self.root.title("ContactBook Management")
self.root.attributes('-fullscreen', True)
# Create a label with the title text and style it
title = Label(self.root, text="ContactBook Management", font=(
"Comic Sans MS", 20, ), bd=8, bg='black', fg='white')
title.pack(side=TOP, fill=X)
# Create StringVar variables to store the contact details
self.firstname = StringVar()
self.lastname = StringVar()
self.mobile = StringVar()
self.addr = StringVar()
self.pin = StringVar()
# Create a frame to hold the Contact details
Detail_F = Frame(self.root, bd=4, relief=RIDGE, bg='white')
Detail_F.place(x=10, y=120, width=350, height=260)
# Create a label and entry field for the firstname
lbl_name = Label(Detail_F, text="First Name",
font=("Comic Sans MS", 12, ))
lbl_name.grid(row=1, column=0, pady=10, padx=20, sticky="w")
txt_name = Entry(Detail_F, font=("Comic Sans MS", 10, ),
bd=3, textvariable=self.firstname)
txt_name.grid(row=1, column=1, pady=10, sticky="w")
# Create a label and entry field for the lastname
lbl_mob = Label(Detail_F, text="Last Name",
font=("Comic Sans MS", 12, ))
lbl_mob.grid(row=2, column=0, pady=10, padx=20, sticky="w")
txt_mob = Entry(Detail_F, font=("Comic Sans MS", 10, ),
bd=3, textvariable=self.lastname)
txt_mob.grid(row=2, column=1, pady=10, sticky="w")
# Create a label and entry field for the Mobile number
lbl_aa = Label(Detail_F, text="Mobile No.",
font=("Comic Sans MS", 12, ))
lbl_aa.grid(row=3, column=0, pady=10, padx=20, sticky="w")
txt_aa = Entry(Detail_F, font=("Comic Sans MS", 10, ),
bd=3, textvariable=self.mobile)
txt_aa.grid(row=3, column=1, pady=10, sticky="w")
# Create a label and entry field for the address
lbl_add = Label(Detail_F, text="Address", font=("Comic Sans MS", 12, ))
lbl_add.grid(row=4, column=0, pady=10, padx=20, sticky="w")
txt_add = Entry(Detail_F, font=("Comic Sans MS", 10, ),
bd=3, textvariable=self.addr)
txt_add.grid(row=4, column=1, pady=10, sticky="w")
# Create a label and entry field for the pincode
lbl_pin = Label(Detail_F, text="PinCode", font=("Comic Sans MS", 12, ))
lbl_pin.grid(row=5, column=0, pady=10, padx=20, sticky="w")
txt_pin = Entry(Detail_F, font=("Comic Sans MS", 10, ),
bd=3, textvariable=self.pin)
txt_pin.grid(row=5, column=1, pady=10, sticky="w")
recordFrame = Frame(self.root, bd=5, relief=RIDGE)
recordFrame.place(x=400, y=120, width=550, height=260)
yscroll = Scrollbar(recordFrame, orient=VERTICAL)
# Create a treeview to display the records
self.contact_table = ttk.Treeview(recordFrame, columns=(
"firstname", "lastname", "mobile", "address", "pin"), yscrollcommand=yscroll.set)
yscroll.pack(side=RIGHT, fill=Y)
yscroll.config(command=self.contact_table.yview)
self.contact_table.heading("firstname", text="First Name")
self.contact_table.heading("lastname", text="Last Name")
self.contact_table.heading("mobile", text="Mobile No.")
self.contact_table.heading("address", text="Address")
self.contact_table.heading("pin", text="PinCode")
self.contact_table['show'] = 'headings'
self.contact_table.column("firstname", width=100)
self.contact_table.column("lastname", width=100)
self.contact_table.column("mobile", width=100)
self.contact_table.column("address", width=100)
self.contact_table.column("pin", width=110)
self.contact_table.pack(fill=BOTH, expand=1)
self.fetch_data()
self.contact_table.bind("<ButtonRelease-1>", self.get_cursor)
btnFrame = Frame(self.root, bd=5, relief=RIDGE)
btnFrame.place(x=250, y=400, width=480, height=60)
# Create a button to calculate the Details
btn1 = Button(btnFrame, text='Add record', font='arial 12 bold',
bg='black', fg='white', width=9, command=self.addrecord)
btn1.grid(row=0, column=0, padx=10, pady=10)
# Create a button to update the Details
btn2 = Button(btnFrame, text='Update', font='arial 12 bold',
bg='black', fg='white', width=9, command=self.update)
btn2.grid(row=0, column=1, padx=8, pady=10)
# Create a button to delete the entry
btn3 = Button(btnFrame, text='Delete', font='arial 12 bold',
bg='black', fg='white', width=9, command=self.delete)
btn3.grid(row=0, column=2, padx=8, pady=10)
# Create a button to reset the fields
btn4 = Button(btnFrame, text='Reset', font='arial 12 bold',
bg='black', fg='white', width=9, command=self.reset)
btn4.grid(row=0, column=3, padx=8, pady=10)
def addrecord(self):
if self.firstname.get() == '' or self.lastname.get() == '' or self.mobile.get() == '' or self.addr.get() == '' or self.pin.get() == '':
messagebox.showerror('Error', 'Please enter details ?')
else:
con = sqlite3.connect('contactbook.db')
cur = con.cursor()
cur.execute("Select * from contact")
rows = cur.fetchall()
for row in rows:
if row[0] == self.mobile.get():
messagebox.showerror(
'Error', 'Duplicates not allowed')
return
cur.execute("insert into contact values(?,?,?,?,?)", (
self.firstname.get(),
self.lastname.get(),
self.mobile.get(),
self.addr.get(),
self.pin.get(),
))
con.commit()
self.fetch_data()
con.close()
def fetch_data(self):
con = sqlite3.connect('contactbook.db')
cur = con.cursor()
cur.execute(
"select firstname , lastname , mobile , addr , pin from contact")
rows = cur.fetchall()
if len(rows) != 0:
self.contact_table.delete(*self.contact_table.get_children())
for row in rows:
self.contact_table.insert('', END, values=row)
con.commit()
con.close()
def update(self):
# Check if a record has been selected to update
if self.mobile.get() == '':
messagebox.showerror('Error', 'Select a record to update !')
else:
# Connect to the database
con = sqlite3.connect('contactbook.db')
cur = con.cursor()
# Update the contact in the database using the current values of the input fields
cur.execute("update contact set firstname = ?, lastname = ?, mobile = ?, addr = ?, pin = ? where mobile = ?", (
self.firstname.get(),
self.lastname.get(),
self.mobile.get(),
self.addr.get(),
self.pin.get(),
self.mobile.get()
))
# Show a success message and close the database connection
messagebox.showinfo(
'Info', f'Record {self.mobile.get()} Updated Successfully')
con.commit()
con.close()
# Refresh the data in the table and reset the input fields
self.fetch_data()
self.reset()
def delete(self):
# Check if the contact ID has been entered
if self.mobile.get() == '':
messagebox.showerror(
'Error', 'Enter contact ID to delete the records')
else:
# Connect to the database
con = sqlite3.connect('contactbook.db')
cur = con.cursor()
# Delete the contact from the database using the current contact ID
cur.execute("delete from contact where mobile = ?",
(self.mobile.get(),))
# Close the database connection
con.commit()
con.close()
# Refresh the data in the table and reset the input fields
self.fetch_data()
self.reset()
def reset(self):
# Reset the values of the input fields
self.firstname.set('')
self.lastname.set('')
self.mobile.set('')
self.addr.set('')
self.pin.set('')
def get_cursor(self, ev):
# Get the row that the cursor is currently on in the table
cursor_row = self.contact_table.focus()
# Get the content of that row
content = self.contact_table.item(cursor_row)
# Get the values of that row
row = content['values']
# Set the input fields to the values of the selected row
self.firstname.set(row[0])
self.lastname.set(row[1])
self.mobile.set(row[2])
self.addr.set(row[3])
self.pin.set(row[4])
class Login():
def __init__(self, root):
# Initialize the class with the root window passed as an argument
self.root = root
# Set the title of the root window
self.root.title("Contact Book Management System")
self.root.geometry("300x150")
# Create StringVar variables to store the username and password
self.username = StringVar()
self.password = StringVar()
# Create a label and entry field for the username
Label(self.root, text="Username:").grid(
row=0, column=0, padx=10, pady=10)
Entry(self.root, textvariable=self.username).grid(
row=0, column=1, padx=10, pady=10)
# Create a label and entry field for the password
Label(self.root, text="Password:").grid(
row=1, column=0, padx=10, pady=10)
Entry(self.root, textvariable=self.password,
show="*").grid(row=1, column=1, padx=10, pady=10)
# Create a login button that calls the login method when clicked
Button(self.root, text="Login", command=self.login).grid(
row=2, column=1, padx=10, pady=10)
def login(self):
# Check if the entered username and password are correct
# You can change the default username and passowrd here !
if self.username.get() == "root" and self.password.get() == "root":
# If the login is successful, destroy the current window and open a new window
root.destroy()
nroot = Tk()
ContactManager(nroot)
else:
# If the login is unsuccessful, show an error message
messagebox.showerror("Error", "Invalid username or password")
# Connect to the 'contactbook.db' database
con = sqlite3.connect('contactbook.db')
# Create a cursor to perform operations on the database
cur = con.cursor()
# Execute a SQL query to create a table named 'contact' if it doesn't already exist
# The mobile column is set as the primary key
cur.execute('create table if not exists contact (firstname varchar(20),lastname varchar(20),mobile varchar(20) primary key , addr varchar(20) , pin varchar(20))')
# Create a Tkinter root window
root = Tk()
# Create a Login object and pass the root window as an argument
obj = Login(root)
# if u want to skip the login proess then uncomment the below line and comment the above line
# obj = ContactManager(root)
# Start the main loop of the Tkinter program
root.mainloop()Note: A DB file will create in the directory where you run this app, the DB files store all the records for the entries, don’t delete it if not intended to delete the records.
Output for Contact Book project in Python:
Image output:
Login Screen:
Main Screen:
Video output:
Conclusion
In this article, we have create a simple Contact Book project in Python, you can alternatively call it as phone book or address book because it saves mobile numbers and addresses too. You can customize this address book by adding more entries to this form like contact book, like adding city, state, date of birth, salary, number of family members, etc. Hope this article helped you.
Thank you for visiting our website.
Also Read:
- Create your own ChatGPT with Python
- SQLite | CRUD Operations in Python
- Event Management System Project in Python
- Ticket Booking and Management in Python
- Hostel Management System Project in Python
- Sales Management System Project in Python
- Bank Management System Project in C++
- Python Download File from URL | 4 Methods
- Python Programming Examples | Fundamental Programs in Python
- Spell Checker in Python
- Portfolio Management System in Python
- Stickman Game in Python
- Contact Book project in Python
- Loan Management System Project in Python
- Cab Booking System in Python
- Brick Breaker Game in Python
- Tank game in Python
- GUI Piano in Python
- Ludo Game in Python
- Rock Paper Scissors Game in Python
- Snake and Ladder Game in Python
- Puzzle Game in Python
- Medical Store Management System Project in Python
- Creating Dino Game in Python
- Tic Tac Toe Game in Python
- Test Typing Speed using Python App
- Scientific Calculator in Python
- GUI To-Do List App in Python Tkinter
- Scientific Calculator in Python using Tkinter
- GUI Chat Application in Python Tkinter
