ONLINE PET SHOPPING

PROJECT WORK
Submitted in partial fulfillment of Thiruvalluvar University for the award
of
BACHELOR OF COMPUTER APPLICATION
By

[Link]
[[Link].36521U09001]
[Link] RANI
[[Link].36521U09009]
Under the guidance of

[Link].,[Link].,[Link].,[Link]
Head of the Department of Computer Science & Application

D.L.R ARTS & SCIENCE COLLEGE(Co-Ed)

2021-2024

1
 BONAFIDE CERTIFICATE

This is to certify that this Project report on “ONLINE PET SHOPPING”

Is Bonafide work of [Link] ([Link].36521U09001), [Link]

RANI (Reg. No. 36521U09009) Student who carried out project work under my
supervision certified further, that to the best of my knowledge this report doesn’t
from a port of any other project report to dissertation on the basis D.L.R ARTS &
SCIENCE COLLEGE which degree or award was conferred on an earlier occasion on
any other candidate.

INTERNAL GUIDE PRINCIPAL

INTERNAL EXAMINER EXTERNAL EXAMIN

2
 DECLARATION

[Link](Reg. No. 36521U09001).,

[Link] RANI([Link].36521U09009) hereby declare that the project report titled

“ONLINE PET SHOPPING ”is the original work done by Submitted in partial

fulfillment of the requirement for the award of BACHELOR OFCOMPUTER

APPLICATION in THIRUVALLUVAR UNIVERSITY, SERKADU is my original

work andit has formed the basis for the award of any other degree.

[Link]
PLACE:
([Link].36521U09001)

DATE:

[Link] RANI

([Link].36521U09009)

3
 ACKNOWLEDGEMENT

First, I whole heartily thank the lord almighty having me good opportunitymy
project successfully.

I wish to express my sincere thanks to our Respected Chairman Mr.D.L. RAVI

and the Secretary [Link] [Link].,[Link].,[Link]., D.L.R College of Arts,
Science and Management, Villapakkam.

I extent my thanks to our respected Principal [Link]

[Link].,[Link].,Ph.D., For allowing me to do a project work in partial fulfillment of
the degree on Bachelor of computer science and application.

I express my thank to [Link].,[Link].,[Link].,[Link]., Head of the

department of Computer Science & Application for his advice and guidance
throughout the project.

Finally, I wish to thank my beloved parents, brothers, and my friends who have
supported me every day to complete the project work.

[Link]
[Link] RANI

4
 ABSTRACT

This Online Pet Shop Web Application was developed using HTML, CSS, PHP, MySQL
Database, JavaScript (jQuery/Ajax), Bootstrap, and startbootstrap free template.
The projects are to provide a web-based interface to a pet shop owner to manages his
petshop activities. products can also be add, delete and update. They can see the sales
details of the product they have sell. the front end codes use for the main page,
insertion, search, deletion are displayed.

5
[Link] TABLE 0F CONTENT PAGE NO

1. INTRODUCTION 7-9

2. HARDWARE AND SOFTWARE 10-11

REQUIREMENT

3. SYSTEM ANALYSIS 12-13

4. IMPLEMENTATION ISSUES 14-26

5. SYSTEM DESIGN 27-29

6. USER SCREENS 30-39

7. CODING 40-59

8. BIBLIOGRAPHY 60-63

6
 CHAPTER 1

Introduction

 Introduction
 Problem Definition
 Aim
 Objective
 Goal
 Need of System

Introduction to the System:

7
 This Pet Shop Online Shopping System using php was designed to manage the
pet information such to produce the pet breed and the vaccine schedules. It is also
performed in systematic through its function requirement. The management of pet
shop includes the services offers such as cleaning, scissoring, bathing and blow-
drying.
First, the pet must be registered before having any services. Any piece of information
about the pets must be correct and organized to avoid any problem to be in countered
like the bad feedback from the [Link] purpose of this system is to transact and
deals with a nice and easier way by simply gathering information from the customer. It
also helps to every individual by searching for the information [Link] image

Problem Definition:
Managing your Pet Shop Online Shopping may seem tricky, but a Pet Shop Online
Shopping is a part of E-commerce Service System (Application support direct contact
with users).
 Existing sytems are not user friendly.
 Admin panel need improvement for getting more options for easy working.
 Pet Shop Online Shopping searching option need more filters.

Aim:
“To Manage Pet Shop Online Shopping Project”.

Objective:
 To perform a thorough analysis of working of the whole
System.

8
  To study the problems in the System through fact finding
techniques.
 To follow SDLC to develop the system.
 To develop conceptual, logical and physical model for
the system.
 To develop Graphical User Interface (GUI) as per
convenience of the user.
 To implement the physical model, being tested as per the
standards.
 To document our efforts and analysis in a proper
comprehensible manner.
Goal:
∙ The project is basically targeted at those people who would like
to Online Pet Shop and have an Internet access.
 Finally Pet lovers curious in comparing the prices for
various Pet for their selected category.
 To make a database that is consistent, reliable and secure.
 To provide correct, complete, ongoing information.
 To develop a well-organized information storage system.
 To make good documentation so as to facilitate possible
future enhancements.
Need of the System:
There is always a need of a system that will perform to search and buy now Pet Shop
Online Shopping, online according to service.

Thus, there is a big need of Pet Shop Online Shopping services, which provides all
the Above- mentioned facilities and many more.

9
 CHAPTER 2

Hardware and Software Requirement

 Introduction
 System environment
 Software requirement
 Hardware requirements

Introduction:
In this chapter we mentioned the software and hardware requirements, which
are necessary for successfully running this system. The major element in
building systems is selecting compatible hardware and software. The system
analyst has to determine what software package is best for the “Pet Shop

10
Online Shopping” and, where software is not an issue, the kind of hardware
and peripherals needed for the final conversion.

