Online Library Management System using Python Django and MySQL

Library management system is a project which aims in developing a computerized system to maintain all the daily work of library .This project has many features which are generally not available in normal library management systems like facility of user login and a facility of admin login .It also has a facility of admin login through which the admin can monitor the whole system. It has also a facility where student after logging in their accounts can see list of books issued and its issue date and return date.

Project Requirements

Project Name
Online Library Management System Project in Python Django

Language Used
Python

Framework Used
Django

Database
MySQL

User Interface Design
HTML, AJAX,JQUERY,JAVASCRIPT

Web Browser
Mozilla, Google Chrome, IE8, OPERA

IDE
PyCharm

Project Modules

In this project we use Python, Django Framework and MySQL database and it has two modules i.e.

Admin and User

Admin

Admin Dashboard

Admin can add/update/ delete category

Admin can add/update/ delete author

Admin can add/update/ delete books

Admin can issue a new book to student and also update the details when student return book

Admin can search student by using their student ID

Admin can also view student details

Admin can change own password

Students-

Student can register yourself and after registration they will get studentid

After login student can view own dashboard.

Student can update own profile.

Student can view issued book and book return date-time.

Student can also view the available books in the library.

Student can also change own password.

Student can also recover own password.

Some of the Project Screens

Home Page

User Signup

Listed Books

Admin Dashboard

Add Book

How to run the Online Library management System Django Python

1. Download the zip file

2. Extract the file, copy library folder, and paste it on the desktop

3. Open MySQL Create a database olmspythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:UsersANUJOneDriveDesktoplibrary

6. Now Navigate to the olms folder

cd olms

7. Run the Project using the following command

python manage.py runserver

Now click the URL http://127.0.0.1:8000 and the Project will Run

Login Details

*************admin************

Username:  admin

Password: Test@123

*************User/Student**************

Username:  john12345

Password: Test@123 or Register a new Student

Project Demo

Project Report

The post Online Library Management System using Python Django and MySQL appeared first on PHPGurukul.

Source: Read More