Digital Auction : An Online Auction

System
By
Submitted Saeed Ahmad
17-Arid-6046
Umer Draz Khan
17-Arid-6052
Mohammad Numan
17-Arid-6036

Supervised By

Mr.IMRAN SHEHZAD
Senior Lecturer

Department OF COMPUTER SCIENCE PIR MEHR ALI SHAH

ARIDAGRICULTURE UNIVERISTY OF RAWALPINDI

The Project has been submitted in Partial Fulfillment of the Requirements for the Degree
of Bachelor of Science in Computer Science
 Abstract
This project, An Online Auction System has two parts- customer interface and admin interface.
Customer Panel permits a customer to upload a product for sale and bid on a particular product to
buy. This system presents an online display of category wised products they want to sell or bid.
There is an admin panel by which an admin can control the whole bidding system. Admin can
approve products by the categories and also can control the registered customers. There is fixed
delivery policy. After finishing the bidding process there is a notify system to notify the sellers and
bidders. This is a fully dynamic system which can be easily operated by the users.

i
 Declaration
We hereby, declare that all the work presented in this project is the outcome of the investigation
and research performed by us under the supervision of Mr.Imran Shehzad, Senior Lecturer,
Department of Computer Science ,Barani Institute of Sciences of Sahiwal Joint Venture (JV). This
is also needed to certify that the project work is under the course ‘CSE-497’. We also declare that
neither it nor part of it has been submitted for the requirement of any degree or diploma or for any
other purposes except for publications.

Signature of Candidates

Saeed Ahmad

Umer Draz Khan

Mohammad Numan

ii
 Letter of Acceptance
The project entitled Digital Auction System’ is submitted by Saeed Ahmad
ID.17-Arid-6046.Umer Draz Khan 17-Arid-6052.Mohammad Numan 17-Arid-6036. Dept. of
Computer Science and Engineering.Arid Agriculture Sahiwal Campus.

Approval of Chairperson Approval of Supervisor

Acknowledgement
It has been great pleasure for us to develop a Web Application for Digital Auction System.
We have gathered sufficient knowledge and experience during this project.

Most importantly we would like to thank our honorable teacher and supervisor, Senior Lecturer.
Imran Shehzad, Dept. of Computer Sciences at Barani Institute Sahiwal who guided us to proper
analysis of the system and helped to develop an elegant and efficient system. It was a great pleasure
to study and work with many gifted people who influenced us in many ways. First of all, we would
like to thank our project supervisor Mr.Imran Shehzad. He encouraged us to seek out the clearest

iii
and deepest description of theoretical ideas as well as experimental findings. We are very grateful
to him for his continuous support, advice and guidance.

Finally we would like to convey our special thanks to our parents and friends whom have always
given us tremendous Support. Without their love and encouragement we would not had achieve
this far.

TABLE OF CONETNTS
Title Page No

1.1 Declaration i
1.2 Abstract ii
1.3 Letter of acceptance iii
1.4 Acknowledgement iv
1.5 Table of Contents v

Chapter 1 1-3
Introduction

1.1 Introduction 1
1.2 Motivation 1
1.3 Objective 2
1.4 Goals of the project 2
1.5 Project scope 2
1.6 Technology stack 3

iv
1.7 Limitation 3

Chapter 2 4-11
Analysis and Design
4
2.1 Requirement analysis 5
2.2 Use case Diagram for users 6 2.3 Use case Diagram for admin 7 2.4
Activity Diagram for users 8
2.4 Activity Diagram for users 9
2.4 Software Requirements 10
2.5 Software Platform 11

Chapter 3 12-15
Database Implementation and interface

3.1 Database Design 12

3.1 Database Interface 13-15

Chapter 4 16-30
Design Interface

Chapter 5 31-33
Conclusion and Future Work

Appendix 34-69

v
 Chapter 1
Introduction

1.1 Introduction
The Digital auction system is a web application where all products are displayed in different
categories and a customer can bid to the selected category wised product without facing any
problem. The Digital auction system deals between sellers and bidders. It provides the users for
sign up to this application and search for products, manages their accounts. Each customer will
have their own account showing their username they have logged in. On the other hand users can
also see all product pages without having an access with their account. Signed up users will have
to log in first then they can upload products on the site from their account and also can bid for
other products which are not owned by them. Users can edit their profile and see their uploaded
products and bided products. Administration panel can approve products, update products, delete
products, delete user, update and delete all ongoing bids and can also see all the products,
categories, users and bids. All particular bids have limited time to finish. After finishing the bids
admin can notify the sellers and also the bidders. This is a well secured system and can be easily
operated. This is fully dynamic. There is nothing static here. The main aim of this web application
is to make a good online system that provides a great alternative of bidding policy for general
people that saves both time and money.