System Environment:
After analysis, some resources are required to convert the abstract system into
the real one. All the resources, which accomplish a robust
The hardware and software selection begins with requirement analysis,
followed by a request for proposal and vendor evaluation.

Software and real system, are identified. According to the provided functional
specification all the technologies and its capacities are identified. Basic
functions and procedures and methodologies are prepared to implement. Some
of the Basic requirements such as hardware and software are described as
follows: -
Hardware and Software Specification
Requirements:

 Microsoft Windows 7/8.

 HTML/PHP.

 Apache Server

 My SQL.

 Ms-Office package.

Hardware Requirements:

 Intel Processor 2.0 GHz or above.

 2 GB RAM or more.

 160 GB or more Hard Disk Drive o

11
 CHAPTER 3

System Analysis

 Purpose
 Project Scope
 Existing System
 Proposed System
 System Overview

Purpose:

To manage the Pet Shop Online Shopping. It helps to customers to search via varius type of
Pet list, buy Pet and from anywhere. Also make payment online for it. It helps to people to
find and Buy Pet online.

12
Project Scope:
The project has a wide scope, as it is not intended to a particular organization. This
project is going to develop generic software, which can be applied by any businesses
organization. More over it provides facility to its customers. Also the software is going
to provide a huge amount of description of every product.

Proposed System:

The Online Pet Shopping is available in the market that can serve customers to find
and Buy Pet shop online.

System Overview:

It allows registered users to do the following:

 Sign Up Now
 Select New Arrivals list
 Add Pet to Cart
 Remove Pet from Add To Cart
 Get Pyment Option
 Finalize buy to Pet

Features of Admin

 The admin is a superuser that have access To Login

 He can Add Pet Category
 He can Add Sub Category
 He can view Pet Category

13
 CHAPTER 4

Implementation issues

 PHP
 AJAX
 Cascading style sheet(CSS)
 System Description

4.1 PHP
Definition of PHP:

PHP can be defined as a programming language for Database access from the web's browser.

14
In other words, it is an HTML-embedded scripting language. It focuses on the logic of how a
page responds to user input and not how the page looks that i.e. not the primary appearance
of the page.
PHP runs on the server side, which means that the web server that sends an HTML file to a
user's browser, will carry out the instructions found in the embedded PHP code first, and then
send the output of the PHP code along with the HTML code. The result is a webpage with
dynamic content.
Brief History on PHP:
PHP is a language for creating website that can be more or less interactive. It was created in
1994 by Rasmus Lerdorf who was a software engineer and who was part of the Apache Team.
In the same year, he created a package, added some database support and called it PHP/FI
(Form Interpretation).
In 1995, it was called the Personal Home Page Tool then was released as version2 with a
name called PHP/FI (a form interpreter responsible for analyzing queries). In mid of 1997,
more than 50,000 websites began using PHP and in October, 1998, there was an increase in
the number of websites using PHP which was about 100,/000.
In 2000, there was a release of PHP 4.0.2. And currently over 1,000,000 sites in the whole
world are using PHP.
PHP and its Uses:
Php can help read and write files. It also can do basic files and directory maintenance; there -
fore it basically can help one in editing documents. It can also take content that can be used in
the generation of files in various formats which can include HTML (Hypertext Markup Lan-
guage) and PDF.
It also can help manage graphical content which include charts. Not only can it do the above
but can it also read, write information in a database. You can make a PHP script to run it
without any server or browser. You only need the PHP interpreter to use it. PHP's abilities
include outputting images, PDF files, and even Flash movies. PHP can help also output easily
any text, such as XML
Advantages and Disadvantages of PHP:
It is more or less cost –free in other words, PHP is an Open Source solution, freely available
for a wide variety of platforms. It is also easy, as it’s a combination of C and Perl. The
strongest and most significant feature of PHP is its native database support
for a wide range of databases for example (MySQL, mSQL, Oracle), which allows access to
the databases directly through SQL statements.*
15
There is a cross-platform compatibility (Windows, Macintosh, or a version of Unix,):
Compiled and is built on more than 25 platforms. With PHP, you have ‘freedom of
choice’ regarding an operating system and a Web server. The error handling is not as
sophisticated as in ASP (Active Server Pages).
4.2 AJAX
AJAX is a relatively new method to create rich internet applications with responsive
interfaces that allow the designer to take a lot of the tedium out of using web-based mediums
for day-to-day data interaction. The scope of this paper will be to provide information about
what AJAX is and what it does, when it should and shouldn’t be used and what the future
looks like for AJAX in comparison to the present and future alternatives. This will help
developers determine the value of using AJAX in their projects and provide information
about the proper use of this technology. This report will assume a basic knowledge with web
forms and the design of web applications.
AJAX is an acronym for Asychronous JavaScript and XML. It is not a technology in itself,
but rather a suite of technologies. The combination of JavaScript and XML allows for a
responsive user interface. It requires more development time than a traditional web solution;
however a well-designed AJAX user interface makes the traditional form-based web
application seem almost archaic.

4.3 CASCADING STYLE SHEET(CSS)

What are Cascading Style Sheets?

Cascading Style Sheets (CSS) are a collection of rules we use to define and modify web
pages. CSS are similar to styles in Word. CSS allow Web designers to have much more
control over their pages look and layout. For instance, you could create a style that defines
the body text to be Verdana, 10 point. Later on, you may easily change the body text to Times
New Roman, 12 point by just changing the rule in the CSS. Instead of having to change the
font on each page of your website, all you need to do is redefine the style on the style sheet,
and it will instantly change on all of the pages that the style sheet has been applied to. With
HTML styles, the font change would be applied to each instance of that font and have to be
changed in each spot.

16
CSS can control the placement of text and objects on your pages as well as the look of those
objects.

