Abstract

In today’s competitive Sri Lankan furniture supplies’ market, it is vital

for retailers to have a website where products can be sold online. For
this master’s project, an e-commerce website has been created called
Liyawel.com. The main requirement of this project is to create the
website in the least expensive yet in a professional way – thus, an open-
source solution known as OS Commerce is utilized to develop the e-
commerce system. The final version of the website has a front-end
site for public viewers and a back-end site for the store owner so that
owner could maintain the website.

In addition, this website is accompanied by documents which cover

topics such as intended website audience, design decision, competitive
analysis, website contents, website structure, database elements,
security aspects, payment methods, marketing approaches, website
maintenance guide, management and user requirements, costs and
benefits analysis, alternative development strategies, and project
schedule.
 Introduction

1.1 Overview of the organization

Furniture Showroom is the official web site that create a site platform
independent, and with some of the furniture centers, building mutual
assistance and cooperation relations, online sales. This furniture site
supplies facilities to buy online basic , durable home and office
furniture.
This website for is created to help increase its sales as well as to
acquire more customers in the furniture market. As well as;to
treat every supplier, employee, and customer with honesty, dignity
and respect,improve all aspects of service delivery to our customers,
our employees and our community and to provide a safe and
convenient environment to shop.

1.2 Business Process (Manual/ Partial Auto-

mated)

The customer can select any of it and enter the quantity of items he
wishes to buy and update their orders. And suppliers who manufacture
this furniture can view sales details of their products. In the payment
procedure the total amount of buying items is displayed and also
provides discount if any and finally the net amount is displayed. The
buyers can pay using online payment methods like paypal or
through their credit card. If credit card’s details are correct, then the
sales procedure is authorized. Finally they order furniture from a
distributor and the items are dispatched to the customer’s address to
where the goods have to be delivered. A bill will be sent to the
customer by the credit card company and vendors account will be
credited.
1.3 Definition of the Problem

The existing system is manual system. Needs to be converted into

automated system. As it has a risk of mismanagement of data, less
Security, no proper coordination between the Applications and Users,
fewer users - friendly, accuracy not guaranteed and not in reach of
distant users

1.4 Need Analysis

By creating the online furniture center we hope to deliver furniture

providing facilities for online shopping system to the customers by
ordering it from furniture distributors/suppliers. This system will
help to achieve maximum efficiency in shopping online and to reduce
the time taken to purchase items. But our main focus is youth. While
artist promote their popularity, we are able to achieve better economic
level by this system.

1.5 Aims and Objectives

Liyawel.com is to provide high quality service to all its customers with a

professional, kind, and supportive manner .This furniture center is
committed to being the best in all areas of its business. And its’
objectives are to:
• Treat every supplier, employee, and customer with honesty,
dignity and respect.
 • Impress our customers, current and prospective, to encourage
future business.
• Improve all aspects of service delivery to our customers, our
employees and our community.
• Provide a safe and convenient environment to shop.

1.6 Scope of the system

This site has great future scope. Online shopping system is developed
on and for the Windows and later versions environments and Linux
OS. This project also provides security with the use of Login-id and
Password, so that any unauthorized users can not use your account.
The only Authorized that will have proper access authority can access
the software.

LITERATURE REVIEW

EXISTING SYSTEM STUDY

The system study phase studies the problem, identifies

Alternate solutions evaluate those solutions and finally recommends the
best solution.

The system study gives the structure & function of the system.
The system Study can be performed only on an existing system.
 The system study gives an idea of then user
requirements. A detailed system study is an essential for developing an
efficient system. The techniques used are:

 Observation
 Interview
 Discussion

Observation:

Observation of the functioning of the existing system gives the Idea for
the design of the new system. This will figure of the pitfalls of the

Current system. It is helpful to understand and study the entire

current

system. By observation we can point out the changes needed to the

existing system. It also validates the data gathered by other means. It
also gives a better understanding of the work loads & pressures faced.

Interview:

The main objective of the interview is to gather

information and the Regarding the system from the concerned
authorities/employees .
System requirements & there by improving the existing system.
Interviewing the managerial staff & users can make a thorough
understanding of the system &this will be useful to improve the
efficiency of the existing system.

Discussion:

The main objective of the discussion is to transfer the ideas between the
department & the system developer. Through discussions, the problem faced by
the user during data entry, data retrieval can be understood.

System Analysis

