the quiz game using
python and mysql
Register No. :
Under the guidance of
Mrs.LAVANYA G MICHAEL
M.Sc, M.Phil, B.Ed
A Project work submitted to
CENTRAL BOARD OF SECONDARY EDUCATION
INDIA
In partial fulfilment of the requirement for
Class–XII 2024-25
1
VELAMMALVIDYALAYA
PARUTHIPATTU
ACADEMIC YEAR 2024-25
PROJECT REPORT ON
The quiz game using
pyhon and MySql
Register no :
Name : anandha kaarthick s
Class : XII B
SUBJECT : COMPUTER SCIENCE
SUB CODE : 083
PROJECT GUIDE : MRS LAYANYA G MICHAEL
M.Sc, M.Phil, B.Ed
VELAMMAL VIDYALAYA
PARUTHIPATTU, AVADI
2
VELAMMAL VIDYALAYA
PARUTHIPATTU
CLASS–XII PROJECT
Register No.:
CERTIFICATE
This is to certify that Anandha kaarthick S of class XII-B,
Register no: has successfully completed the project
work entitled The quiz game using python and MySql in the subject
Computer science (083) and submitted it to Central Board of
Secondary Education.
During the academic year: 2024-25
INTERNAL EXAMINER EXTERNAL EXAMINER
3
INDEX
S.NO. DESCRIPTION PAGE NO.
01 ACKNOWLEDGEMENT 05
02 INTRODUCTION 06
03 OBJECTIVES OF THE PROJECT 06
04 OVERVIEW 07
05 THE MAIN PROGRAM 09
06 THE QUERY FOR SQL DATABASE 14
07 THE MENU’S GIVEN BY THE PROGRAM 14
08 OUTPUT OF THE FOLLOWING PROGRAM 15
09 MYSQL DATABASE TABLES 17S
ACKNOWLEDGEMENT
First and foremost my grateful thanks to the almighty for his divine
4
blessing and grace in making this project successful and I thank my parents
for giving me all this life and opportunity. I acknowledge my sincere thanks
to The Chairman and The Correspondent of Velammal Educational Trust for
providing me with this opportunity and the necessary facilities for
completing this study.
My profound gratitude and heartfelt thanks to Mr.Prithviraj, Senior principal
VelammalVidyalaya, Paruthipattu. Sir, thank you for your expertise,
enthusiasm, and especially for your precious time and for the kind help
in all situations throughout the academic year.
It is a proud privilege to express my sincere gratitude to my guide
Mrs.LAVANYA G MICHAEL, Faculty of Computer Science for constant
guidance for the entire study duration. Always looking ahead with new
ideas, guiding with patience and support in all situations.
I gladly extend my sincere thanks to my class in-charge and all Faculty
members for their support. Last but not least, I would like to show my
humble gratitude to my family members and all my friends who were the
back bone for me to complete this study successfully.
THE QUIZ GAME USING PYTHON AND MYSQL
INTRODUCTION
5
This is the interactive game which a user can play in the way of quiz
with many options in it
OBJECTIVES OF THE PROJECT
The objective of this project is to let the students apply the
programming knowledge into a real- world situation/problem and exposed
the students how programming skills helps in developing a good software.
1. Write programs utilizing modern software tools.
2. Apply object oriented programming principles effectively when
developing small to medium sized projects.
3. Write effective procedural code to solve small to medium sized
problems. 4. Students will demonstrate a breadth of knowledge in
computer science, as exemplified in the areas of systems, theory and
software development. 5. Students will demonstrate ability to conduct a
research or applied Computer Science project, requiring writing and
presentation skills which exemplify scholarly style in computer science.
DOCUMENTATION FOR QUIZ GAME
OVERVIEW:
6
This is a game which gives the user to play, create user, login, add
question and view the scoreboard. This game is built using python run
the game and Mysql to store the game data like user information,
scoreboard and quiz questions
FEATURES:
1. User Management:
1. User can create the user account.
2. User can login to a existing account .
2. Quiz gameplay:
1. This game is based on a multiple choice question .
2. The score can be tracked on basis of the correct answers
3.Questions:
1. Question are managed in mysql database.
4. Scoreboard:
1. The scoreboard can be seen by the user
TECHNOLOGIES:
Programming language: python
Database : MySql
Libraries used:
1. ‘mysql.connector’:
It is used for connecting and interating with python and MySql
database.
2. ‘getpass’:
It is used for securely handling password input from the user
3. ‘msvcrt’:
For handling keyboard input in a windows environment
INSTALLATION:
1. Ensure that you have installed mysql and python.
2. Ensure you have installed the above libraries
USAGE:
Menu options:
Create a new user: Allows new users to register.
7
Login: Existing users can log in with their credentials.
Play game: Start playing the quiz game.
Add question: Admin users can add new questions to the quiz.
Display scoreboard: View the leaderboard with scores.
Quit: Exit the application.
Gameplay:
Users will be presented with multiple-choice questions.
Input the number corresponding to the chosen answer.
After each question, users can decide to continue or end the game.
CODE EXPLANATION:
Main Functions
get_password(prompt): A custom function to securely input passwords
without displaying them on the screen.
create_user(): Handles user registration by inserting new user data into
the database.
login_user(): Authenticates users by checking the provided credentials
against the database.
play_game(user_id): Facilitates the quiz gameplay, tracks scores, and
checks answers against correct options.
add_question(): Allows the addition of new questions to the database.
display_scoreboard(): Fetches and displays the current scores of all
users.
ERROR HANDLING:
The application includes error handling for database operations to ensure
that users receive feedback in case of issues such as invalid input or
connection errors.
CONCLUSION:
The Quiz Game project is a simple yet engaging application that
combines user interaction, database management, and game logic. It
serves as a practical example of how to build a console application with
user authentication and dynamic content management using Python and
MySQL.
THE MAIN PROGRAM
8
import mysql.connector
import getpass
Nimport random
import msvcrt
try:
cnx = mysql.connector.connect(
user='root',
password='123456',
host='localhost',
database='quizgame'
)
except mysql.connector.Error as err:
print("Something went wrong: {}".format(err))
exit()
cursor = cnx.cursor()
def get_password(prompt):
password = ""
while True:
char = msvcrt.getch()
if char == b'\r': # Enter key
break
elif char == b'\b': # Backspace key
if password:
password = password[:-1]
print('\b \b', end='', flush=True) # Backspace and space to
erase the character
else:
password += char.decode()
print('*', end='', flush=True) # Print an asterisk to represent the
character
print() # Newline after the password
return password
def create_user():
try:
9
global id
id = input("enter your user id: ")
username = input("Enter your username: ")
password = getpass.getpass("Enter your password: ")
query = "INSERT INTO users (id,username, password) VALUES
(%s, %s, %s)"
cursor.execute(query, (id, username, password))
cnx.commit()
print("User created successfully!")
except mysql.connector.Error as err:
print("Error creating user: {}".format(err))
def login_user():
try:
username = input("Enter your username: ")
password = getpass.getpass("Enter your password: ")
query = "SELECT * FROM users WHERE username = %s AND
password = %s"
cursor.execute(query, (username, password))
user = cursor.fetchone()
if user:
return user[0]
else:
print("Invalid username or password!")
return None
except mysql.connector.Error as err:
print("Error logging in user: {}".format(err))
def play_game(user_id):
try:
score = 0
query = "SELECT * FROM question"
cursor.execute(query)
questions = cursor.fetchall()
if not questions:
print("No questions available.")
return
for question in questions:
10
if len(question) < 2:
print("Invalid question format.")
continue
print(question[1])
for i, option in enumerate(question[2].split(',')):
print(f"{i+1}. {option}")
while True:
try:
answer = int(input("Enter the number of your answer: "))
if answer < 1 or answer > len(question[2].split(',')):
print("Invalid answer! Please try again.")
else:
break
except ValueError:
print("Invalid input! Please enter a number.")
if question[2].split(',')[answer-1] == question[3]:
score += 1
print("Correct!")
else:
print("Incorrect!")
while True:
choice = input("Do you want to continue? (yes/no): ")
if choice.lower() == "yes":
break
elif choice.lower() == "no":
print(f"Your final score is {score}!")
return
else:
print("Invalid input! Please enter yes or no.")
query = "INSERT INTO scores (user_id, score) VALUES (%s, %s)"
cursor.execute(query, (user_id, score))
cnx.commit()
print(f"Your final score is {score}!")
except mysql.connector.Error as err:
print("Error playing game: {}".format(err))
def add_question():
try:
question = input("Enter the question: ")
options = input("Enter the options (comma separated): ")
11
answer = input("Enter the correct answer: ")
query = "INSERT INTO question (question, options, answer) VALUES
(%s, %s, %s)"
cursor.execute(query, (question, options, answer))
cnx.commit()
print("Question added successfully!")
except mysql.connector.Error as err:
print("Error adding question: {}".format(err))
def display_scoreboard():
try:
query = "SELECT u.username, s.score FROM users u JOIN scores s
ON u.id = s.user_id ORDER BY s.score DESC"
cursor.execute(query)
scores = cursor.fetchall()
print("Scoreboard:")
for i, score in enumerate(scores):
print(f"{i+1}. {score[0]} - {score[1]}")
except mysql.connector.Error as err:
print("Error displaying scoreboard: {}".format(err))
def main():
while True:
print("1. Create a new user")
print("2. Login")
print("3. Play game")
print("4. Add question")
print("5. Display scoreboard")
print("6. Quit")
while True:
try:
choice = int(input("Enter your choice: "))
if choice < 1 or choice > 6:
print("Invalid choice! Please try again.")
else:
break
except ValueError:
print("Invalid input! Please enter a number.")
if choice == 1:
12
create_user()
if choice == 2:
login_user()
elif choice == 3:
play_game(id)
elif choice == 4:
add_question()
elif choice == 5:
display_scoreboard()
elif choice == 6:
print("Goodbye!")
break
if id:
while True:
print("1. Play game")
print("2. Add question")
print("3. Display scoreboard")
print("4. logout")
while True:
try:
choice = int(input("Enter your choice: "))
if choice < 1 or choice > 4:
print("Invalid choice! Please try again.")
else:
break
except ValueError:
print("here is your option")
if __name__ == "__main__":
main()
THE QUERY FOR SQL DATABASES
13
FOR USERS TABLE:
CREATE TABLE
users (
id
VARCHAR(255)
PRIMARY KEY,
username FOR QUESTIONS TABLE:
VARCHAR(255)
NOT NULL,
CREATE TABLE
question
password (
VARCHAR(255)
id INT
NOT NULL);
AUTO_INCREMENT
PRIMARY KEY,
question TEXT
NOT NULL,
options TEXT FOR SCORES TABLE:
NOT NULL,
CREATE
answer TABLE
VARCHAR(255)
scores (
NOT
id NULL);
INT
AUTO_INCREMENT
PRIMARY KEY,
user_id
VARCHAR(255)
NOT NULL,
score INT NOT
NULL,
FOREIGN KEY The menu’s given by the program
(user_id) 1. Create a new user
REFERENCES 2. Login
users(id)); 3. Play game
4. Add question
5. Display scoreboard
6. Quit
OUTPUT FOR THE FOLLOWING PROGRAM:
14
1. Create a new user
2. Login
3. Play game
4. Add question
5. Display scoreboard
6. Quit
Enter your choice: 1
enter your user id: 456
Enter your username: anandha;
Enter your password:
User created successfully!
1. Create a new user
2. Login
3. Play game
4. Add question
5. Display scoreboard
6. Quit
Enter your choice: 2
Enter your username: anandha;
Enter your password:
1. Create a new user
2. Login
3. Play game
4. Add question
5. Display scoreboard
6. Quit
Enter your choice: 3
What is the largest planet in our solar system?
1. Earth
2. Saturn
3. Jupiter
4. Uranus
Enter the number of your answer: 3
Correct!
Do you want to continue? (yes/no): yes
Which musician is known as the "King of Rock and Roll"?
1. Elvis Presley
2. Chuck Berry
3. Little Richard
15
4. Bo Diddley
Enter the number of your answer: 3
Incorrect!
Do you want to continue? (yes/no): no
Your final score is 3!
1. Create a new user
2. Login
3. Play game
4. Add question
5. Display scoreboard
6. Quit
Enter your choice: 4
Enter the question: what is 1+1
Enter the options (comma separated): 1 , 2 , 3 , 4
Enter the correct answer: 2
Question added successfully!
1. Create a new user
2. Login
3. Play game
4. Add question
5. Display scoreboard
6. Quit
Enter your choice: 5
Scoreboard:
1. anandha - 3
1. Create a new user
2. Login
3. Play game
4. Add question
5. Display scoreboard
6. Quit
Enter your choice: 6
Goodbye!
the MySql database tables
Questions tables:
16
User tables
Scoreboard table
17