HTML information creates the objects (or gives objects meaning), but styles describe how the
objects should appear. The HTML gives your page structure, while the CSS creates the
“presentation”. An external CSS is really just a text file with a .css extension. These files can
be created with Dreamweaver, a CSS editor, or even Notepad.

The best practice is to design your web page on paper first so you know where you will want
to use styles on your page. Then you can create the styles and apply them to your page.

Css Rules
A Style Sheet is made up of Rules. A Rule is one or more properties that will be applied to
one or more elements. Each rule will have a selector and a definition. A Style Sheet can be
collection of Styles; however, a style sheet could have just one style.

A style rule consists of a selector and the properties or attributes of that selector that are to be
affected. These properties or attributes are contained within curly brackets and called the
style definition. For example in the style rule: h2 {color: red; font-family: Arial ;}, h2 is
the selector and the rest (within the curly brackets) is the style definition. The standards of the
style rules are that each attribute is followed by a colon (:) followed by the value for that
attribute. Then each set (of attribute and value) is followed by a semicolon (;). Several style
attributes can be assigned at one time to a tag or selector or multiple tags. For example you
could specify the font family and color of all the heading tags at once (with a comma between
each one) and then give each one a separate size in a different rule.
Several tags being defined at once:

h1,h2,h3,h4 {
color: #ff3300;
font-family: Arial;
}
Then define the size of this one tag separately:

17
 h1{
font-size: 160%;
}

To define a style using Dreamweaver, you can either redefine the predefined tags such as the
Heading 1 tag, Heading 2 tag, the paragraph tag, etc. or define a custom style that you create.
The tag or the custom style is the selector. One custom style is called a class. Classes can be
used many times. Another custom style is an ID. An ID is similar to a class, but it can only
be used once. You can also create specific styles by combining selectors. For example you
could set up a sidebar for News and specify that only paragraph text within that section
should be a particular color or size.
.news p {
font-size: 80%;
color: blue;
}

CSS Styles

There are three kinds of Styles: Inline, Embedded (or Internal), and External (or Linked).
One or more types of styles can be used for each web page.

Inline styles are very similar to HTML styles in that they are placed in the <body> of your
document and good for only that one instance. The style definition must be marked by
<style= attributes:values;> tags. This type is not commonly used because they are specific
to each instance and would be time consuming to change and could not be used for other
pages in your site.

Embedded / Internal styles are placed in the <head> of your document with the tag
<style type=”text/css”> tags.
The selector and the definition will be enclosed by comment markers <!-- --> and end with
</style> and will be good for the whole page. Comment markers are good for documentation
or to hide information from older browsers.

18
An External (Linked) Style Sheet is a totally separate document from the HTML document
and can be linked to and utilized by many pages. Create the link in this manner:
<link rel="stylesheet" type="text/css"
href="full/path/to/[Link]">
This is telling the browser that the link relates to a CSS style sheet, it is in text and the path to
the sheet follows the href tag.

The external style sheet contains no HTML tags. HTML tags in a style sheet can cause it to
not function properly. It even has it’s own comment tag :
/* CSS Comment */

Using External Style Sheets takes advantage of one of the most powerful features of CSS
which is the ability to make changes to the style and have it immediately change all of your
web pages. For example if you have a particular color scheme that needs to be changed you
would just have to change the properties in the style sheet and all of the pages linked to that
sheet would be changed. Also if you create a style and reuse it several times you shrink the
size of your file. Therefore, the External style sheet is the type of style sheet used most often.

19
5. Testing

5.1 Testing Objectives

Testing meets 3 objectives:

1. Identification of Errors:

These are obvious anomalies that show up in the behavior of a program or a unit or a
component. Such behavior as the following is considered an error:

 Wrong totals

 Misalignments

 Messages that say the wrong thing

 Actions that do not execute as promised: the Delete button does not delete,
the update menu does not update properly, etc.

2. Conformance to requirements:
These errors are the result of testing the functions in the software against the Requirement
Definition Document to ensure that every requirement, functional or non-functional is in
the
system and that it operates properly. This is often called an Operational Qualification.
However, note that even if some of the requirements do not seem to be “Operational”, this
Is an operational test. For example, the software may be required to display
copyright message on all acquired components.

20
3. Performance Qualification: These are not “errors” as such but failures to
conform to performance requirements. Technically, they can be part of the second
type.
However, Performance Qualification (PQ) became a standard way of testing for
historical reasons. Some systems will perform differently under different loads and
conditions. For example, a citizen lookup application may need to operate within a
specific time response for a load of up to 300 queries an hour. The software applica-
tion may be designed properly, ie, may pass the Operational Qualification, but may
fail to meet the required loads because of poor programming or too many database
calls.

5.2 Types of Testing

Software testing is a process of running with intent of finding errors in software.

Software testing assures the quality of software and represents final review of other
phases of software like specification, design, code generation etc.

Unit Testing
Unit testing emphasizes the verification effort on the smallest unit of software
design i.e.; a software component or module. Unit testing is a dynamic method for
verification, where program is actually compiled and executed. Unit testing is performed
in parallel with the coding phase. Unit testing tests units or modules not the whole
software.
I have tested each view/module of the application individually. As the modules
were built up testing was carried out simultaneously, tracking out each and every kind of
input and checking the corresponding output until module is working correctly.
The functionality of the modules was also tested as separate units. Each of the
three modules was tested as separate units. In each module all the functionalities were
tested in isolation.
In the Shop Products Module when a product has been added to cart it has been
made sure that if the item already exists in the shopping cart then the quantity is increased