2.1 SYSTEM FLOW DIAGRAM

 Data Flow Diagram

Database Design

The database design involves creation of tables. Tables are

represented in physical database as stored files. They have their

own independent existence. A table consists of rows and columns.

Each column corresponds to a piece of information called field. A

set of fields constitutes a record. The record contains all the

information, specific to a particular item.

TABLE NAME: REGISTER

PRIMARY KEY: user_id

TABLE NAME: Products

PRIMARY KEY: pid

TABLE NAME: Tblcart

PRIMARY KEY:CARTID
TABLE NAME: tblcartdetails
PRIMARY KEY:cartdetails

TABLE NAME: tblcategories

PRIMARY KEY: category_id

TABLE NAME: addressdetails

PRIMARY KEY:add_id

TABLE NAME: admin

Technology USED

FRONT END

Html

HTML stands for Hyper Text Markup Language, which is the most widely
used language on Web to develop web pages.

HTML was created by Berners-Lee in late 1991 but "HTML 2.0" was the first
standard HTML specification which was published in 1995. HTML
4.01 was a major version of HTML and it was published in late 1999. Though
HTML 4.01 version is widely used but currently we are having HTML-5
version which is an extension to HTML 4.01, and this version was published in
2012.

CSS

CSS is used to control the style of a web document in a simple and easy way.

CSS is the acronym for "Cascading Style Sheet". This tutorial covers both the
versions CSS1,CSS2 and CSS3, and gives a complete understanding of CSS,
starting from its basics to advanced concepts.
BACKEND
PHP

The PHP Hypertext Preprocessor (PHP) is a programming language that allows

web developers to create dynamic content that interacts with databases. PHP is
basically used for developing web based software applications. This tutorial
helps you to build your base with PHP.

My-SQL 5.0:-

MySQL officially, but also called "My Sequel" is (as of March 2014)
the world's second most widely used open-source relational database
management system (RDBMS). It is named after co-founder Michael
Widenius's daughter, My.The SQL phrase stands for Structured
Query Language.

The MySQL development project has made its source code available
under the terms of the GNU General Public License, as well as under a
variety of proprietary agreements. MySQL was owned and sponsored by
a single for- profit firm, the Swedish company MySQL AB, now owned
by Oracle Corporation.

MySQL is a popular choice of database for use in web applications, and

is a central component of the widely used LAMP open source web
application software stack. LAMP is an acronym for "Linux, Apache,
MySQL, Perl/PHP/Python." Free-software-open source projects that
require a full- featured database management system often use MySQL.

For proprietary use, several paid editions are available, and offer
additional functionality. Applications which use MySQL databases
include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, Drupal
and other
software. MySQL is also used in many high-profile, large-scale websites,
including Google, Facebook, Twitter, Flickr, and YouTube.

2.3 Business Systems Options for Software

• WINDOWS 7 OS/ WINDOWS XP /WINDOWS VISTA

• Glasssh server/Tomcat server

• My SQL workbench/ Phpmyadmin

• Netbeans

2.4 Business Systems Option for Hardware

• Intel Core 2 Duo 2 GHz processor

• 4 GB Ram

• 50 GB HDD Space

• Internet connection

2.5 Cost Benefit Analysis

if installed must still be a good investment for the SAN music studio
private limited company. In the economical feasibility, the development
cost of creating the system is evaluated against the ultimate benet
derived from the new systems. Financial benets must equal or exceed the
costs
 The system is economically feasible .Because it does not require any
addition hardware or software resources. Since the interface for this
system is developed using the existing resources and technologies
that are available , There is nominal expenditure and economical
feasibility for certain. -

2.6 Selected BSO(Business System Options) and

Justification for it

• Computer Hardware- A PC with a 2.4-gigahertz (GHz) processor or

faster, at least 1GB of memory, and a DirectX 9.0 compliant
Video (128 MB Memory) and a Multi Channel 5.1 Capable
Sound Card. For HD videos, the faster your computer the better.
And internet connection capable of 1.5+ mbps of sustained transfer
speeds

• Software requirements

– Adobe Flash Player

– WINDOWS OS

– SQL Server Enterprise Edition

– Xampp Server

– PHP myadmin
DESIGN & IMPLEMENTATION

INTRODUCTION

System study started off with initial analysis of the

existing system. The analysis was helpful in giving through
understanding of the present system. The analysis of the existing
system is also uncovered many flaws and elimination of flaws
formed the major objective of the proposed system.