.2 Motivation
For our project we consider the Digital auction system as our target. In our country there is not
any auction site. So this is an innovative and new idea for Pakistan. This web based application
helps users to choose their desire products and upload products on the site. Users can also easily
bid on particular products. This provides a great alternative of auction system for general people.

1.3 Objectives

General efficiency :

6
  To increase efficiency and services to the customers through better application of
technology in daily operation.
 For increasing the efficiency of the system we used object oriented programming
method.
 To be able to stand out from competitors in the ecommerce sites.

Specific objectives :
 To enable customers to see all the products without any authentication.
 To enable the customers to have a visual confirmation that the bid was placed correctly.
 To enable the customers to know product details before bid.
 To ensure correct bid placement through visual interface.

. 14 Goals of the Project

The main goals of this system are to sell and bid different types of products to the customers
living anywhere around Pakistan. The website will show all products in categorized manner.
Customers can browse any product and their details and can bid on the products. User has to get
the order through the delivery policy. Admin can keep track of bids through admin panel.

1.5 Project Scope

Digital online Auction System- Bid On will be a web based application which main language of
programming will be PHP. Its main aim is to simplify and improve the efficiency of the bidding
process for users, minimize data entry and ensure data accuracy and security bid placement
process. Users will also be able to view all product menus in categorized way with their full
details. Users will also be able to have a visual confirmation that the order was place correctly.

1.5 Technology Stack

To build up this website I have used the main language of programming PHP. For database
system, I have used MYSQL. For designing the view in both front-end and back-end, I have
used HTML, CSS.
Programming languages: PHP

7
Database system: MYSQL
Markup languages: HTML, CSS

1.6 Limitations

 Requires internet connection and the person must be computer literate.

 It may not show the complete details of user after getting an item.
Sometimes the system falls.

Chapter 2
Analysis and Design
Development of web based systems requires analysis of the process to be digitized in order to
enable a correct system, a system that functions as required and to assist the potential users of the
system understand the general functionality of the system. The analysis specifies the system's
objectives and constraints to which designers have to comply. The purpose of doing analysis is
to transform the system’s major inputs into structured specification. This has mainly two
requirement section- Admin section and User section.

8
Requirement analysis

 Each user type admin or user needs to register him or her as a user or an admin for
accessing the user’s necessary information. They also have email, username and
password. They can login into the system from the web using their email and password.

 Admin needs to login to the system to operate the system. Admin has an individual or
unique login email, password and a user level. Through this email and password admin
can login into the system.

 Admin can update all product pages. An admin can insert a new product with details and
can update the product information through edit option.

 Admin can delete user from user panel. It can have the full access of user’s bid list.

 Admin can have access in the bid page.

 Users can look for a product from a selected category.

 User can add a product to the site with full details of that product.

 They can see their products and bided list through their account page.

 Users can edit their profiles.

2.1

2.2 Use case Diagram

Use Case Diagram for User panel

Use case diagram for user panel is given in the following figure 2.2

9
 Fig 2.1: Use case diagram for User Panel

Functionalities provided:

 Register: user need to sign up first to add or bid a product into the site
 All product: user can see all products pages
 Product details: user can see the products details
 All category: user can see all the categorized products
 Total items: user can see their total uploaded and bided items on the page  Edit
Profile: User Can Edit their profiles

2.3 Use case Diagram

Use Case Diagram for Administrative panel

Use case diagram for administration panel is given in the following figure 2.1

10
 Fig 2.2: Use case diagram for Admin Panel

Functionalities provided:

 Check Product: Admin can check products

 Approve Product: Admin can approve products
 Update product: Admin can update products
 Update Bid: Admin can update bid status
 Notify: Admin can notify bidders and sellers  Delete user: Admin can delete users

11
2.4 Activity Diagram

Activity Diagram for User panel

Activity diagram for user panel is given in the following figure 2.3

Sign In

S ign Up

Activity

Sign >--- "' -- ---.f----> I s, nP ,ocloct

Edit Profile )-- --.1

Sign Out

Fig 2.3: Activity diagram for User Panel