21
by one else a new item is created in the shopping cart. Also the state of the system after a
product has been dragged in to the shopping cart is same as the state of the system if it
was added by clicking the add to cart button. Also it has been ensured that all the images
of the products displayed in the shop products page are drag gable and have the product
property so that they can be dropped in the cart area.
In the Product Description Module it has been tested that all the images are
displayed properly. Users can add review and the as soon as a user adds a review it is
updated in the view customer review tab. It has been checked to see if the whole page
refreshes or a partial page update happens when a user writes a review.
In the Cart Details it has been tested that when a user edits a quantity or removes
a product from the cart, the total price is updated accordingly. It has been checked to see
if the whole page refreshes or a partial page update happens when a user edits the cart.
Visual Studio 2008 has in built support for testing the application. The unit testing
can be done using visual studio 2008 without the need of any external application.
Various methods have been created for the purpose of unit testing. Test cases are
automatically generated for these methods. The tests run under the [Link] context
which means settings from [Link] file are automatically picked up once the test case
starts running.
Methods were written to retrieve all the manufacturers from the database,
strings that match a certain search term, products that match certain filter criteria, all
images that belong to a particular product etc.

Integration Testing
In integration testing a system consisting of different modules is tested for
problems arising from component interaction. Integration testing should be developed
from the system specification. Firstly, a minimum configuration must be integrated and
tested.
In my project I have done integration testing in a bottom up fashion i.e. in this
project I have started construction and testing with atomic modules. After unit testing the
modules are integrated one by one and then tested the system for problems arising from
component interaction.

22
Validation Testing

It provides final assurances that software meets all functional, behavioral & performance
requirement. Black box testing techniques are used.
There are three main components
- Validation test criteria (no. in place of no. & char in place of char)
- Configuration review (to ensure the completeness of s/w configuration.)
- Alpha & Beta testing-Alpha testing is done at developer’s site i.e. at home & Beta
testing once it is deployed. Since I have not deployed my application, I could not do the
Beta testing.
Test Cases- I have used a number of test cases for testing the product. There were
different cases for which different inputs were used to check whether desired output is
produced or not.
1. Addition of a new product to the cart should create a new row in the shopping cart.
2. Addition of an existing product to the cart has to update the quantity of the product.
3. Any changes to items in the cart have to update the summary correctly.
4. Because same page is inserting data into more than one table in the database atomicity of
the transaction is tested

23
5.3 Testing Methods Used

BLACK BOX TESTING

Also known as functional testing. Software testing technique whereby the internal
workings of the item being tested are not known by the tester. For example, in a black box
test on software design the tester only knows the inputs and what the expected outcomes
should be and not how the program arrives at those outputs. The tester does not ever
examine the programming code and does not need any further knowledge of the program
other than its specifications.
The advantages of this type of testing include:
a. The test is unbiased because the designer and the tester are independent of each other.
b. The test is done from the point of view of the user, not the designer.
c. Test cases can be designed as soon as the specifications are complete.
The disadvantages of this type of testing include:
a. The test can be redundant if the software designer has already run a test case.
b. The test cases are difficult to design.
c. Testing every possible input stream is unrealistic because it would take an inordinate
amount of time; therefore, many program paths will go untested.

WHITE BOX TESTING

The purpose of any security testing method is to ensure the robustness of a system in the face
of malicious attacks or regular software failures. White box testing is performed based on the
knowledge of how the system is implemented. White box testing includes analyzing data
flow, control flow, information flow, coding practices, and exception and error handling
within the system, to test the intended and unintended software behavior. White box testing
can be performed to validate whether code implementation follows intended design, to vali-
date implemented security functionality, and to uncover exploitable vulnerabilities.

24
White box testing requires access to the source code. Though white box testing can be per-
formed any time in the life cycle after the code is developed, it is a good practice to perform
white box testing during the unit testing phase.

White box testing requires knowing what makes software secure or insecure, how to think
like an attacker, and how to use different testing tools and techniques. The first step in white
box testing is to comprehend and analyze source code, so knowing what makes software se-
cure is a fundamental requirement. Second, to create tests that exploit software, a tester must
think like an attacker. Third, to perform testing effectively, testers need to know the different
tools and techniques available for white box testing.

GREY BOX TESTING

Gray box testing is a software testing technique that uses a combination of black box testing
and white box testing. Gray box testing is not black box testing, because the tester does know
some of the internal workings of the software under test. In gray box testing, the tester applies
a limited number of test cases to the internal workings of the software under test. In the
remaining part of the gray box testing, one takes a black box approach in applying inputs to
the software under test and observing the outputs.
Gray box testing is a powerful idea. The concept is simple; if one knows something about
how the product works on the inside, one can test it better, even from the outside. Gray box
testing is not to be confused with white box testing; i.e. a testing approach that attempts to
cover the internals of the product in detail. Gray box testing is a test strategy based partly on
internals. The testing approach is known as gray box testing, when one does have some
knowledge, but not the full knowledge of the internals of the product one is testing.
In gray box testing, just as in black box testing, you test from the outside of a product, just as
you do with black box, but you make better-informed testing choices because you're better
informed; because you know how the underlying software components operate and interact

25
5.4 Testing Results and analysis

The application can be used for any Ecommerce application. It is easy to use, since it
uses the GUI provided in the user dialog. User friendly screens are provided. The
application is easy to use and interactive making online shopping a recreational
activity for users. It has been thoroughly tested and implemented.

26
 CHAPTER 5

System Design

 Use case diagram

 Class Diagram
 Sequence Diagram
 Data flow diagram

27
 Use Case Diagram:

 Use case diagram consists of use cases and actors and shows the interaction
between them. The key points are:

 The main purpose is to show the interaction between the use cases and the
actor.

 To represent the system requirement from user’s perspective.

 The use cases are the functions that are to be performed in the module.

Add Category

View
Category
ADMINSYSTEM

 Use Case Diagram

between ADMIN
and SYSTEM:

Fig.5.1

Sign Up

Add Pet

Buy now

Fig.5.2

Use Case USER Diagram between USER and SYSTEM

SYSTEMER- Diagram

Pet id
User name 28
 Sub category

Admin

Add ID

name
Pet id Relation seller_id

Sub category
password

color pet_info registration

Image mobile