A through knowledge the well details of the

production terminologies etc., were understood clearly before
system design was initiated. The study of existing system ended up
with verifying the stock quantity to be issued with the request the
database size was found to ever increasing & that the present set up
of following manual method would not service long. This leads to the
idea of introducing the DBMS in developing the software. this
idea was appreciated when the database need hierarchical security
& made going in for an DBMS inevitable due to various other
reasons.

OBJECTIVES

The major objective of the embroidery management is

increase the efficiency of the system & to reduce the system & to
reduce the

cost & time

➢ maintenance of stock details of design & cloth.

➢ easy access information.

➢ reducing the time involved in computer

queries. reducing the time involved in generation

reports

System Testing

5.1 Testing Methodology used

ACCEPTANCE TESTING- Testing to verify a product meets customer

specified requirements. A customer usually does this type of testing on
a product that is developed externally.
 BLACK BOX TESTING- Testing without knowledge of the
internal workings of the item being tested.

Tests are usually functional FUNCTIONAL TESTING-

Validating an application or Web site conforms to and correctly
performs all its required functions. This entails a series of tests
which perform a feature by feature validation of behavior, using a
wide range of normal and erroneous input data.
This can involve testing of the product’s user interface, APIs,
database management, security, installation, networking, etc..
testing can be performed on an automated or manual basis using
black box or white box methodologies.
+
REGRESSION TESTING- Similar in scope to a functional test, a
regression test allowsa consistent, repeatable validation of each new
release of a product or Web site. Suchtesting ensures reported
product defects have been corrected for each new release andthat no
new quality problems were introduced in the maintenance process.
Thoughregression testing can be performed manually an
automated test suite is often used toreduce the time and resources
needed to perform the required testing.

SYSTEM TESTING- Testing conducted on a complete,

integrated system to eval- uatethe system’s compliance with its
specified requirements. System testing falls within thescope of
black box testing, and as such, should require no knowledge of the
inner designof the code or logic.

UNIT TESTING- Functional and reliability testing in an Engineering

envi- ronment.Producing tests for the behavior of components of a
product to ensure their correct behavior prior to system integration
WHITE BOX TESTING- Testing based on an analysis
of internal workings andstructure of a piece of software.
Includes techniques such as Branch Testing and
PathTesting. Also known as Structural Testing and
Glass Box Testing.
5.2 Test cases and Test Results

Table 5.1 Table

Test case Test result

Open Internet Explorer Internet Explorer Window is di
Go to home page home page is displayed in
Enter valid user name and valid password to User has access to admin main
login menu or use
Relevance of search results Display a list of search results in
Query response time 10 seconds
Test the creation, modification, and deletion of Allow to update relavent product
data by admin
Links’ perfomence and test toolbar and menu Go to the specify page
item
Fileds in registration form Show alert box if not fill the fields
and not
Graphics Visually appear
shipping calculations Accurate and do within 9 sec
Purchase items If not login show alert to lo
Use used email for new register Show message that already
email ha
Use invalid email Show message that email is
SCREEN DESIGN

GUI Design
3.5 Program Design
Coding:

Index.ph

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0

Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-
8859- 1" />
<title>Welcome to Furniture Showroom</title>
<style type="text/css">
<!--
body,td,th {
font-family: Arial, Helvetica, sans-

serif; font-size: 12px;

color: #333333;

}
body {
 margin-left: 0px;

margin-top: 0px;

margin-right: 0px;

margin-bottom:
}

-->
0px;

</style>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>

<body>
<table width="980" border="0" align="center" cellpadding="0"
cellspacing=" 0">
<tr>
<td height="1034" align="left" valign="top"><table
width="100%" border="0" cellspacing=" 0" cellpadding="0">
<tr>
<td height="70" align="left" valign="middle"><table
width="100%" border="0" cellspacing=" 0" cellpadding="0">
<tr>
<td width="69%" height="110" rowspan="2" align="left"
valign="middle"><img src="images/logo3.jpg" width="640"
height="100" /></td>
<td height="64" colspan="2" align="left"
valign="middle"><table width="60%" border="0" align="center"
cellpadding="0" cellspacing=" 0">
<tr>
<td width="19%" rowspan="2" align="center"
valign="middle"><img src="images/shopping-cart.gif" width="13"
height="11" /></td>
 <td width="81%" height="25" align="left"
