Project Report: PG Life Website

Project Title:

PG Life Website

Abstract:

The PG Life Website (PGlife_website1) is a full-fledged web application developed to help students and working professionals locate and book PG accommodations in different cities. It is designed with the goal of creating a reliable and accessible platform for finding shared housing options tailored to gender preferences, budgets, and lifestyle needs. The platform provides detailed information on various PG accommodations and includes features such as advanced search, booking, admin control, and user feedback mechanisms.

Project Description:

The PG Life Website is a web-based platform developed to assist students in finding and booking comfortable and affordable PG (Paying Guest) accommodations near educational institutions. The website offers a user-friendly interface to search, filter, and view PG listings based on city, gender preference, amenities, and budget. It bridges the gap between students and PG owners by providing an all-in-one solution to browse, review, and reserve accommodation options.

Purpose:

To simplify the process of finding PG accommodations for students and working professionals by providing an online portal with reliable listings, reviews, and direct booking features. The platform aims to reduce the time, effort, and uncertainty involved in house-hunting while offering verified information and transparency.

1. Features Implemented

• User Authentication
  • Secure registration and login system for users
  • Role-based access control (students and admin)
• Search & Filter Options
  • Filter PGs by city, gender preference, budget, and amenities
  • Sort results by name, price, or ratings
• PG Listings
  • Detailed pages for each PG showing images, descriptions, room types, prices, and facilities
  • Status indication for availability
• Responsive Design
  • Mobile-first responsive interface for seamless use across devices
• Admin Panel
  • Admin interface to manage PG entries, user accounts, and bookings
  • Edit or remove outdated listings
• Other Functionalities
  • Rating and review system for users to leave feedback
  • Option to bookmark and save favorite PGs
  • Secure password encryption and data validation

2. Technologies Used

Component	Technology
Frontend	HTML, CSS, Bootstrap, JavaScript, API, React
Backend	Python, PHP, DBMS, MongoDB
Database	MySQL / SQLite
Version Control	GitHub
Hosting	Localhost / Web Server

3. System Architecture

• Client Side: Developed using HTML, CSS, JavaScript, and React, this layer interacts with users. It handles the user interface, rendering listings, filters, and booking forms dynamically.
• Server Side: The backend processes user requests, manages logic and routes, and communicates with the database. Built using Python or PHP, it handles authentication, form processing, data retrieval, and session management.
• Database: Centralized storage system using MySQL, SQLite, or MongoDB. It stores user credentials, PG listings, reviews, and booking records securely.

4. Database Design (ER Diagram Overview)

Users

• user_id (PK), name, email, password, gender, role

PG_Listings

• pg_id (PK), name, city, gender_allowed, price, description, image_urls

Bookings

• booking_id (PK), user_id (FK), pg_id (FK), booking_date

Reviews

• review_id (PK), user_id (FK), pg_id (FK), rating, comment

ER Diagram in Tabular Format

Entity: Users

Field Name	Data Type	Description
user_id (PK)	INT	Unique ID for each user
name	VARCHAR	Name of the user
email	VARCHAR	Email ID (unique)
password	VARCHAR	Hashed password
gender	VARCHAR	Gender of the user
role	VARCHAR	Role: 'student' or 'admin'

Entity: PG_Listings

Field Name	Data Type	Description
pg_id (PK)	INT	Unique ID for each PG
name	VARCHAR	Name of the PG
city	VARCHAR	City where the PG is located
gender_allowed	VARCHAR	Allowed gender: Male/Female/Both
price	DECIMAL	Monthly rent
description	TEXT	PG description
image_urls	TEXT	Paths or links to images

Entity: Bookings

Field Name	Data Type	Description
booking_id (PK)	INT	Unique ID for each booking
user_id (FK)	INT	References user_id from Users
pg_id (FK)	INT	References pg_id from PG_Listings
booking_date	DATE	Date of booking

Entity: Reviews

Field Name	Data Type	Description
review_id (PK)	INT	Unique ID for each review
user_id (FK)	INT	References user_id from Users
pg_id (FK)	INT	References pg_id from PG_Listings
rating	INT	Rating out of 5
comment	TEXT	Review comment

verfy:

click this--> https://github.com/Spixmacaw/-Web_development-PGlife_website1.git

where: This website referral url.

click this :http://debanjansarkar.epizy.com/PGLIFE/index.php

.Entire web-app is fully responsive and is operational from any device.

.skills users:- HTML, CSS, Bootstrap ,Javascript,AJAX, PHP, MySQL, react.

Installation:

To set up the PG-Life Web Application on your local system, follow these steps:

1.Clone the repository:

    git clone https://github.com/mohitrajput2002/PG-Life.git 

2.Database Connectivity:

Create a database with phpMyAdmin Tool using the same name as the provided SQL file name. Import the given SQL file into the created database.

3.Update database connectivity: 

In the file includes/database_connect.php, modify the following line:php

$conn = mysqli_connect("localhost", "username_of_phpmyadmin", "password_of_phpmyadmin", "Database_name(PGLife)");

Replace "username_of_phpmyadmin", "password_of_phpmyadmin", and "Database_name(PGLife)" with your phpMyAdmin credentials and the database name you created.

Technologies Used:

The following technologies:
    1.HTML
    2.CSS
    3.bootstrap
    4.JavaScript
    5.PHP
    6.MySQL-Database(phpMyAdmin_server)
Thank you!

---

/