Skip to content

README.md

Latest commit

 

History

History
80 lines (63 loc) · 2.15 KB

README.md

File metadata and controls

80 lines (63 loc) · 2.15 KB

Library Management System (Flask, MySQL)

A web-based Library Management System developed using Python, the Flask microframework, MySQL for database management, and HTML/CSS for the frontend. Features include book management (add, delete, issue, return), search functionality, and distinct interfaces for administrators (full access) and regular users (search only).

Features

  • Admin User: Full access to add, delete, issue, return, and search books. Also can view users with overdue books.
  • Regular User: Ability to search for books.

Technologies Used

  • Python
  • Flask
  • MySQL
  • HTML
  • CSS

Setup Instructions

  1. Clone the repository:

    git clone https://github.com/AasthathecoderX/Library-Management-System
cd Library-Management-System

  2. Install dependencies:

    pip install flask
pip install mysql-connector-python

    (Make sure you have Python and pip installed on your system.)

  3. Database Setup:

    • Ensure you have MySQL installed and running.
    • Create a new database for the library management system (e.g., library).
    • Update the database connection details in your Flask application configuration file.

  4. Run the Flask application:

    python app.py

    (Replace app.py with the name of your main Flask application file if it's different.)

  5. Access the application: Open your web browser and navigate to http://127.0.0.1:5000/ (or the address your Flask application is running on).

Database Schema

-- Example SQL CREATE TABLE statements
CREATE TABLE book (
  `SL.NO` VARCHAR(1024),
  `A/c No` VARCHAR(1024),
  `Title` VARCHAR(1024),
  `Author` VARCHAR(1024),
  `Edition/Year` VARCHAR(1024),
  `Publication` VARCHAR(1024),
  `Issue_status` VARCHAR(50) DEFAULT 'Available',
 `return_date` DATE DEFAULT NULL;
);



CREATE TABLE issue(
Student_Name varchar(100),
Reg_no varchar(100),
AC_No varchar(100),
Title varchar(100),
Author varchar(100),
Issue_Date varchar(100)
);

CREATE TABLE returnb(
Student_Name varchar(100),
Reg_no varchar(100),
AC_No varchar(100),
Title varchar(100),
Author varchar(100),
Return_Date varchar(100)
);