valign="middle" class="spacer"> Shopping Cart:</td>
</tr>
<tr>
<td align="left" valign="top">now in your cart<a href="#"
class="menu1"><strong> 0 items</strong></a></td>
</tr>
</table></td>
</tr>
<tr>
<td width="24%" align="left" valign="middle" style="padding-
left:20px;"><strong>Search :</strong>
<input type="text" name="textfield" /></td>
<td width="7%" align="left" valign="middle"><img
src="images/go_botton.gif" width="50" height="23" /></td>
</tr>
</table></td>
</tr>
<tr>
<td height="10" align="left" valign="top" > </td>
</tr>
<tr>
<td height="38" align="left" valign="middle"
background="images/botton_bg.gif" ><table width="100%" border="0"
cellspacing=" 0" cellpadding="0">
<tr>
<td align="center" valign="middle"><a href="index.html"
class="menu7">Home</a></td>
<td width="1" align="center" valign="middle"><img
src="images/botton_bg_img.gif" width="2" height="38" /></td>
 <td align="center" valign="middle"><a href="aboutus.html"
class="menu7">About us </a></td>
<td width="1" align="center" valign="middle"><img
src="images/botton_bg_img.gif" width="2" height="38" /></td>
<td align="center" valign="middle"><a
href="store_location.html" class="menu7">Store Locations
</a></td>
<td width="1" align="center" valign="middle"><img
src="images/botton_bg_img.gif" width="2" height="38" /></td>
<td align="center" valign="middle"><a href="specials.html"
class="menu7">Specials</a></td>
<td width="1" align="center" valign="middle"><img
src="images/botton_bg_img.gif" width="2" height="38" /></td>
<td align="center" valign="middle"><a href="newproducts.html"
class="menu7">New Products </a></td>
<td width="1" align="center" valign="middle"><img
src="images/botton_bg_img.gif" width="2" height="38" /></td>
<td align="center" valign="middle"><a href="myaccount.html"
class="menu7">My Account </a></td>
<td width="1" align="center" valign="middle"><img
src="images/botton_bg_img.gif" width="2" height="38" /></td>
<td width="1" align="center" valign="middle"><img
src="images/botton_bg_img.gif" width="2" height="38" /></td>
<td align="center" valign="middle"><a href="contactus.html"
class="menu7">Contact us </a></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top" style="padding-
top:10px;"><table width="100%" border="0" cellspacing=" 0"
cellpadding="0">
<tr>
 <td width="75%" align="left" valign="top"><table
width="96%" border="0" align="center" cellpadding="0"
cellspacing=" 0">
 <tr>
<td align="left" valign="top"><img
src="images/flash_td_top_left.gif" width="6" height="6" /></td>
<td align="left" valign="top"
background="images/flash_td_top_spacer.gif"> </td>
<td align="left" valign="top"><img
src="images/flash_td_top_right.gif" width="6" height="6" /></td>
</tr>
<tr>
<td align="left" valign="top"
background="images/flash_td_left_spacer.gif"> </td>
<td align="left" valign="top"><object
classid="clsid:D27CDB6E-AE6D-11cf-96B8-
444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/s
wflash.cab#version=7,0,19,0" width="697" height="258">
<param name="movie" value="images/flash.swf" />
<param name="quality" value="high" />
<embed src="images/flash.swf"
quality="high"
pluginspage="http://www.macromedia.com/go/getflashplay
er" type="application/x-shockwave-flash" width="697"
height="258"></embed>
</object></td>
<td align="left" valign="top"
background="images/flash_td_right_spacer.gif"> </td>
</tr>
<tr>
<td align="left" valign="top"><img
src="images/flash_td_bottom_left.gif" width="6" height="6"
/></td>
<td align="left" valign="top"
background="images/flash_td_bottom_spacer.gif"></td>
<td align="left" valign="top"><img
src="images/flash_td_bottom_right.gif" width="6" height="6"
/></td>
</tr>
 </table></td>
<td width="25%" align="left" valign="top"><table
width="100%" border="0" cellspacing=" 0"
cellpadding="0">

<tr>
<td align="center" valign="middle"><a
href="#"><img src="images/new_collection.jpg" width="234"
height="133" border="0" /></a></td>
</tr>
<tr>
<td height="5" align="center" valign="middle"> </td>
</tr>
<tr>
<td align="center" valign="middle"><a href="#"><img
src="images/save.jpg" width="234" height="133" border="0"
/></a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top" style="padding-right:8px;
padding- left:8px;"><table width="100%" border="0"
align="center" cellpadding="0" cellspacing=" 0">
<tr>
 <td width="22%" height="495" align="left"