12
2.4 Activity Diagram

Activity Diagram for Admin panel

Activity diagram for admin panel is given in the following figure 2.4

Sign In

"

Check. Product

'0
Approve
Prodtx:l

Update Product

Update Bid

Sign Out '0 Sign Out

Notify Bidder

Notify Seller

Delete User

• Fig 2.4: Activity diagram for User Panel

13
2.4 Software Requirements

For installing the system, we mainly required the following software, installed on the hosting
system.

2.4.1 Web Server

 Apache (Xampp control server v 3.21)

2.4.2 Database Language:

 MySQL

2.4.3 Server Side Language

 PHP

2.4.4 Design

 HTML, CSS

14
2.5 Software Platform

In this platform the tools are used fully open sources. For designing this project HTML, CSS are
used. Apache web server is used as web server. PHP is used for database connecting codes.
MySQL is used as database server.

2.5.1 HTML

HTML (Hypertext Markup Language) is the set of markup symbols or codes inserted in a file
intended for display on a World Wide Web browser page. The markup tells the Web browser how
to display a Web page's words and images for the user. Each individual markup code is referred
to as an element (but many people also refer to it as a tag).Some elements come in pairs that
indicate when some display effect is to begin and when it is to end.

2.5.2 CSS

A cascading style sheet (CSS) is a Web page derived from multiple sources with a defined order
of precedence where the definitions of any style element conflict. The Cascading Style Sheet,
level 1 recommendation from the World Wide Web Consortium, which is implemented in the
latest versions of the Netscape and Microsoft Web browsers, specifies the possible style sheets or
statements that may determine how a given element is presented in a Web page. CSS gives more
control over the appearance of a Web page to the page creator than to the browser designer or the
viewer. With CSS, the sources of style definition for a given document element are in this order
of precedence.

15
2.5.3 Apache Web Server (XAMPP)

Apache is a freely available Web server that is distributed under an open source license. Version
2.0 runs on most UNIX-based operating systems (such as LINUX, Digital UNIX, and AIX), on
other UNIX/POSIX-derived systems (such as Rhapsody, BeOS, and BS2000/OSD), on amigos
and on Windows 2000. According to a Net craft Web server survey 60% of all Web sites on the
Internet are using Apache (62% including Apache derivatives), making Apache more widely used
than all other Web servers combined. Apache is open-source software. The name Apache was
chosen from respect for the Native American Indian tribe of Apache, well-known for their
superior skills in warfare strategy and their inexhaustible endurance. It also makes a cute pun on
a patchy web server a server made from a series of patches but this was not its origin. The group
of developers who released this new software soon started to call themselves the Apache Group.

2.5.4 PHP

PHP is an alternative to Microsoft's Active Server Page (ASP) technology. As with ASP, the PHP
script is embedded within a Web page along with its HTML. Before the page is sent to a user that
has requested it, the Web server calls PHP to interpret and perform the operations called for in
the PHP script. An HTML page that includes a PHP script is typically given a file name suffix of
php .php3," or ".phtml". Like ASP, PHP can be thought of as dynamic HTML pages, since content
will vary based on the results of interpreting the script.

Chapter 3
Database Implementation and Interface

16
 3.1 Database Design

Database design is the process of producing a detailed data model of a database.

This logical data model contains all the needed logical and physical design choices
and physical storage parameters needed to generate a design in a Data Definition
Language, which can then be used to create a database. A fully attributed data model
contains detailed attributes for each entity.

The term database design can be used to describe many different parts of the design
of an overall database system. Principally, and most correctly, it can be thought of
as the logical design of the base data structures used to store the data. In the
relational model these are the tables and views. In an object database the entities
and relationships map directly to object classes and named relationships. However,
the term database design could also be used to apply to the overall process of
designing, not just the base data structures, but also the forms and queries used as
part of the overall database application within the database management system.
The process of doing database design generally consists of a number of steps which
will be carried out by the database designer. Usually, the designer must:

 Determine the relationships between the different data elements.  Superimpose

a logical structure upon the data on the basis of these relationships.

In the following section a detailed database structure of the ‘Online Auction System’ is
elaborated with all the details.

3.2 Database Interface

17
Table Number 1: users

Purpose: Users Information

Description: This table will contain the user information. Users are who is using this system.
This table will be using for authentication of users.

Figure 3.1: Users Information Table

Table Number 2: product

Purpose: Products Information.

18