image
email

Piece
m Status

description seller_id

CHAPTER 6

User Screens and Report

Output screens
29
 HOME PAGE

NEW USER REGISTRATION

30
SIGN IN PAGE

31
ONLINE NEW ARRIVALS PET

32
PET DASBOARD

33
ADD SHOPING CART

34
35
ADMIN LOGIN PAGE

36
ADD NEW CATEGORY

37
VIEW ADD NEW CATEGORY

38
VIEW ADD NEW PET

CHAPTER 7

coding

39
 Code of PHP

<?php
require_once"[Link]";
//require_once"[Link]";
##################################################
if(isset($_REQUEST['submit']))
{
extract($_REQUEST);
$n=iud("INSERT INTO `addcart`( `userid`, `petid`, `sub_cat`) VALUES
('$userid','$petid','$sub_cat')");
if($n==1)
{
echo"<script>alert('successfully Added');
[Link]='[Link]';
</script>";
}

}
##################################################
if(isset($_REQUEST['buynow']))
{
//echo "djfgj";
extract($_REQUEST);
$n=iud("INSERT INTO `buy`( `userid`, `sellerid`, `petid`, `sub_cat`) VALUES
('$userid','$seller_id','$petid','$sub_cat')");
if($n==1)
{
echo"gjkjgk";
$p=iud("UPDATE `pet_info` SET `status`=b'0' WHERE `pet_id`='$petid'");
if($p==1)
{
echo"<script>alert('successful Placed We Will Contact You Soon ');
[Link]='[Link]';
</script>";
}
}

}
##################################################
if(isset($_REQUEST['signup']))
{
$name=trim($_REQUEST['name']);
$mobile=trim($_REQUEST['mobile']);
$email=trim($_REQUEST['email']);
$password=trim($_REQUEST['password']);
$cpassword=trim($_REQUEST['cpassword']);

40
 $valid=true;
$query="insert into user (name,mobile,email,password)
values
('$name','$mobile','$email','$password')";
if(checklength($name,2))
{
echo"invalid name";
$valid=false;
}
if(!checkmobile($mobile))
{
echo"invalid mobile";
$valid=false;
}
if(!checkemail($email))
{
echo"invalid email";
$valid=false;
}
if(checklength($password, 6))
{
echo"invalid password";
$valid=false;
}
if($password!=$cpassword)
{
echo"password not match";
$valid=false;
}
if($valid)
{
$n=iud($query);
if($n==1)
{
echo"1";
}
else
{
echo"something wrong";
}
}
}
###########################################################
if(isset($_REQUEST['login']))
{

$email=trim($_REQUEST['Email']);
$password=trim($_REQUEST['Password']);

$valid=true;

41
 $query="select * from registration where email='$email' and password='$password'";

if($valid)
{
$login_data=select($query);
$n=mysqli_num_rows($login_data);
if($n==1)
{
while($data=mysqli_fetch_array($login_data))
{
extract($data);

$_SESSION['sellerid']=$seller_id;
$_SESSION['name']=$name;
//$_SESSION['image']=$image;
$_SESSION['login']="yes";

//echo"1";
header("location:[Link]");
}
else
{
echo"email or password is incorrect";
}
}

#############################################
if(isset($_REQUEST['change']))
{
$userid=$_SESSION['userid'];
$oldpassword=trim($_REQUEST['oldpassword']);
$newpassword=trim($_REQUEST['newpassword']);
$cpassword=trim($_REQUEST['cpassword']);
$valid=true;
$query="update user set password='$newpassword' where password='$oldpassword'
and userid='$userid'";

if(checklength($oldpassword, 12))
{
echo"invalid old password";
$valid=false;
}
if(checklength($newpassword, 12))

42
 {
echo"invalid New password";
$valid=false;
}
if($cpassword!=$newpassword)
{
echo"both password not matched";
$valid=false;
}
if($valid)
{
$n=iud($query);

if($n==1)
{
echo"1";
}
else
{
echo"something wrong";
}
}

#######################################################
if(isset($_REQUEST['forget']))
{
$email=trim($_REQUEST['email']);

$time=time();
$otp=md5($email.$time);
$valid=true;
if(strlen($otp)!=32)
{
echo "invalid otp";
$valid=false;
}
if(!checkemail($email))
{
echo"invalid email";
$valid=false;
}

$query="update user set otp='$otp' where email='$email' ";

if($valid){
$n=iud($query);
if($n==1)
{

43
 echo"1";
}
else
{
echo"invalid forget password";
}
}
}

################################################
if(isset($_REQUEST['reset']))
{
$otp=trim($_REQUEST['otp']);
$newpassword=trim($_REQUEST['newpassword']);
$cpassword=trim($_REQUEST['cpassword']);
$valid=true;
if(strlen($otp)!=32)
{
echo"invalid otp";
$valid=false;
}
if(checklength($newpassword, 6))
{
echo"invalid New password";
$valid=false;
}
if($cpassword!=$newpassword)
{
echo"Password and Confirm Password is not match";
$valid=false;
}
$query="update user set password='$newpassword',otp='' where otp='$otp'";

if($valid)
{
$n=iud($query);
if($n==1)
{
echo"1";
}
else
{
echo "something wrong";
}
}
}
###########################################################################
if(isset($_REQUEST['upload']))
{

44
$error=$_FILES["myfile"]["error"];

$name=$_FILES["myfile"]["name"];
$type=$_FILES["myfile"]["type"];
$size=$_FILES["myfile"]["size"];
$tmp_name=$_FILES["myfile"]["tmp_name"];
$userid=$_SESSION['userid'];
$query="update user set image='$name' where userid='$userid'";

if(move_uploaded_file($tmp_name,"images/$name"))
{
$n=iud($query);
if($n==1)
{
$_SESSION['image']=$name;
echo"<script>alert('Image uploaded successfully');
[Link]='change_image.php';
</script>";
}

}
else
{
echo"image is not upload";
}

}
##########################################################################
if(isset($_REQUEST['project_submit']))
{
extract($_REQUEST);
$error=$_FILES["image"]["error"];

$name=$_FILES["image"]["name"];
$type=$_FILES["image"]["type"];
$size=$_FILES["image"]["size"];
$tmp_name=$_FILES["image"]["tmp_name"];

$query="insert into project ( `title`, `keyword`, `mdiscription`, `category`, `image`,

`videolink`, `discription`) values
('$title','$metakey','$metadis','$category','$name','$video_link','$projectdis')";

if(move_uploaded_file($tmp_name,"images/$name"))
{
$n=iud($query);
if($n==1)

45
 {

echo"<script>alert('Project uploaded successfully');

[Link]='view_project_list.php';
</script>";
}

}
else
{
echo"Project is not upload";
}
}
###########################################################################
########################
if(@$_REQUEST['delete']=='yes')
{
$id=$_REQUEST['id'];
$n=iud("DELETE FROM `category` WHERE CategoryID='$id'");
if($n==1)
{
header("location:view_category.php");
}
else
{
echo"<script>alert('Something Wrong');
[Link]='view_category.php';
</script>";
}
}
###############################################

if(@$_REQUEST['edit']=='yes')
{
$id=$_REQUEST['id'];
header("location:edit_project.php?id=$id");
}
###################################################
if(@$_REQUEST['pdelete']=='yes')
{
$id=$_REQUEST['pid'];
$n=iud("DELETE FROM `price` WHERE PriceID='$id'");
if($n==1)
{
header("location:view_price.php");
}
else
{
echo"<script>alert('Something Wrong');
[Link]='view_price.php';

46
 </script>";
}
}
##################################################

if(@$_REQUEST['pedit']=='yes')
{
$id=$_REQUEST['pid'];
header("location:edit_price.php?pid=$id");
}
##################################################
if(@$_REQUEST['deleteq']=='yes')
{
$id=$_REQUEST['qid'];
$q="UPDATE `question` SET `status`=b'0' WHERE QuestionID='$id'";
$n=iud($q);
if($n==1)
{
echo"<script>alert('DELETED');[Link]='select_view_lang.php';</script>";
//header("location:select_view_lang.php");
}
else
{
//Notice: Undefined index: qid in C:\xampp\htdocs\admin\edit_project.php on line 11

//echo"<script>alert('Something
Wrong');[Link]='question_view.php';</script>";
}
}
#################################################

if(@$_REQUEST['editq']=='yes')
{
$id=$_REQUEST['qid'];
header("location:edit_project.php?id=$id");
}
#################################################
if(isset($_REQUEST['Update_category']))
{
extract($_REQUEST);

echo $query="UPDATE `category` SET `Name`='$cat_update' WHERE

CategoryID='$cat_id'";

$n=iud($query);
if($n==1)
{

echo"<script>alert(' Updated successfully');

47
[Link]='view_category.php'; </script>";
}

else
{
echo"<script>alert('Something
Wrong');[Link]='view_category.php';</script>";
}
}
#####################################################################
if(isset($_REQUEST['Update_price']))
{
extract($_REQUEST);

echo $query="UPDATE `price` SET `Price_N`='$price_update' WHERE PriceID='$p_id'";

$n=iud($query);
if($n==1)
{

echo"<script>alert(' Updated successfully');

[Link]='view_price.php'; </script>";
}

else
{
echo"<script>alert('Something
Wrong');[Link]='view_price.php';</script>";
}
}
#####################################################################
if(isset($_REQUEST['blog_submit']))
{
echo"gkjhdkjghdkjh";
extract($_REQUEST);
$error=$_FILES["image"]["error"];

$name=$_FILES["image"]["name"];
$type=$_FILES["image"]["type"];
$size=$_FILES["image"]["size"];
$tmp_name=$_FILES["image"]["tmp_name"];

$query="insert into `blog`( `category`, `title`, `keyword`, `short_dis`, `image`,

`blog_dis`) VALUES
('$category','$title','$metakey','$shortdis','$name','$blogdis')";

if(move_uploaded_file($tmp_name,"images/$name"))

48
 {
$n=iud($query);
if($n==1)
{

echo"<script>alert('Blog uploaded successfully');

[Link]='view_blog_list.php';
</script>";
}

}
else
{
echo"<script>alert('Blog is not upload');
[Link]='view_blog_list.php';
</script>";
}
}
###########################################################################
##############
###########################################################################
########################
if(@$_REQUEST['blogdelete']=='yes')
{
$id=$_REQUEST['id'];
$n=iud("DELETE FROM `blog` WHERE blogid='$id'");
if($n==1)
{
header("location:view_blog_list.php");
}
else
{
echo"<script>alert('Something Wrong');
[Link]='view_blog_list.php';
</script>";
}
}
###############################################

if(@$_REQUEST['blogedit']=='yes')
{
$id=$_REQUEST['id'];
header("location:edit_blog.php?id=$id");
}
###########################################################
if(isset($_REQUEST['update_blog']))
{
extract($_REQUEST);
$error=$_FILES["uimage"]["error"];

49
$name=$_FILES["uimage"]["name"];
$type=$_FILES["uimage"]["type"];
$size=$_FILES["uimage"]["size"];
$tmp_name=$_FILES["uimage"]["tmp_name"];

$query="UPDATE `blog` SET

`category`='$ucategory',`title`='$utitle',`keyword`='$umetakey',`short_dis`='$ushortdis',`imag
e`='$name',`blog_dis`='$ublogdis' WHERE blogid='$ublogid'";

if(move_uploaded_file($tmp_name,"images/$name"))
{
$n=iud($query);
if($n==1)
{

echo"<script>alert('Blog Updated successfully');

[Link]='view_blog_list.php';
</script>";
}

}
else
{
echo"<script>alert('Blog is not Update ');
[Link]='view_blog_list.php';
</script>";
}
}
####################################################################
if(@$_REQUEST['delete_enquiry']=='yes')
{
$id=$_REQUEST['id'];

$n=iud("DELETE FROM `download_enquiry` WHERE cus_id='$id'");

if($n==1)
{
echo"<script>

alert('Successful');
[Link]='[Link]';
</script>";
}

else
{
echo"<script>alert('Something Wrong');
[Link]='[Link]';
</script>";
}

50
}

##########################################################################

?>

SQL CODE
-- phpMyAdmin SQL Dump
-- version 4.8.3
-- [Link]
--

51
-- Host: [Link]
-- Generation Time: Apr 16, 2019 at 08:50 AM
-- Server version: 10.1.36-MariaDB
-- PHP Version: 7.1.23

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT

*/;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION
*/;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `pet`
--

-- --------------------------------------------------------

--
-- Table structure for table `addcart`
--
create database pet;
use pet;

CREATE TABLE `addcart` (

`add_id` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`petid` int(11) NOT NULL,
`sub_cat` varchar(110) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `addcart`
--

INSERT INTO `addcart` (`add_id`, `userid`, `petid`, `sub_cat`) VALUES

(1, 1, 10, 'Siberian cat');

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

52
CREATE TABLE `admin` (
`id` int(5) NOT NULL,
`name` varchar(120) NOT NULL,
`email` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `name`, `email`, `password`) VALUES

(1, 'admin', 'admin@[Link]', '111111');

-- --------------------------------------------------------

--
-- Table structure for table `buy`
--

CREATE TABLE `buy` (

`buyid` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`sellerid` int(11) NOT NULL,
`petid` int(11) NOT NULL,
`sub_cat` varchar(110) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `buy`
--

INSERT INTO `buy` (`buyid`, `userid`, `sellerid`, `petid`, `sub_cat`) VALUES

(1, 1, 1, 5, 'Bull dog'),
(2, 3, 1, 20, 'Cockatoo'),
(3, 4, 1, 6, 'Indian pariah dog'),
(4, 5, 4, 30, 'Hulstlander');

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (

`category_id` int(3) NOT NULL,
`cat_name` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

53
--
-- Dumping data for table `category`
--

INSERT INTO `category` (`category_id`, `cat_name`) VALUES

(1, 'DOGS'),
(2, 'CATS'),
(4, 'RABBITS'),
(5, 'BIRDS'),
(6, 'HAMSTERS');

-- --------------------------------------------------------

--
-- Table structure for table `pet_info`
--

CREATE TABLE `pet_info` (

`pet_id` int(11) NOT NULL,
`sub_cat_id` int(11) NOT NULL,
`color` varchar(30) NOT NULL,
`image` varchar(50) NOT NULL,
`price` varchar(110) NOT NULL,
`description` varchar(110) NOT NULL,
`seller_id` int(11) NOT NULL,
`status` bit(1) NOT NULL DEFAULT b'1' COMMENT '1 for in stock 0 for out of stock'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pet_info`
--

INSERT INTO `pet_info` (`pet_id`, `sub_cat_id`, `color`, `image`, `price`, `description`,

`seller_id`, `status`) VALUES
(2, 2, 'white', '[Link]', '7000', 'cute', 1, b'0'),
(3, 1, 'Brown', '[Link]', '10000', 'Kombai Dog', 1, b'1'),
(4, 3, 'Black & Brown', '[Link]', '20000', 'Black & Brown', 1, b'1'),
(5, 4, 'Brown', '[Link]', '20000', 'bull dog', 1, b'0'),
(6, 5, 'Brown', 'Indian_Pariah_Dog-[Link]', '20000', 'testing', 1, b'0'),
(7, 6, 'white', '[Link]', '2000', 'testing', 1, b'1'),
(8, 7, 'white', '[Link]', '20000', 'semi persian cat testing discription', 1, b'1'),
(9, 8, 'Black & Brown', '[Link]', '20000', 'Inidan cat testing', 1, b'1'),
(10, 9, 'white and black', '[Link]', '3000', 'testing', 1, b'1'),
(11, 10, 'white & Brown', '[Link]', '7000', 'testing', 1, b'1'),
(12, 11, 'black', '[Link]', '2000', 'testing', 1, b'1'),
(13, 12, 'Brown', 'hollend_loop.jpg', '2000', 'testing', 1, b'1'),
(14, 13, 'white', '[Link]', '2000', 'testing', 1, b'1'),
(15, 14, 'Brown', 'german_p.jpg', '700', 'testing', 1, b'1'),
(16, 15, 'white', '[Link]', '700', 'testing', 1, b'1'),
(17, 16, 'Brown', '[Link]', '7000', 'testing', 1, b'1'),

54
(18, 17, 'green', '[Link]', '700', 'testing', 1, b'1'),
(19, 18, 'green', '[Link]', '3000', 'testing', 1, b'1'),
(20, 19, 'white', 'profile_167_600.jpg', '700', 'testing', 1, b'0'),
(21, 20, 'white', 'fantail_pigeon_OB_2.jpg', '2000', 'stytruytrur', 1, b'1'),
(22, 21, 'white', '[Link]', '70', 'testubfgggggg', 1, b'1'),
(23, 22, 'white', '[Link]', '70', 'testing', 1,
b'1'),
(24, 23, 'golden', '[Link]', '800', 'testing', 1, b'1'),
(25, 24, 'Black & Brown', '[Link]', '20000', 'testing', 1, b'1'),
(26, 25, 'golden', '[Link]', '800', 'testing', 1, b'1'),
(27, 1, 'Brown', '[Link]', '7000', 'combai', 2, b'1'),
(28, 6, 'white', '[Link]', '20000', 'testing', 3, b'1'),
(29, 26, 'white', '[Link]', '70', 'testing', 1, b'1'),
(30, 15, 'white', '[Link]', '20000', 'testing', 4, b'0');

-- --------------------------------------------------------

--
-- Table structure for table `registration`
--

CREATE TABLE `registration` (

`seller_id` int(3) NOT NULL,
`name` varchar(30) NOT NULL,
`mobile` varchar(13) NOT NULL,
`email` varchar(40) NOT NULL,
`password` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `registration`
--

INSERT INTO `registration` (`seller_id`, `name`, `mobile`, `email`, `password`) VALUES

(1, 'anup', '8269663728', 'anup@[Link]', '111111'),
(2, 'vishal', '8269663728', 'vishal@[Link]', '111111'),
(3, 'seller1', '4785698745', 'seller1@[Link]', '111111'),
(4, 'seller2', '7745896587', 'seller2@[Link]', '111111');

-- --------------------------------------------------------

--
-- Table structure for table `subcategory`
--

CREATE TABLE `subcategory` (

`sub_id` int(11) NOT NULL,
`cat_id` varchar(60) NOT NULL,
`sub_name` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

55
--
-- Dumping data for table `subcategory`
--

INSERT INTO `subcategory` (`sub_id`, `cat_id`, `sub_name`) VALUES

(1, '1', 'Combai'),
(2, '1', 'Indian Spitz'),
(3, '1', 'German Shepard'),
(4, '1', 'Bull dog'),
(5, '1', 'Indian pariah dog'),
(6, '2', 'Persian cat'),
(7, '2', 'Semi Persian cat'),
(8, '2', 'Indian cat'),
(9, '2', 'Siberian cat'),
(10, '2', 'Himalayan cat'),
(11, '2', 'mainecoon'),
(12, '4', 'Holland Lop'),
(13, '4', 'American Fuzzy Lop'),
(14, '4', 'German Lop'),
(15, '4', 'Hulstlander'),
(16, '4', 'English Lop'),
(17, '5', 'Love birds'),
(18, '5', 'Parrot'),
(19, '5', 'Cockatoo'),
(20, '5', 'Fantail pigeon'),
(21, '6', 'Winter white Dwarf hamsters'),
(22, '6', 'Roborovski hamsters'),
(23, '6', 'Golden hamsters'),
(24, '6', 'Chinese hamsters'),
(25, '6', 'Gansu hamsters'),
(26, '1', 'testing');

-- --------------------------------------------------------

--
-- Table structure for table `user_reg`
--

CREATE TABLE `user_reg` (

`user_reg_id` int(11) NOT NULL,
`name` varchar(60) NOT NULL,
`email` varchar(60) NOT NULL,
`password` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_reg`
--

56
INSERT INTO `user_reg` (`user_reg_id`, `name`, `email`, `password`) VALUES
(1, 'vishal', 'vishal@[Link]', '111111');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `addcart`
--
ALTER TABLE `addcart`
ADD PRIMARY KEY (`add_id`);

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
ADD PRIMARY KEY (`id`);

--
-- Indexes for table `buy`
--
ALTER TABLE `buy`
ADD PRIMARY KEY (`buyid`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `pet_info`
--
ALTER TABLE `pet_info`
ADD PRIMARY KEY (`pet_id`);

--
-- Indexes for table `registration`
--
ALTER TABLE `registration`
ADD PRIMARY KEY (`seller_id`);

--
-- Indexes for table `subcategory`
--
ALTER TABLE `subcategory`
ADD PRIMARY KEY (`sub_id`);

--

57
-- Indexes for table `user_reg`
--
ALTER TABLE `user_reg`
ADD PRIMARY KEY (`user_reg_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `addcart`
--
ALTER TABLE `addcart`
MODIFY `add_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `buy`
--
ALTER TABLE `buy`
MODIFY `buyid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
MODIFY `category_id` int(3) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `pet_info`
--
ALTER TABLE `pet_info`
MODIFY `pet_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `registration`
--
ALTER TABLE `registration`
MODIFY `seller_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `subcategory`
--
ALTER TABLE `subcategory`

58
MODIFY `sub_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `user_reg`
--
ALTER TABLE `user_reg`
MODIFY `user_reg_id` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=2;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

CHAPTER 8

Advantages & Limitations

59
 Advantages of “ Pet Shop Online Shopping project”:

“Pet Shop Online Shopping” provides various features, which

complement the information system and increase the productivity of the
system. These features make the system easily usable and convenient. Some of
the important features included are listed as follows:

 Intelligent User Forms Design

 Data access and manipulation through same forms
 Access to most required information
 Data Security
 Restrictive data access, as per login assigned only.
 Organized and structured storage of facts.
.
 Strategic Planning made easy.
 No decay of old Records.
 Exact financial position of the Business.

Limitations of “Pet Shop Online Shopping”:

Besides the above achievements and the successful completion of the project, we still
feel the project has some limitations, listed as below:

 It is not a large scale system.

 Only limited information provided by this system.

Future Scope

60
  Getting accurate information about what kind of books user likes and this information
in cookies, by which we can show recommended books to user.

 We offer Low price and best Offer for Pet Shop Online Shopping also in future.

BIBLIOGRAPHY

 FOR PHP INSTALLATION

 [Link]
61
  FOR DEPLOYMENT AND PACKING ON SERVER

[Link]
[Link]
[Link]

 FOR MY SQL

 [Link]

 FOR CSS

 [Link]

 FOR APACHE

 [Link]

 FOR OTHER USEFUL REFERENCES

 [Link]

 [Link]
 [Link]

 REFERENCE BOOKS

Lee Babin, “Beginning Ajax with PHP”.

Leon Atkinson,“ Core PHP Programming” .

62
Luke Welling & Laura Thompson, “Beginning Ajax with PHP”.
Roger [Link], “Software Engineering”.

63