valign="top"><table width="98%" border="0" cellspacing=" 0"
cellpadding="0">
<tr>
<td align="left" valign="top"><table width="100%"
border="0" cellspacing=" 0" cellpadding="0">
<tr>
<td width="14" align="left" valign="top"><img
src="images/categori_td_top_left.gif" width="14" height="43" /></td>
<td align="left" valign="middle"
background="images/categori_td_top_spacer.gif"><table
width="100%" border="0" cellspacing=" 0" cellpadding="0">
<tr>
<td width="23%" align="center" valign="middle"><img
src="images/categiry_icon.gif" width="41" height="35" /></td>
<td width="77%" align="left" valign="middle"
class="header" style="padding-left:5px;">Categories</td>
</tr>
</table></td>
<td width="14" align="left" valign="top"><img
src="images/categori_td_top_right.gif" width="14" height="43" /></td>
</tr>
<tr bgcolor="#E3EBE9">
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top"><table width="94%"
border="0" align="right" cellpadding="0" cellspacing=" 0">
<tr>
<td width="15" height="6" align="left"
valign="middle"></td>
<td align="left" valign="middle"></td>
</tr>
 <tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Home Furniture</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Armoire-&gt;</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Bookcases</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Closet Storage</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Coffee Tables</a></td>
</tr>
 <tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Computer Carts</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Computer Desks</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Executive Desks</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Major Repairs</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Cabinets and Storage</a></td>
</tr>
<tr>
 <td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Mirrors</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Plant Stands</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Quilt Racks</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Table Lamps</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrow 2.gif" width="4" height="7" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu2">Telephone Stands</a></td>
</tr>
<tr>
<td height="8" align="left" valign="middle"></td>
 <td height=" " align="left" valign="middle"></td>
</tr>
</table></td>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top"><img
src="images/categori_td_bottom_left.gif" width="14" height="9" /></td>
<td align="left" valign="top" bgcolor="#E3EBE9"> </td>
<td align="left" valign="top"><img
src="images/categori_td_bottom_right.gif" width="14" height="9"
/></td>

</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
</tr>
</table></td>
 <td width="53%" align="left" valign="top"><table
width="99%" border="0" align="center" cellpadding="0"
cellspacing=" 0">
<tr>
<td height="45" align="left" valign="middle" style="padding-
left:10px;"><img src="images/featured.gif" width="209" height="23"
/></td>

</tr>
<tr>
<td align="left" valign="top"><table width="100%"
border="0" cellspacing=" 0" cellpadding="0">
<tr>
<td align="left" valign="top" style="border:#CCCCCC
solid 1px;"><table width="95%" border="0" align="center"
cellpadding="0" cellspacing=" 0">
<tr>
<td height="20" colspan="2" align="center"
valign="middle"><a href="#" class="menu7">Office
Desks</a></td>
</tr>
<tr>
<td colspan="2" align="center" valign="middle"><img
src="images/product_1.jpg" width="100" height="137" /></td>
</tr>
<tr>
<td rowspan="2" align="center" valign="middle"><span
class="text_2"><strong>$ 999.00 </strong></span></td>
<td height="25" align="left" valign="middle"
class="text_2"><a href="#"><img src="images/details.gif"
width="64" height="21" border="0" /></a></td>
</tr>
<tr>
 <td height="25" align="left" valign="middle"><a
href="#"><img src="images/add-to-cart.gif" width="90"
height="21" border="0" /></a></td>
</tr>
</table></td>
<td align="left" valign="top" style="border-
top:#CCCCCC solid 1px; border-bottom:#CCCCCC solid
1px;"><table width="95%" border="0" align="center"
cellpadding="0" cellspacing=" 0">
<tr>
<td height="20" colspan="2" align="center"
valign="middle"><a href="#" class="menu7">Chairs</a></td>
</tr>
<tr>
<td colspan="2" align="center" valign="middle"><img
src="images/chair.jpg" width="100" height="137" /></td>
</tr>
<tr>
<td rowspan="2" align="center" valign="middle"><span
class="text_2"><strong>$ 999.00 </strong></span></td>
<td height="25" align="left" valign="middle"
class="text_2"><a href="#"><img src="images/details.gif"
width="64" height="21" border="0" /></a></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" ><a
href="#"><img src="images/add-to-cart.gif" width="90"
height="21" border="0" /></a></td>
</tr>
</table></td>
<td align="left" valign="top" style="border:#CCCCCC
solid 1px;"><table width="95%" border="0" align="center"
cellpadding="0" cellspacing=" 0">
 <tr>
