VISVESVARAYA TECHNOLOGICAL UNIVERSITY

BELAGAVI - 590018.

A MINI - PROJECT REPORT ON

“ADS CLASSIFIED”
submitted in partial fulfillment of requirements for the fifth semester
DATABASE MANAGEMENT SYSTEM LABORATORY
for the course of
BACHELOR OF ENGINEERING
in
COMPUTER SCIENCE

submitted by

MANISH KUMAR KISLAY KUMAR

(1ST19CS066) (1ST19CS058)

under the guidance of

Mrs. Shamala M G
Asst.Prof., Dept. of CSE
&
Mr. Hanumantha Rao K R
Asst.Prof., Dept. of CSE

Department of Computer Science & Engineering

SAMBHRAM INSTITUTE OF TECHNOLOGY
BENGALURU 560097.
SAMBHRAM INSTITUTE OF TECHNOLOGY
M.S. PALYA, JALAHALLI EAST, BENGALURU - 560097.
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

CERTIFICATE

This is to certify that the mini-project entitled “ADS CLASSIFIED” has been
carried out by MANISH KUMAR (1ST19CS066), KISLAY KUMAR(1ST19CS058)
bonafide students of Sambhram Institute of Technology in partial fulfillment of
requirements for the fifth semester DATABASE Management System Laboratory,
prescribed by the Visvesvaraya Technological University (VTU), Belagavi during the
academic year 2021-2022. It is also hereby, ensured that all corrections/suggestions
indicated for internal assessment have been incorporated while submitting this report.
This report has been approved as it satisfies the academic requirements with respect to
the project work prescribed for the said course.

Mrs. Shamla M G Dr. T John Peter

Asst.Professor, Dept. Of CSE Head, Dept. of CSE, SaIT

External Viva

Names of the examiners Signatures with date

1.

2.
 ACKNOWLEDGEMENT
While presenting this mini-project entitled “ADS CLASSIFIED ” entrusted to us,
we feel that it is our duty to acknowledge the guidance and help provided for its
success. We take this occasion to thank God, almighty for blessing us with his grace
and taking our endeavour to a successful culmination.

We are grateful to our institution, Sambhram Institute of Technology for

providing us, a congenial atmosphere to carry out this project with all possible amount
of ease.

We thank Dr. H.G Chandrakanth, Principal, Sambhram Institue of Technology,

and Dr. T John Peter, HOD, Department of Computer Science & Engineering, for
their constant support.

We extend our thanks to our esteemed guides, Mrs. Shamala M G and

Mr. Hanumantha Rao K R Assistant Professors, Department of Computer Science
& Engineering for providing us with the right guidance and advice at the crucial
junctures and for showing us the right way.

We are also indebted to our parents and friends for their continued moral and
material support throughout the course of this project and helping us in showcasing
the project’s presentation.

Our thanks to all teaching, non-teaching staffs and others who have
contributed bits, bytes and words to accomplish this project.

MANISH KUMAR 1ST19CS066

KISLAY KUMAR 1ST19CS058

i
 ABSTRACT

ADS CLASSIFIED is a management system whose purpose is to assist any

business with ease of access information about their products and to restock products
when required without going through the hassle of manual restocking. It provides an
environment where they can easily check and update the latest information about the
products. They can manage and add items, manage and add suppliers, update the
system with respect to customer. It is also aimed to provide a convenient platform for
both the customer and the seller. It minimizes the dependency on the third party for
buying or selling the products.

ii
 TABLE OF CONTENTS
CHAPTER DESCRIPTION PAGE NO.
ACKNOWLEDGEMENT i
ABSTRACT ii

1 INTRODUCTION TO DBMS 1

1.1 Database system environment

1.2 Design and Modeling

1.3 Objective

1.4 Problem Statement

1.5 Scope of the report

2 SYSTEM AND SOFTWARE SPECIFICATIONS

2.1 Functional Requirements
2.2 Non-Functional Requirements

2.3 Software Requirements

2.4 Hardware Requirements

