SchoolLibraryManagementSystem

KO | EN

gitlite — search

#javascript #hacktoberfest #go #android #machine-learning #rust #deep-learning #linux #docker #macos #windows #awesome #cli #vue

SchoolLibraryManagementSystem

(★ 13)

No description available.

SchoolLibraryManagementSystem Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# SLMS — Simple Library Management System (Laravel)

A Laravel (MVC) application implementing the SLMS scenario:

- Entities: **Book**, **Borrower**, **BorrowedBook**, **ReturnedBook**
- Session-based login (username + strong encrypted password)
- Insert on all 4 forms; full CRUD only on **ReturnedBook**
- Report: all borrowed & returned books per borrower

---

## Database design (keys & relationships)

| Table | Primary Key | Foreign Keys |
|---|---|---|
| `books` | `book_code` | — |
| `borrowers` | `borrower_id` | — |
| `borrowed_books` | `borrow_id` (auto) | `book_code` → books, `borrower_id` → borrowers |
| `returned_books` | `return_id` (auto) | `borrow_id` → borrowed_books (ensures the book was previously borrowed AND links to the same borrower) |
| `users` | `id` | — (login) |

Rules enforced:
1. Only a registered borrower (FK `borrower_id`) can borrow.
2. A book can be returned only if a matching `borrowed_books` row exists (FK `borrow_id`).
3. Returning uses the same `borrow_id`, guaranteeing same borrower + same book.

---

## Step-by-step setup

### 1. Install prerequisites
- PHP 8.2+
- Composer
- MySQL (or MariaDB)
- Node is **not** required (views are Blade only)

### 2. Create a fresh Laravel project
```bash
composer create-project laravel/laravel:^11.0 SLMS
cd SLMS
```

### 3. Copy the source files
Unzip this archive and **copy/replace** the following folders/files into the new Laravel project root:
- `app/`
- `database/`
- `resources/views/`
- `routes/`
- `.env.example`

(Keep the rest of the fresh Laravel install as-is — that gives you `vendor/`, `artisan`, `bootstrap/app.php`, etc.)

### 4. Configure environment
```bash
cp .env.example .env
php artisan key:generate
```
Edit `.env` and set:
```
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=SLMS
DB_USERNAME=root
DB_PASSWORD=yourpassword
```

### 5. Create the database
In MySQL:
```sql
CREATE DATABASE SLMS;
```

### 6. Run migrations + seed default user
```bash
php artisan migrate --seed
```
This creates all tables and a default login:
- **Username:** `admin`
- **Password:** `Admin@12345`  (strong, bcrypt-encrypted)

### 7. Run the app
```bash
php artisan serve
```
Open http://127.0.0.1:8000 — you'll be redirected to login.

---

## Application links (after login)
- `/books` — insert a book
- `/borrowers` — insert a borrower
- `/borrowed` — record a borrowing
- `/returned` — full CRUD (insert / list / edit / delete) on returns
- `/report` — borrowed & returned books per borrower

---

## Password policy
Registration/seeded passwords must satisfy:
- min 8 chars
- at least 1 uppercase, 1 lowercase, 1 digit, 1 symbol
- stored with bcrypt (Laravel's `Hash::make`)

Enforced via `Password::min(8)->mixedCase()->numbers()->symbols()` in `AuthController`.

SchoolLibraryManagementSystem

SchoolLibraryManagementSystem Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

SchoolLibraryManagementSystem

SchoolLibraryManagementSystem Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README