<td height="20" colspan="2" align="center"
valign="middle"><a href="#" class="menu7">sofas</a></td>
</tr>
<tr>
<td colspan="2" align="center" valign="middle"><img
src="images/cussionchair.jpg" width="100" height="137" /></td>
</tr>
<tr>
<td rowspan="2" align="center" valign="middle"><span
class="text_2"><strong>$ 999.00 </strong></span></td>
<td height="25" align="left" valign="middle"
class="text_2"><a href="#"><img src="images/details.gif"
width="64" height="21" border="0" /></a></td>
</tr>
<tr>
<td height="25" align="left" valign="middle"><a
href="#"><img src="images/add-to-cart.gif" width="90"
height="21" border="0" /></a></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
 <td align="left" valign="top" style="border:#CCCCCC
solid 1px;"><table width="95%" border="0" align="center"
cellpadding="0" cellspacing=" 0">
<tr>
<td height="20" colspan="2" align="center"
valign="middle"><a href="#" class="menu7">Red sofa
</a></td>
</tr>
<tr>
<td colspan="2" align="center" valign="middle"><img
src="images/redcorpet.jpg" width="120" height="137" /></td>
</tr>
<tr>
<td rowspan="2" align="center" valign="middle"><span
class="text_2"><strong>$ 999.00 </strong></span></td>
<td height="25" align="left" valign="middle"
class="text_2"><a href="#"><img src="images/details.gif"
width="64" height="21" border="0" /></a></td>
</tr>
<tr>
<td height="25" align="left" valign="middle"><a
href="#"><img src="images/add-to-cart.gif" width="90"
height="21" border="0" /></a></td>
</tr>
</table></td>
<td align="left" valign="top" style="border-
top:#CCCCCC solid 1px; border-bottom:#CCCCCC solid
1px;"><table width="95%" border="0" align="center"
cellpadding="0" cellspacing=" 0">
<tr>
<td height="20" colspan="2" align="center"
valign="middle"><a href="#" class="menu7">teapoy</a></td>
</tr>
<tr>
 <td colspan="2" align="center" valign="middle"><img
src="images/teapoy.jpg" width="120" height="137" /></td>
</tr>
<tr>
<td rowspan="2" align="center" valign="middle"><span
class="text_2"><strong>$ 999.00 </strong></span></td>
<td height="25" align="left" valign="middle"
class="text_2"><a href="#"><img src="images/details.gif"
width="64" height="21" border="0" /></a></td>
</tr>
<tr>
<td height="25" align="left" valign="middle"><a
href="#"><img src="images/add-to-cart.gif" width="90"
height="21" border="0" /></a></td>
</tr>
</table></td>
<td align="left" valign="top" style="border:#CCCCCC
solid 1px;"><table width="95%" border="0" align="center"
cellpadding="0" cellspacing=" 0">
<tr>
<td height="20" colspan="2" align="center"
valign="middle"><a href="#" class="menu7">bistro tables
</a></td>
</tr>
<tr>
<td colspan="2" align="center" valign="middle"><img
src="images/bistrotables.jpg" width="120" height="137" /></td>
</tr>
<tr>
<td rowspan="2" align="center" valign="middle"><span
class="text_2"><strong>$ 999.00 </strong></span></td>
 <td height="25" align="left" valign="middle"
class="text_2"><a href="#"><img src="images/details.gif"
width="64" height="21" border="0" /></a></td>
</tr>
<tr>
<td height="25" align="left" valign="middle"><a
href="#"><img src="images/add-to-cart.gif" width="90"
height="21" border="0" /></a></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>

</table></td>
</tr>
</table></td>
<td width="25%" align="left" valign="top"><table
width="98%" border="0" align="right" cellpadding="0"
cellspacing=" 0">
<tr>
<td align="left" valign="top"><table width="100%"
border="0" cellspacing=" 0" cellpadding="0">
<tr>
<td width="14" align="left"
valign="top"><img src="images/td-top_left.gif"
width="14" height="43" /></td>
 <td align="left" valign="middle"