3 SYSTEM DESIGN
3.1 ER Diagram with relationships and cardinality ratio
3.2. Schema Diagram
3.3 Codes for fronted

3.4 Database code snippet

4 IMPLEMENTATION
4.1 Libraries and frameworks
4.2 Functional Modules

5 MODULES OF ADS CLASSIFIED

6 RESULT AND ANALYSIS

6.1 Home page of the project

6.2 Sign Up

6.3 Dashboard after login with post

6.4 Category page

6.5 Product page

6.6 Login page

6.7 Post an Ad

6.8 Feedback Dashboard

CONCLUSION

BIBLIOGRAPHY
CHAPTER 1
INTRODUCTION
Database is a collection of data and Management System is a set of programs to store and
retrieve those data. Based on this one can define DBMS as a collection of inter-related data and
set of programs to store & access those data in an easy and effective manner.

1.1 What is the need of DBMS?

Database systems are basically developed for large amount of data. When dealing with
huge amount of data, there are two things that require optimization: Storage of data and retrieval
of data.

Storage: According to the principles of database systems, the data is stored in such a way that it
acquires lot less space as the redundant data (duplicate data) has been removed before storage.
Let’s take a layman example to understand this. In a banking system, suppose a customer is having
two accounts, one is saving account and another is salary account. Let’s say bank stores saving
account data at one place (these places are called tables we will learn them later) and salary account
data at another place, in that case if the customer information such as customer name, address etc.
are stored at both places then this is just a wastage of storage (redundancy/ duplication of data), to
organize the data in a better way the information should be stored at one place and both the
accounts should be linked to that information somehow. The same thing we achieve in DBMS.

Fast Retrieval of data: Along with storing the data in an optimized and systematic manner, it is
also important that we retrieve the data quickly when needed. Database systems ensure that the
data is retrieved as quickly as possible.

The choice of a database product is often influenced by factors such as:

 the computing platform (i.e., hardware, operating system)

 the volume of data to be managed

 the number of transactions required per second

 existing applications or interfaces that an organization may have

Dept. of CSE, SAIT 2021-22 1

ADS Classified

 support for heterogeneous and/or distributed computing

 cost

 vendor support

1.2 Design and Modeling:

The first task of a database designer is to produce a conceptual datamodel that reflects the
structure of the information to be held in the database. A common approach to this is to develop
an entity-relationship model, often with the aid of drawing tools. Another popular approach is
the Unified Modeling Language. A successful data model will accurately reflect the possible state
of the external world being modeled: for example, if people can have more than one phone number,
it will allow this information to be captured.

Figure 1.1: Simplified database system environment

Dept. of CSE, SAIT 2021-22 2

ADS Classified

1.3 Objective
The main objective of this project is to determine how an interactive ads classified system
helps in the smooth functioning of shopping compared to traditional shopping system, by
digitizing all the records and transacting everything on a computer rather than on paper. This
project is a two-tier architecture application.

1.4 Problem Statement

Existing systems for trading are very inefficient and mostly involve a lot of manual work
to be done. With this project, we want to automate as many tasks as possible using the available
technology and the internet.

1.5 Scope of the report

The essential framework of this report would be to elaborate the design of E.R-diagram,
Schema Diagram and to display how the modules of the program work in order to achieve the
automation.

Dept. of CSE, SAIT 2021-22 3

CHAPTER 2
SYSTEM AND SOFTWARE REQUIREMENTS AND
SPECIFICATIONS

The program works on Desktop PC and is executed using PHP which interacts with a MySql
database running on localhost.

2.1 FUNCTIONAL REQUIREMENTS

A description of the facility or feature required. Functional requirements deal with
what the system should do or provide for users. They include description of the required
functions, outlines of associated reports or online queries, and details of data to be held in the
system.

2.1.1 Interface Requirements:

 The system shall provide an option to add/delete items.
 The system should give option for login.
 The system shall provide option to give their valuable feedback.

2.2 NON-FUNCTIONAL REQUIREMENTS:

Non-functional requirements define the overall qualities or attributes of the resulting system.
2.2.1 Usability
Usability is the ease with which a user can learn to operate the ads classified and get results.
2.2.2 Security
Security requirements are included in a system to ensure:
 All products and supplier information are well secured
 SQL injection is prevented

Dept. of CSE,SAIT 2021-22 4

ADS Classified System Specification

2.2.3 Reliability
Reliability is the ability of a system to perform its required functions under stated conditions
for a specific period of time. Constraints on the run-time behavior of the system can be
considered under two separate headings:
 Availability: is the system available for service when requested by end-users.
 Failure rate: how often does the system fail to deliver the service as expected by end-
users.
2.2.4. Efficiency
The comparison of what is actually produced or performed with what can be achieved with
the same consumption of Clouds (money, time, etc.). It is an important Factor in
Determination of Productivity.

2.3 SOFTWARE REQUIREMENTS

Programming language : PHP, MYSQL
Operating system : ANY OS (Recommended: Windows8,
Windows Vista, Windows XP)
Application required : Standalone desktop application & Xampp
Coding language : PHP

2.4 HARDWARE REQUIREMENTS

CPU : Pentium IV 2.4 GHz or above
Memory (Primary) : 512 MB, 1 GB or above
Hard Disk : 40 GB, 80GB, 160GB or above
Monitor : 15 VGA color

Dept. of CSE,SAIT 2021-22 5

CHAPTER: 3

ER DIAGRAM, SCHEMA DIAGRAM

This chapter of the report describes the structure of the project, followed by Entity
Relationship Diagram, Schema Diagram and the table structures.

3.1 ER Diagram with relationships and cardinality ratio

An entity relationship model, also called an entity-relationship (ER) diagram, is a

graphical representation of entities and their relationships to each other, typically used in
computing in regard to the organization of data within databases or information systems.
An entity is a piece of data-an object or concept about which data is stored.

The cardinality or fundamental principle of one data aspect with respect to another is a
critical feature. The relationship of one to the other must be precise and exact between
each other in order to explain how each aspect links together. In simple words Cardinality
is a way to define the relationship between two entities.

The following are the notations of the ER diagram:

Fig 3.1: Notations for ER Diagrams

Dept. of CSE,SAIT 2021-22 6

ADS Classified Design

The ER diagram below shows the relationship between the many tables that exist in the
database for the functioning of Warehouse Inventory Management System.

Fig 3.2: ER Diagram ADS Classified

3.2 Schema Diagram

In any data model it is important to distinguish between the description of the

database and the database itself. The description of a database is called the database
schema, which is specified during database design and is not expected to change
frequently.

Dept. of CSE,SAIT 2021-22 7

ADS Classified Design

A displayed schema is called a schema diagram. A schema diagram displays only

some aspects of a schema, such as the names of record types and data items, and some
types of constraints.

Fig 3.3: Schema Diagram

Dept. of CSE,SAIT 2021-22 8

 ADS Classified Design

3.3 CODES FOR FRONTEND