background="images/td- top_spacer.gif"><table width="100%"
border="0" cellspacing=" 0" cellpadding="0">
<tr>
<td width="23%" align="center"
valign="middle"><img src="images/best_sellers_icon.gif"
width="26" height="32" /></td>
<td width="77%" align="left" valign="middle"
class="header1" style="padding-left:5px;">New Products </td>
</tr>
</table></td>
<td width="14" align="left"
valign="top"><img src="images/td-top_right.gif"
width="14" height="43" /></td>
</tr>
<tr>
<td align="left" valign="top" background="images/td-
left_spacer.gif">&nbsp;</td>
<td align="left" valign="top"><table width="94%"
border="0" align="right" cellpadding="0" cellspacing=" 0">
<tr>
<td width="15" height="6" align="left"
valign="middle"></td>
<td align="left" valign="middle"></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrows_1.gif" width="6" height="5" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu1">Entryway Storage</a></td>
</tr>
<tr>
 <td height="20" align="left" valign="middle"><img
src="images/arrows_1.gif" width="6" height="5" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu1">Nightstands, Tables</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrows_1.gif" width="6" height="5" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu1">Sofas</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrows_1.gif" width="6" height="5" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu1">Daybeds, Chaises</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrows_1.gif" width="6" height="5" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu1">Chairs, Barstools</a></td>
</tr>
<tr>
<td height="20" align="left" valign="middle"><img
src="images/arrows_1.gif" width="6" height="5" /></td>
<td height="18" align="left" valign="middle"><a
href="#" class="menu1">Living Room Storage</a></td>
</tr>
 <tr>
<td height="8" align="left"
valign="middle"></td>
<td height=" " align="left" valign="middle"></td>
</tr>
</table></td>
<td align="left" valign="top" background="images/td-
right_spacer.gif">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top"><img src="images/td-
botom_left.gif" width="14" height="10" /></td>
<td align="left" valign="top" background="images/td-
botom_spacer.gif"></td>
<td align="left" valign="top"><img src="images/td-
botom_right.gif" width="14" height="10" /></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top"><table width="100%"
border="0" cellspacing=" 0" cellpadding="0">
<tr>
<td width="14" align="left"
valign="top"><img src="images/td-top_left.gif"
width="14" height="43" /></td>
<td align="left" valign="middle"
background="images/td- top_spacer.gif"><table width="100%"
border="0" cellspacing=" 0" cellpadding="0">
 <tr>
<td width="23%" align="center" valign="middle"><img
src="images/special_icon.gif" width="40" height="35" /></td>
<td width="77%" align="left" valign="middle"
class="header1" style="padding-left:5px;">Specials</td>
</tr>
</table></td>
<td width="14" align="left"
valign="top"><img src="images/td-top_right.gif"
width="14" height="43" /></td>
</tr>
<tr>
<td align="left" valign="top" background="images/td-
left_spacer.gif">&nbsp;</td>
<td align="center" valign="top" style="
padding- top:5px;"><table width="100%" border="0"
cellspacing=" 0" cellpadding="0">
<tr>
<td align="center" valign="middle"><a href="#"><img
src="images/specials.jpg" width="133" height="68" border="0"
/></a></td>

</tr>
<tr>
<td height="30" align="center" class="header"><a
href="#" class="menu7">Office Furniture</a></td>
</tr>
</table></td>
<td align="left" valign="top" background="images/td-
right_spacer.gif">&nbsp;</td>
</tr>
<tr>
 <td align="left" valign="top"><img src="images/td-
botom_left.gif" width="14" height="10" /></td>
<td align="left" valign="top" background="images/td-
botom_spacer.gif"></td>
<td align="left" valign="top"><img src="images/td-
botom_right.gif" width="14" height="10" /></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top">&nbsp;</td>
</tr>
<tr>
<td height="2" align="left" valign="top" bgcolor="#CCCCCC">
</td>
</tr>
<tr>
<td height="1" align="left" valign="top"> </td>
 </tr>
<tr>
<td height="75" align="center" valign="middle"
background="images/footer_spacer.jpg" class="text1"><a
href="index.html" class="menu1">Home </a> &nbsp;|<a
href="aboutus.html" class="menu1"> About us</a> |<a
href="store_location.html" class="menu1"> Store Locations</a> |
<a href="specials.html" class="menu1"> Specials</a> | <a
href="newproducts.html" class="menu1">New Products</a> |<a
href="myaccount.html" class="menu1"> My Account</a> | <a
href="contactus.html" class="menu1">Contact us </a><br />