<?php include_layout_template('admin_header.php', ["pageName" => "All

Products"]); ?>
<li class="active"><a href="<?php echo HOME; ?>all-products">All
Products</a></li>
<li><a href="<?php echo HOME; ?>dashboard">Dashboard</a></li>
<li><a href="<?php echo HOME; ?>new-product">Post An Ad</a></li>
<li><a href="<?php echo HOME; ?>">View Categories</a></li>
</ul>
</div>
</nav>
</div><!-- End Navigation Pane -->

<div class="row">
<div class="col-lg-12 col-sm-12">
<?php echo output_message($message); ?>
<h3>Find a product:</h3>
<form id="search-form" action="<?php echo HOME; ?>search" method="post">
<input id="search-box" autofocus class="form-control" type="text"
name="keyword" placeholder="Name of the product" > <br />
</form>

<div id="display">
<?php foreach($products as $product){ ?>
<?php $cat_name = category_details($product->category_id, NULL); ?>
<div class="col-lg-4 col-md-4 col-sm-6 col-xs-5">
<div>
<p>
<span class="visible-lg visible-md visible-sm"><b>Category:</b> <?php echo
$cat_name; ?><br/></span>
<span class="visible-lg visible-md visible-sm visible-xs"><b>Product:</b>
<?php echo $product->name; ?><br /></span>
</p>

<a class="thumbnail" href="<?php echo ASSETS.$product->image_path(); ?>"

title="<?php echo $cat_name.': '.$product->name; ?>" data-gallery>
<img src="<?php echo ASSETS.$product->image_path(); ?>" width="210"
alt="<?php echo $product->name; ?>" />
</a>
</div>
</div>
<?php } ?>
<div id="pagination" style="clear: both;">

Dept. of CSE, SAIT 2021-22 9

 ADS Classified Design

<?php echo pagination_links($pagination, "all-products", $page); ?>

</div>
</div>
</div>
<!-- Showing search results -->
<div id="search-results">
</div>
<?php include($dir_public.'lightbox.php'); ?>
</div><!-- End Content Row -->
<?php include_layout_template('admin_footer.php'); ?>

<style>
#myform{
display:none;
top:120px;
left:30%;
width:450px;
padding: 8px 30px;
position:absolute;
border: 1px solid black;
outline-style: solid;
outline-color: #47535E;
outline-width: 4px;
background-color: #758AA2;
z-index: 10;
box-shadow: 0 0 0 9999px rgba(0,0,0,0.5);

}
.btn{
font-size: 15px;
padding: 8px 18px;
cursor: pointer;
text-align: center;
color: white;
background-color: #7535E4;
border-radius: 15px;
}
</style>

<?php include_layout_template('admin_header.php', ["pageName" => "Dashboard"]); ?>

<li><a href="<?php echo HOME; ?>all-products">All Products</a></li>
<li class="active"><a href="<?php echo HOME; ?>dashboard">Dashboard</a></li>
<li><a href="<?php echo HOME; ?>new-product">Post An Ad</a></li>
<li><a onclick="document.getElementById('myform').style.display='block'">
Feedback</a> </li>
Dept. of CSE, SAIT 2021-22 10
 ADS Classified Design

<li><a href="<?php echo HOME; ?>">View Categories</a></li>

</ul>

</nav>
</div>
<div id = "myform">
<form action="feedback_control.php" method="post" name="feedback">
<label>How do you rate your overall experience?</label>
<p>
<label class="radio-inline">
<input type="radio" name="experience" id="radio_experience"
value="bad" >
Bad
</label>
<label class="radio-inline">
<input type="radio" name="experience" id="radio_experience"
value="average" >
Average
</label>
<label class="radio-inline">
<input type="radio" name="experience" id="radio_experience"
value="good" >
Good
</label>
</p>
<label for="name">
Your Name:</label>
<input type="text" name="name" required>
<label>
Your Email:</label>
<input type="text" name="email" required>

<label>
Write Your Comment:</label>
<input type="text" name="comment" required>

<div>
Submit: <input type="submit" value="Submit">
</div>
</form>

</div>
<div class="row">
<div class="col-lg-12 col-sm-12">
<h2>My AD's</h2>
Dept. of CSE, SAIT 2021-22 11
 ADS Classified Design

<?php echo output_message($message); ?>

<div class="table-responsive">
<table class="table table-hover">
<tr>
<th>Product</th>
<th>Category</th>
<th>Name of Product</th>
<th>Price (Rs.)</th>
<th>Description</th>
<th>&nbsp;</th>
</tr>
<?php foreach($products as $product) { ?>
<?php $cat_name = category_details($product->category_id, NULL); ?>
<tr>
<td><img src="<?php echo ASSETS.$product->image_path(); ?>" width="120"
/></td>
<td><?php echo $cat_name; ?></td>
<td><?php echo $product->name; ?></td>
<td><?php echo $product->price; ?></td>
<td><?php echo $product->description; ?></td>
<td><a href="<?php echo HOME; ?>delete-product?id=<?php echo $product-
>id; ?>" onclick="return confirm('Are you sure?')">Remove</a>
</tr>
<?php } ?>
</table>
</div><!-- End div for Table -->
<!-- Display pagination links -->
<div id="pagination" style="clear: both;">
<?php echo pagination_links($pagination, "dashboard", $page); ?>
</div>

</div>
</div><!-- End content Row -->
<?php include_layout_template('admin_footer.php'); ?>

<?php include_layout_template('header.php', ["pageName" => "Login"]); ?>

<div class="loginmain">
<div class="loginsub1">
<div id="form">
<div style="font-family:Cambria, Cochin, Georgia, Times, 'Times New Roman',
serif ;font-size:xx-large;font-weight: 500; font-style: italic; ">
Login
</div>

Dept. of CSE, SAIT 2021-22 12

 ADS Classified Design

<?php echo output_message($message); ?>

<form action="<?php echo HOME; ?>login" method="post">

<br />
<p class="form-group">
<input autofocus class="form-control" type="text" name="username"
maxlength="30" placeholder="Username" value="<?php echo htmlentities($username); ?>"
/></p>
<p class="form-group">
<input class="form-control" type="password" name="password"
maxlength="30" placeholder="Password" value="" /></p><br />

<p><input class="btn btn-info" type="submit" name="submit" value="Login"

/></p>
</form><br />
<div style="font-family: Cambria, Cochin, Georgia, Times, 'Times New Roman',
serif;font-size: x-large;font-weight: 400; font-style: italic; ">

New User? <a href="<?php echo HOME; ?>register">Sign Up</a><br /><br />
<a href="<?php echo HOME; ?>">Home</a>
</div>
</div>
</div>
</div>
</div>
<?php include_layout_template('footer.php'); ?>

<?php include_layout_template('admin_header.php', ["pageName" => "Post An Ad"]); ?>

<li><a href="<?php echo HOME; ?>all-products">All Products</a></li>
<li><a href="<?php echo HOME; ?>dashboard">My Products</a></li>
<li class="active"><a href="<?php echo HOME; ?>new-product">Post An
Ad</a></li>
<li><a href="<?php echo HOME; ?>">View Categories</a></li>
</ul>
</div>
</nav>
</div>

<div class="row">
<div class="col-lg-12 col-sm-12">
<h2>Post An Ad</h2>
<div id="message">
<?php echo output_message($message); ?>
</div>
<div id = "form">
Dept. of CSE, SAIT 2021-22 13
 ADS Classified Design

<form id="newProductForm" action="<?php echo HOME; ?>new-product"

enctype="multipart/form-data" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="<?php echo
$max_file_size; ?>" />
<p>Category:<br />
<?php global $categories; ?>
<?php foreach($categories as $category) { ?>
<input type="radio" name="category_id" value="<?php echo
$category["id"]; ?>" /> <?php echo $category["value"]; ?><br />
<?php } ?>
</p>

<p>Name: <input id="productName" class="form-control" type="text"

required maxlength="50" name="name" value="<?php echo $name; ?>" />
<p>Price: <input id="productPrice" class="form-control" type="text"
required name="price" value="<?php echo $price; ?>" /> (In Rs.)</p>
<p>Purchase Year: <input id="purchaseYear" class="form-control"
type="text" name="pur_year" value="<?php echo $pur_year; ?>" /></p>
Description: <br />
<p><textarea id="productDescription" class="form-control" required
name="description" cols=150 rows=20><?php echo
$description; ?></textarea>
<p>Photo: <input type="file" name="file_upload" required /><br />
Max image size should be less than 5 MB.<br /></p>
<input class="btn btn-info" type="submit" name="submit"
value="Upload" />
</form>
<br />
<p><a href = "<?php echo HOME; ?>dashboard">Cancel</a><br /></p>
</div>
</div>
</div>
</div>
<?php include_layout_template('admin_footer.php'); ?>

3.4 Database Code Snippet

<?php require_once $libpath = substr(str_replace('\\', '/', __dir__), 0, -

17).'library/initialize.php'; ?>
<?php

class MySQLDatabase {

Dept. of CSE, SAIT 2021-22 14

ADS Classified Design

private $connection;
public $last_query;
private $magic_quotes_active;
private $real_escape_string_exists;
function __construct() {
$this->open_connection();
$this->magic_quotes_active = get_magic_quotes_gpc();
$this->real_escape_string_exists = function_exists("mysqli_real_escape_string");

}
public function open_connection() {
$this->connection = mysqli_connect(DB_SERVER, DB_USER, DB_PASS);
if (!$this->connection) {
die("Database connection failed: " . mysql_error());
} else {
$db_select = mysqli_select_db($this->connection, DB_NAME);
if (!$db_select) {
die("Database selection failed: " . mysql_error());
}
}
}

public function close_connection() {

if(isset($this->connection)) {
mysqli_close($this->connection);
unset($this->connection);
}
}
public function query($sql) {
$this->last_query = $sql;
$result = mysqli_query($this->connection, $sql);
$this->confirm_query($result);
return $result;
}

public function escape_value( $value ) {

if( $this->real_escape_string_exists ) { // PHP v4.3.0 or higher

// undo any magic quote effects so mysql_real_escape_string can do the work

if( $this->magic_quotes_active ) { $value = stripslashes( $value ); }

$value = mysqli_real_escape_string($this->connection, $value);

} else { // before PHP v4.3.0
// if magic quotes aren't already on then add slashes manually

if( !$this->magic_quotes_active ) { $value = addslashes( $value ); }

Dept. of CSE, SAIT 2021-22 15

 ADS Classified Design

// if magic quotes are active, then the slashes already exist

}
return $value;
}
// "database neutral" methods
public function fetch_array($result_set) {
return mysqli_fetch_assoc($result_set);
}
public function num_rows($result_set) {
return mysql_num_rows($result_set);
}
public function insert_id() {
// get the last id inserted over the current db connection
return mysqli_insert_id($this->connection);
}
private function confirm_query($result) {
if (!$result) {
$output = "Database query failed: ". mysql_error() .
"<br /><br />";
//$output .= "Last SQL query: ". $this->last_query;
die($output);
}
}
public function affected_rows() {
return mysqli_affected_rows($this->connection);
}

}
$database = new MySQLDatabase();
$db =& $database;
?>

Dept. of CSE, SAIT 2021-22 16

 ADS Classified Design

CHAPTER 4

IMPLEMENTATIONS
This chapter of the report describes the Functions, packages and modules used in the project:

4.1 Libraries and Frameworks

4.2 PHP

PHP is Hypertext Pre-processor is a general purpose programming language originally designed

for web development.

HTML

Hypertext Markup Language is the standard markup language for documents designed to be
displayed in a web browser. It can be assisted by technologies such as Cascading Style Sheets
and scripting languages such as JavaScript.

CSS
Cascading Style Sheets is a style sheet language used for describing the presentation of adocument
written in a markup language like HTML, CSS is a comer-stone technology of the World Wide
Web, alongside HTML and JavaScript.
JavaScript

JavaScript, often abbreviated as JS, is a high-level, interpreted scripting language that conforms
to the ECMAScript specification. JavaScript has curly-bracket syntax, dynamic typing, prototype-
based object-orientation, and first-class functions.

Bootstrap

Bootstrap is a free open source front end development framework for the creation of websites
and web apps. The Bootstrap framework is built on HTML,CSS, and JavaScript to facilitate the
development of responsive, mobile-first site and apps.

Dept. of CSE, SAIT 2021-22 17

ADS Classified Design

4.3 Functional Modules

The functional modules included in the project are listed below:

Insert Module:

This module provides the functionality of collecting the required data from the designed
interface and transmitting it to the appropriate table present in the database designed for this
project. If the provided data does not satisfy the given constraints, it must refrain from storing it
into the database.

Update Module:

This module again has the functionality of collecting the data from the designed interface,
but it updates the already existing tuple that matches the provided primary key of the tuple to be
updated, by replacing the existing attribute values with the newly collected data. Again, if the

newly provided data does not satisfy the given constraints, it must refrain from updating the
corresponding tuple.

Delete Module:

The delete counterpart is loaded with the ability to delete a single or multiple records
from the table. It searches for the tuple, in the query specified table, based on the provided value
for an attribute. Admin can delete in the interface, based on which delete module searches for the
record corresponding to that provided attribute value and deletes the record.

Retrieve Module:

The retrieve module has a basic functionality of accessing the entire specified table from
the database and displays it.

Trigger Module:

Trigger in database is set of statements that are executed after an event occurs on the
specified table. This is useful for logs wherein every change in database can be logged which
helps keep a track of all changes/transactions on the database.

Dept. of CSE, SAIT 2021-22 18

CHAPTER 5

MODULES IN ADS CLASSIFIED

ADS Classified is to provide a convenient platform for both he customer and the
seller. It minimizes the dependency on a third party for buying or selling the products.

 Users

 Purchase Product

 Add Product

 Feedback

 Review

User:
The users have to log in to the system and can then view all the items available on
The website .They ca also advertise their own product on the website which they want to
sell.

Purchase Product:
This section enables the user to choose the product they want to buy from the
items that are advertised. A user view the description about the products and find out
some information about the seller. After this, if the user is satisfied, he places the order
for purchasing that product.

Add Product:

This section of the application allows the users to add their products with clear
image and specific description. Product advertisement also needs information like name,
address, phone number, email address of the seller. So that the buyer can get enough
information about the product that can increase its possibility of getting sold.

Dept. of CSE,SAIT 2021-22 19

ADS Classified Modules

Feedback:

This section of the application let the user express his opinion about the website
and its functionalities. This feature ensures whether the website is user- friendly or not.

Review:

The review section of the program makes the website more credible by giving an
opportunity to user for sharing his experience on the website. It helps other existing and
potential buyers in to take the purchasing decisions.

Dept. of CSE,SAIT 2021-22 20

CHAPTER 6

RESULT & ANALYSIS

Fig 6.1: Start page of the project

Fig 6.2: Sign Up Page

Dept. of CSE, SAIT 2021-22 13

21
ADS Classified Result & Analysis

Fig 6.3:Login page

Fig 6.4: Dashboard after login with post

Dept. of CSE, SAIT 2021-22 22

2021-22
ADS Classified Result & Analysis

Fig 6.5: Category page

Fig 6.6: Product page

Dept. of CSE, SAIT 2021-22 23

2021-22
ADS Classified Result & Analysis

Fig 6.7: Post an Ad

Fig 6.8: Feedback Dashboard

Dept. of CSE, SAIT 2021-22 24

2021-22
 CONCLUSION
The ADS Classified system provides better functionality for trading to be more
efficient and reduce the common problem buyer and seller face in conventional market. With this
system, uses can easily choose the products they want to buy without any hassle. They can
decide on the basis of the image and specific descriptions while sitting at home.

The system comprises of following features:

 Management of products.
 Management of suppliers.
 Adding/deleting items or suppliers
 Feedback and review

SCOPE OF ENHANCEMENT

There are also few features which can be integrated with the system to make it more
flexible.

Below list shows the future points to be considered:

 Use hashing algorithms for storing passwords and avoid plaintext passwords.
 Implement the update feature with hardware integration in the warehouse.
 Port the program to other popular operating systems.

Dept. of CSE,SAIT 2021-22 17

25
 BIBLIOGRAPHY
BOOK REFERENCE

[1]Database System Models, Languages, Ramez Elmasri and Sham Kant B. Navathe, 7th

Edition,2017 Pearson.

[2]Fundamentals of Web Development, Randy Connolly and Ricardo Hoar ,First Impression ,

2016 Pearson.

WEBSITES

[1] www.stackoverflow.com

[2] www.youtube.com

[3] http://www.php.net/

[4] www.google.com

[5] http://www.w3schools.com/

Dept. of CSE,SAIT 2021-22 18

26