&copy; Copyright 2009 <strong>Furniture

Showroom</strong> allrights are reserved </td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>

Login.php

<?php include_once("header.php") ;

include("dbconnect.php");?>
<link href="pagecss.css" rel="stylesheet" type="text/css" />
<tr>
<td align="left" valign="top" style="padding-right:8px;
padding- left:8px;"><table width="100%" border="0"
align="center" cellpadding="0" cellspacing=" 0">
<tr>
<td width="22%" height="495" align="left" valign="top"><?php
include_once("categories.php"); ?></td>
<td width="53%" align="left" valign="top">
 <table width="100%" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td class="header12" align="left"
valign="middle" style="padding-left:10px;">User
Login</td>
</tr>
<tr>
<td class="header12" align="left"
valign="middle" style="padding-
left:10px;">&nbsp;</td>
</tr>
<tr>
<td><form action="loginval.php" method="post">
<table width="100%" border="0" cellpadding="0" cellspacing="1"
bgcolor="#d5e7f5">

<tr>
<td bgcolor="#ffffff" align="center" width="704"
valign="top"><table cellspacing="0" cellpadding="3" border="0"
width="80%">

<tr>
<td align="center" colspan="2"/> </tr>
<tr>
<td colspan="2" align="center" class="text1"
style="font- size:18px; font-family: Tahoma, 'Trebuchet MS', 'Tw Cen
MT';"><strong>Login Here</strong></td>
</tr>
<tr>
 <td colspan="2" align="right"
class="text1">&nbsp;</td>
</tr>
<tr>
<td width="323" align="right"
class="text1"><strong>Email Address:</strong></td>
<td width="357" align="left" class="box"><input
type="text" value="" name="uname"/></td>
</tr> <tr>
<td align="right"
class="text1"><strong><strong>Password</strong>:</strong></td>
<td align="left" class="box"><input
type="password" value="" name="pass"/></td>
</tr>
<tr>
<td align="right">&nbsp;</td>
<td align="left"><input type="submit"

name="submit" value="Login"/></td>
</tr>
<tr>
<td colspan="2" align="center" ><?php if($_GET['error'])
{ echo "<font
color=#FF0000 >
<span>You Are Not A Valid User</span>
</font> "; } ?> <?php if($_GET['error2']) { echo
"<font color=#FF0000 >
<span>Please Enter Email-Id And Password</span>
</font> "; } ?></td>

</tr>
<tr>
 <td colspan="2" align="center" ><a class="menu1"
href="forgotpassword.php">Forgot Password?</a> | <a class="menu1"
href="register.php">Donot Have an Account? </a></td>
</tr>

</table> </td>
</tr>
</table></form></td>
</tr>
</table></td>
<td width="25%" align="left" valign="top"><?php
include_once("rightside.php"); ?></td>

</tr>
</table></td>
</tr>
<?php include_once("footer.php"); ?>

Future Scope
Limitations of existing system:

At present, the requirements of the system are done

manually and hence there are number of limitations.

❖ The various activities are carried out by different

section depending on their activity.
 ❖ The various status information is maintained in books
and files, which is very difficult.
❖ Reports are produced by manual processing, that will be
an unformatted manual and unreliable.
❖ Data security is less.
❖ Calculations are done manually.

Comparative system study or Future Scope

This site has great future scope.Online shopping system is developed

on and for the Windows and later versions environments and Linux
OS. This project also provides security with the use of Login-id and
Password, so that any unauthorized users can not use your account.
The only Authorized that will have proper access authority can access
the software.

PROPOSED SYSTEM:

The proposed s system tries to avoid the problems arises in the

existing system. It automates the entire process of embroiling
management System. It should have a provision to maintain master
entries, provision to Prepare inward, invoice etc. It should also provide
often needed reports to Satisfy the need of the concern.

ADVANTAGES

As the proposed system is system oriented it is faster than the

manual process
It also minimizes the errors in the data entry.
It improves customer satisfaction due to the improvement.
 CONCLUSION

This project is successfully completed and works properly according to

the needs this project is developed in Php, mysql & crystal reports. The

system maintains data consistency by avoiding manual error &sock

are maintained accurately which reduces the losses that can be made

due to various environment features. All the requirement regard to this

problem are solved the needs specified in the problem definition are

fulfilled. This project will help all end users as a user-friendly system.